Tom_Davidson
VIP Member
We are trying to set up System i to System i communications to allow foreign tables in TC from one to the other.
We have added the RDB entry on the table with JDE on it. Created the datasource pointing to the 400 with the foreign tables. Have DDM working between the two boxes.
When we run the TC on the System i we get a message that we failed to get the columns:
JDE LOG:
491/5 MAIN_THREAD Mon Aug 20 20:23:50.437408 dbdrv_log.c196
OS400LI003 - initSQLCLIstructures:SQLConnect failed with Relation
The UBE finishes with:
491/5 MAIN_THREAD Mon Aug 20 20:23:51.504128 ipcmisc.c299
API ipcSawUnregisterProcV1 : process 491 unregistered in entry 20
491/5 MAIN_THREAD Mon Aug 20 20:23:51.506032 runbatch.c1287
PrintUBE failed, refer to joblog of job 008788/JDE /R570101Z for additional information.
491/5 MAIN_THREAD Mon Aug 20 20:23:51.506288 runbatch.c1303
Job of type UBE failed with rcode = 0
491/5 MAIN_THREAD Mon Aug 20 20:23:51.513000 runbatch.c1357
Batch job 144 ended in error
491/5 MAIN_THREAD Mon Aug 20 20:23:51.513984 zdrv.cpp389
Terminating Z driver
491/5 MAIN_THREAD Mon Aug 20 20:23:51.514152 zdrv.cpp406
Calling freeSession
491/5 MAIN_THREAD Mon Aug 20 20:23:51.651280 dbdrv_log.c196
OS400QL003 - DisconnectDB:Handle: '2' to DS 'Business Data - CV' in DB 'Business Data - CV' on Server DB 'TWINCO' via 'T' connection - unable to disconnect. QCPFMSG *LIBL - CPFB752 - Internal error in &2 API
We are on 8.12 Tools 8.96 OS/400: V5R4 for the JDE box and V5R3 for the foreign table box.
Any ideas would be much appreciated.
Tom Davidson
We have added the RDB entry on the table with JDE on it. Created the datasource pointing to the 400 with the foreign tables. Have DDM working between the two boxes.
When we run the TC on the System i we get a message that we failed to get the columns:
JDE LOG:
491/5 MAIN_THREAD Mon Aug 20 20:23:50.437408 dbdrv_log.c196
OS400LI003 - initSQLCLIstructures:SQLConnect failed with Relation
The UBE finishes with:
491/5 MAIN_THREAD Mon Aug 20 20:23:51.504128 ipcmisc.c299
API ipcSawUnregisterProcV1 : process 491 unregistered in entry 20
491/5 MAIN_THREAD Mon Aug 20 20:23:51.506032 runbatch.c1287
PrintUBE failed, refer to joblog of job 008788/JDE /R570101Z for additional information.
491/5 MAIN_THREAD Mon Aug 20 20:23:51.506288 runbatch.c1303
Job of type UBE failed with rcode = 0
491/5 MAIN_THREAD Mon Aug 20 20:23:51.513000 runbatch.c1357
Batch job 144 ended in error
491/5 MAIN_THREAD Mon Aug 20 20:23:51.513984 zdrv.cpp389
Terminating Z driver
491/5 MAIN_THREAD Mon Aug 20 20:23:51.514152 zdrv.cpp406
Calling freeSession
491/5 MAIN_THREAD Mon Aug 20 20:23:51.651280 dbdrv_log.c196
OS400QL003 - DisconnectDB:Handle: '2' to DS 'Business Data - CV' in DB 'Business Data - CV' on Server DB 'TWINCO' via 'T' connection - unable to disconnect. QCPFMSG *LIBL - CPFB752 - Internal error in &2 API
We are on 8.12 Tools 8.96 OS/400: V5R4 for the JDE box and V5R3 for the foreign table box.
Any ideas would be much appreciated.
Tom Davidson