DBCON connection issue - error CPDA0FF occured

[former_member206621]

We have the following connection defined in DBCO:

AS4_HOST=<host>;AS4_DB_LIBRARY=<library>;AS4_HOST_PORT=21;

When we check this connection via ADBC_TEST_CONNECTION we get the error:

B Connect to <con_name> as <user_name> with AS4_HOST=<host>;AS4_DB_LIBRARY=<library>;AS4_HOST_PORT=21;
C Secondary DB connect, user <user_name>
C Environment: AS4_HOST=<host>;AS4_DB_LIBRARY=<library>;AS4_HOST_PORT=21;
C  *** ERROR => CPDA0FF occured. Refer to job log.
 [dbsldb4dbi.c 474]
C  *** ERROR => === Secondary DB connect FAILED! ===
 [dbsldb4.cpp  15683]
C  *** ERROR => === Connection settings ===
 [dbsldb4.cpp  17806]
C  *** ERROR => connected               = FALSE
 [dbsldb4.cpp  17807]
...
C  *** ERROR => ===========================
 [dbsldb4.cpp  17849]
B  ***LOG BYI=> connect failed for connection DEPLIS     [dbds#1 @ 1052] [dbds    1052 ]
B  ***LOG BZY=> unexpected return code 8192       calling DBACDS     [dbacds#2 @ 1471] [dbacds  1471 ]

In SM21 - system log - we have 2 entries:

Connect to the databzse with ID <con_name> failed

Unexpeted return value 8192 when calling up DBACD

Any idea on how we can solve this?

[marie_renneke]

Hello together,

I know it's a pretty old discussion but we're facing a similar issue right now with a newly created dialog instance - CI connection is fine, dialog instance is throwing the exact same error as mentioned above.

How did you solve the problem?

Thanks & regards

Marie

[christoph_ostrop]

Hi, Marie,

it's been a while since I've configured once this szenario on our server:

there are some sapnotes:

http://service.sap.com/sap/support/notes/523381

and

http://service.sap.com/sap/support/notes/146624

is your dialog-instance on IBM-i ?

HTH

Christoph

[marie_renneke]

Hi Christoph,

thanks for the quick reaction.

The SAP system is running on AIX 6.1 with DB2 LUW 10.5 FP4.

Thank you for mentioning note 146624 - I've checked the xdnxdaapi* and dbdb4slib* libraries in all possible exe directories of the DI - they exist in the same version as on the CI.

The only difference I see now, is that the CI has the full DB2 software package installed where the DI only had the CLI driver. We've already installed the DB2 Runtime Client for LUW in Version 10.5.4 on the DI server, hoping it might help - still getting the same error.

I couldn't find any documenation or note on how to setup such a connection in a multi-instance environment...

I asked our customer to check the target database - I'm afraid there might be some restrictions like max. connections or the like that keep disturbing the connection.

I just answered to this old discussion, because I hoped someone would remember how the problem had been solved back then...

I'll let you know as soon as I've got any news.

Thanks & regards

Marie

[volker_gldenpfennig]

Hi Marie,

you should be aware of, that this threat was for DB4 and not DB2 ...

Therefore, the XDN stuff and the dbdb4slib information is wrong for you ...

You should try to ask your question in the DB6 area (DB2 LUW for windows & linux & AIX).

Regards,

Volker Gueldenpfennig, consolut international ag

[marie_renneke]

Hi Volker,

SAP is running on DB6 but we're trying to connect to a DB4 - that's where the problem occurs, so we need the libraries as I understand from the SAP notes.

Regards

Marie

[christoph_ostrop]

Hi,

our szenario:

we read some data from the source system (non-SAP) into our SAP-BW on IBM-i:

target-system:   SAP-BW on IBM-i and IBM DB2-for-i (DB2/400)

source-system   IBM-i and IBM DB2-for-i (DB2/400)  with some legacy-Data (non-SAP)

so we did on the source-system

- restored the kernel-library SAP<SID>IND   (copy of the library from the SAP-BW system)

- created a CLP-batchjob SBMJOB CMD(CALL XDNSTART) , that causes a running XDNLISTEN-Job

SBMJOB	CMD(CALL PGM(&KERNELLIB/XDNLISTEN) +
	PARM('-tf/tmp/XDNTrace')) JOB(XDNLISTEN) +
	JOBD(QBATCH) JOBQ(QSYS/QUSRNOMAX) LOG(4 +
	*JOBD *SECLVL) ALWMLTTHD(*YES)

Subsystem/Job Benutzer    Art   CPU % Funktion        Status   .

QUSRWRK QSYS        SBS 0,0 DEQW 

  XDNLISTEN  QSECOFR     BCH     0,0 PGM-XDNLISTEN    TIMA 

i do not know, if on DB6 is a corresponding thing like XDNLISTEN

Christoph

[volker_gldenpfennig]

Hi Marie,

yes, then you are correct and the problem can be solved ;-))

Regards,

Volker Gueldenpfennig, consolut international ag

[former_member206621]

see SAP note 751451: the product version of qxdaedrs.dll should be the same as your AS/400 product version + iSeries Access should be installed on the SAP server (see also: http://www-01.ibm.com/support/docview.wss?uid=nas2137f687b04e98914862570f20041f23b)

[JMorozowski]

I am running into the same error. Did replacing the XDA files solve the issue for you?