on 08-18-2014 10:06 PM
Hello,
I am trying to connect my BW system to external database on IBMi system (AS400). Here are the detail information
My SAP BW System
OS/DB- Windows2012/SQL2012
SAP: NW7.4
Kernel-7.41 64Bit Unicode
DBSL- Downloaded for AS/400(DB2/400)
SAR | lib_dbsl_47-10012479.sar | Database Library | 47 | Info | 4627 | 15.08.2014 |
After extracting this sar file got all these files
06/29/2014 05:35 PM 233,984 db4cncl.exe
06/29/2014 05:35 PM 887,808 db4cncl.pdb
06/29/2014 07:05 PM 1,739,776 dbdb4slib.dll
06/29/2014 07:05 PM 3,075,072 dbdb4slib.pdb
06/29/2014 06:36 PM 317,952 dbsldb4ccm.dll
06/29/2014 06:05 PM 365 patchesdb.mf
06/29/2014 05:36 PM 155,136 setdb4pwd.exe
06/29/2014 05:36 PM 584,704 setdb4pwd.pdb
07/04/2014 08:28 AM 5,520 SIGNATURE.SMF
06/29/2014 06:27 PM 243,712 xdnxdaapi.dll
External Source to which I am trying to connect - IBMi -AS400 (Version R611)
DBCO configuration on SAP BW system -
Database connection - BWAS400DEV
DBMS - DB4
Username - SAPUSR
*Password ***********
Connection Information - AS4_HOST=DVTEST;AS4_DB_LIBRARY=SAPUSR
Both the DBMS name and AS_DB_LIBRARY are same and in uppercase.
Following Profile Parameters is also set
dbs/db4/xdn_trace_file=XDNTrace
dbs/db4/connect_type= T
dbs/db4/xdn_port= 9601 ( this is my SAP BW messageserver number as per note-1875310 - IBM i: Incorrect XDN default port)
dbs/db4/driver_type=XDN
SAPHOST Agent is installed in SAP system but not on IBMi system. We are planing to install the SAPHOSTAgent on the IBMi system also.
Testing the connection via SE38-ADBC_TEST_CONNECTION - Select the -Database connection - BWAS400DEV and test the connection( I did testing from two system one has SAN NW gateway installed, but same error)
ERROR
Testing a Database Connection Defined in DBCON
Could not open connection BWAS400DEV
DBI error 16 occured.
See trace file for further info: dev_w 3
The dev_w 3 - shows
B Loading DB library 'F:\usr\sap\SB1\DVEBMGS00\exe\dbdb4slib.dll' ...
B Library 'F:\usr\sap\SB1\DVEBMGS00\exe\dbdb4slib.dll' loaded
B Version of 'F:\usr\sap\SB1\DVEBMGS00\exe\dbdb4slib.dll' is "741.10", patchlevel (0.41)
B Connect to BWAS400DEV as SAPUSR with AS4_HOST=DVTEST;AS4_DB_LIBRARY=SAPUSR
C DB4 SQL Reparse Activated
C Windows 2008 R2 - XDN Default
C Secondary DB connect, user SAPUSR
C Environment: AS4_HOST=DVTEST;AS4_DB_LIBRARY=SAPUSR
C *** ERROR => EXEC SQL connect: AS4_DB_LIBRARY invalid
[dbsldb4.cpp 18043]
C {root-id=005056810E3C1ED489E30965816320CF}_{conn-id=00000000000000000000000000000000}_0
C *** ERROR => CPDA0FF occured: XDNXDAAPI:BuildTCPConnection: Can't Connect to:.
[dbsldb4dbi.c 502]
C *** ERROR => === Secondary DB connect FAILED! ===
[dbsldb4.cpp 17852]
C *** ERROR => === Connection settings ===
[dbsldb4.cpp 20085]
C *** ERROR => connected = FALSE
[dbsldb4.cpp 20086]
C *** ERROR => con_hdl = 1
[dbsldb4.cpp 20087]
C *** ERROR => db_handle = 0
[dbsldb4.cpp 20088]
C *** ERROR => dbhost = DVTEST
[dbsldb4.cpp 20089]
C *** ERROR => dbhostport =
[dbsldb4.cpp 20090]
C *** ERROR => rdbname =
[dbsldb4.cpp 20091]
C *** ERROR => dblib =
[dbsldb4.cpp 20092]
C *** ERROR => r3sysle_changed = FALSE
[dbsldb4.cpp 20095]
C *** ERROR => query_compl_reval =
[dbsldb4.cpp 20096]
C *** ERROR => dbconnecttype =
[dbsldb4.cpp 20097]
C *** ERROR => user =
[dbsldb4.cpp 20098]
C *** ERROR => qaqqinilib = Default (QUSRSYS)
[dbsldb4.cpp 20102]
C *** ERROR => dbjobname =
[dbsldb4.cpp 20103]
C *** ERROR => dbjobuser =
[dbsldb4.cpp 20104]
C *** ERROR => dbjobno =
[dbsldb4.cpp 20105]
C *** ERROR => rmtexelib =
[dbsldb4.cpp 20106]
C *** ERROR => parallel_alter_tables = *OFF
[dbsldb4.cpp 20109]
C *** ERROR => ===========================
[dbsldb4.cpp 20128]
B ***LOG BYI=> connect failed for connection BWAS400DEV [dbds 929]
B ***LOG BZY=> unexpected return code 8192 calling DBDS [dbacds 1956]
Our Network Team did monitor the network traffic and confirmed nothing from going out from my SAP system to the AS400 system.
Any help/suggest is highly appreciated.
I have gone through all these Notes.
146624 DB Multiconnect for I series.pdf
1031096 - Installing Package SAPHOSTAGENT.pdf
1257635-1257635 - DB4 DBSL Direct Drive for DB2 for IBM i(DB2_AS400).pdf
146624 - IBM i Database Multiconnect for IBM DB2 for i.pdf
1541772 - DB4- Easy SAP Gateway Install on IBM i (EZ Gateway).pdf
1760513 - Inst. Standalone Gateway based on NW 7.0 & EHP 1-3.pdf
1875310 - IBM i- Incorrect XDN default port.pdf
323151-Several DB connections with Native SQL.pdf
523381 - BW- External DB connect for an IBM i database.pdf
751451 - iSeries- XDA Database client for Windows and LinuxPPC.pdf
283,931 AS400 Source System Connection.docx
808,286 Transferring Data with DB Connect.pdf
silly mistake or not I can say not know requirement, I was missing a semicolon(;) at the end of my configuration parameters in DBCO
Connection Information - AS4_HOST=DVTEST;AS4_DB_LIBRARY=SAPUSR;
After add the semicolon then tested the connection via SE38-ADBC_TEST_CONNECTION - Select the -Database connection - BWAS400DEV and tested the connection and it successful.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Volker,
We got the SAP HOST Agent installed on IBNM I host and started the XDN listener Job, its listing to Port 963.
But still no Luck.
Getting Same Error. I restart our SAP instance and also the hostAgent on the SAP side.
We also asked our IBMi team to restart the SAP Host Agent.
Exact Same Error. And our Network Team setup a traffic monitoring between SAP to IBM and he is saying no traffic is coming from SAP to the IBMi server
Error:
B Mon Aug 25 15:41:25 2014
B Loading DB library 'F:\usr\sap\SB1\DVEBMGS00\exe\dbdb4slib.dll' ...
B Library 'F:\usr\sap\SB1\DVEBMGS00\exe\dbdb4slib.dll' loaded
B Version of 'F:\usr\sap\SB1\DVEBMGS00\exe\dbdb4slib.dll' is "741.10", patchlevel (0.41)
N RSecSSFs: Configuration value "rsec/ssfs_datapath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_DATAPATH [D:/depot/bas/741_REL/src/krn/rsec/rsecssfs.c 5708]
N RSecSSFs: Configuration value "rsec/ssfs_keypath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_KEYPATH [D:/depot/bas/741_REL/src/krn/rsec/rsecssfs.c 5717]
N RSecSSFs: Reverting overwriting of profile by different environment (disabled in dw) [D:/depot/bas/741_REL/src/krn/rsec/rsecssfs.c 5727]
N RSecSSFs: Configuration value "rsec/ssfs_datapath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_DATAPATH [D:/depot/bas/741_REL/src/krn/rsec/rsecssfs.c 5708]
N RSecSSFs: Configuration value "rsec/ssfs_keypath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_KEYPATH [D:/depot/bas/741_REL/src/krn/rsec/rsecssfs.c 5717]
N RSecSSFs: Reverting overwriting of profile by different environment (disabled in dw) [D:/depot/bas/741_REL/src/krn/rsec/rsecssfs.c 5727]
B Connect to BWAS400DEV as KTSAPUSR with AS4_HOST=DVTEST;AS4_DB_LIBRARY=KTSAPUSR
C DB4 SQL Reparse Activated
C Windows 2008 R2 - XDN Default
C XDN-Port: Assuming 9600 + sapmsSB1 mod 100 = 9601
C Secondary DB connect, user KTSAPUSR
C Environment: AS4_HOST=DVTEST;AS4_DB_LIBRARY=KTSAPUSR
C *** ERROR => EXEC SQL connect: AS4_DB_LIBRARY invalid
[dbsldb4.cpp 18043]
C {root-id=005056810E3C1ED48B930260998960CF}_{conn-id=00000000000000000000000000000000}_0
C *** ERROR => CPDA0FF occured: XDNXDAAPI:BuildTCPConnection: Can't Connect to:.
[dbsldb4dbi.c 502]
We also Removed AS4_DB_LIBRARY from DBCO configuration to see what happen and we got this error
B Mon Aug 25 15:52:54 2014
B Loading DB library 'F:\usr\sap\SB1\DVEBMGS00\exe\dbdb4slib.dll' ...
B Library 'F:\usr\sap\SB1\DVEBMGS00\exe\dbdb4slib.dll' loaded
B Version of 'F:\usr\sap\SB1\DVEBMGS00\exe\dbdb4slib.dll' is "741.10", patchlevel (0.41)
N RSecSSFs: Configuration value "rsec/ssfs_datapath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_DATAPATH [D:/depot/bas/741_REL/src/krn/rsec/rsecssfs.c 5708]
N RSecSSFs: Configuration value "rsec/ssfs_keypath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_KEYPATH [D:/depot/bas/741_REL/src/krn/rsec/rsecssfs.c 5717]
N RSecSSFs: Reverting overwriting of profile by different environment (disabled in dw) [D:/depot/bas/741_REL/src/krn/rsec/rsecssfs.c 5727]
N RSecSSFs: Configuration value "rsec/ssfs_datapath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_DATAPATH [D:/depot/bas/741_REL/src/krn/rsec/rsecssfs.c 5708]
N RSecSSFs: Configuration value "rsec/ssfs_keypath" from profile explicitly overwritten by different value in environment variable RSEC_SSFS_KEYPATH [D:/depot/bas/741_REL/src/krn/rsec/rsecssfs.c 5717]
N RSecSSFs: Reverting overwriting of profile by different environment (disabled in dw) [D:/depot/bas/741_REL/src/krn/rsec/rsecssfs.c 5727]
B Connect to BWAS400DEV as KTSAPUSR with AS4_HOST=DVTEST
C DB4 SQL Reparse Activated
C Windows 2008 R2 - XDN Default
C XDN-Port: Assuming 9600 + sapmsSB1 mod 100 = 9601
C Secondary DB connect, user KTSAPUSR
C Environment: AS4_HOST=DVTEST
C *** ERROR => EXEC SQL connect: AS4_HOST invalid
[dbsldb4.cpp 17979]
C {root-id=005056810E3C1ED48B930260998960CF}_{conn-id=00000000000000000000000000000000}_0
C *** ERROR => CPDA0FF occured: XDNXDAAPI:BuildTCPConnection: Can't Connect to:.
[dbsldb4dbi.c 502]
Not sure why the traffic is not going.
We have a Direct SAPSQL connection using DBCO and that one is working perfectly.
Any suggestion what next.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Brajendra,
AS4_HOST and AS4_DB_LIBRARY are mandatory parameters. Make sure that the value you specify with AS4_DB_LIBRARY is an existing library on the IBM i system. A library is similar to a database schema. (Above I think I have seen that you have set it ot the name of the connect user, which might not necessarily be right.)
Best regards,
Dorothea
Hi,
you do NEED the saphostagent on System i, as this one brings the XDN interface, you do need ;-))
Please restart saphostagent once, as it forgets to start XDN trhe first time ...
have fun, is really running good 😉
Regards,
Volker Gueldenpfennig, consolut international ag
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.