e46mike
Member
Here is the issue. I have a custom TC that access a foreign table in our current env. TC runs successfully when executed locally. It fails with a SQL error when ran on our as400 enterprise server. The SQL error code returns a RDB error.
here is the jde.log:
942 Thu Oct 31 10:40:06 2002 runbatch.c382
INITIALIZING RUNBATCH job: 1818
942 Thu Oct 31 10:40:06 2002 ipcpub.c3121
process 942 <B7333SYS/PRINTUBE> registered in entry 7
942 Thu Oct 31 10:40:06 2002 runbatch.c632
Startup for User=BHAMBHANIS, Env=DV7333, Job#=1818
942 Thu Oct 31 10:40:08 2002 CALLBSFN(B0000182)1471
XXX0000001 - GetProfileHandle failed for , error =CPF2204
942 Thu Oct 31 10:40:08 2002 CALLBSFN(B0000182)693
XXX0000001 - GetProfileHandle failed for , error =CPF2204
942 Thu Oct 31 10:40:09 2002 runbatch.c1124
RUNBATCH: Remote CP=1252, Remote OS=5, Local CP=37, ConvertToASCII=0
942 Thu Oct 31 10:40:09 2002 CALLBSFN(B0000182)1471
XXX0000001 - GetProfileHandle failed for , error =CPF2204
942 Thu Oct 31 10:40:09 2002 CALLBSFN(B0000182)693
XXX0000001 - GetProfileHandle failed for , error =CPF2204
942 Thu Oct 31 10:40:10 2002 CALLBSFN(B0000182)1471
XXX0000001 - GetProfileHandle failed for , error =CPF2204
942 Thu Oct 31 10:40:10 2002 CALLBSFN(B0000182)693
XXX0000001 - GetProfileHandle failed for , error =CPF2204
942 Thu Oct 31 10:40:11 2002 dbdrvcli.c104
OS40001090 - SQL error: SQLSTATE = 08004, Error Code = -30061, Relational database ACSDALM01 not found.
942 Thu Oct 31 10:40:11 2002 dbdrv.c1000
OS40001025 - Unable to get table spec. numbers
942 Thu Oct 31 10:40:11 2002 jdb_drvm.c1356
JDB9900184 - Failed to get table specs from db
942 Thu Oct 31 10:40:11 2002 jdb_rq1.c6142
JDB9900275 - Failed to get foreign table specs
942 Thu Oct 31 10:40:11 2002 jdb_rq1.c5962
JDB3100050 - Failed to load table information
942 Thu Oct 31 10:40:11 2002 tcinit.c1075
TCE009101 - Couldn't open F4201SPB.
942 Thu Oct 31 10:40:12 2002 ipcpub.c3432
API ipcSawUnregisterProcV1 : process 942 unregistered in entry 7
942 Thu Oct 31 10:40:12 2002 runbatch.c1385
Processing PrintUBE request failed - see previous messages
942 Thu Oct 31 10:40:12 2002 runbatch.c1395
Job of type UBE failed with rcode = 0
-----------------------
Anyone have any ideas how we can successfully run a custom TC that access a foreign table on the server.
Xe sp19.1 update 6
as400 v5r1
win2k sp2
thanks in advance
here is the jde.log:
942 Thu Oct 31 10:40:06 2002 runbatch.c382
INITIALIZING RUNBATCH job: 1818
942 Thu Oct 31 10:40:06 2002 ipcpub.c3121
process 942 <B7333SYS/PRINTUBE> registered in entry 7
942 Thu Oct 31 10:40:06 2002 runbatch.c632
Startup for User=BHAMBHANIS, Env=DV7333, Job#=1818
942 Thu Oct 31 10:40:08 2002 CALLBSFN(B0000182)1471
XXX0000001 - GetProfileHandle failed for , error =CPF2204
942 Thu Oct 31 10:40:08 2002 CALLBSFN(B0000182)693
XXX0000001 - GetProfileHandle failed for , error =CPF2204
942 Thu Oct 31 10:40:09 2002 runbatch.c1124
RUNBATCH: Remote CP=1252, Remote OS=5, Local CP=37, ConvertToASCII=0
942 Thu Oct 31 10:40:09 2002 CALLBSFN(B0000182)1471
XXX0000001 - GetProfileHandle failed for , error =CPF2204
942 Thu Oct 31 10:40:09 2002 CALLBSFN(B0000182)693
XXX0000001 - GetProfileHandle failed for , error =CPF2204
942 Thu Oct 31 10:40:10 2002 CALLBSFN(B0000182)1471
XXX0000001 - GetProfileHandle failed for , error =CPF2204
942 Thu Oct 31 10:40:10 2002 CALLBSFN(B0000182)693
XXX0000001 - GetProfileHandle failed for , error =CPF2204
942 Thu Oct 31 10:40:11 2002 dbdrvcli.c104
OS40001090 - SQL error: SQLSTATE = 08004, Error Code = -30061, Relational database ACSDALM01 not found.
942 Thu Oct 31 10:40:11 2002 dbdrv.c1000
OS40001025 - Unable to get table spec. numbers
942 Thu Oct 31 10:40:11 2002 jdb_drvm.c1356
JDB9900184 - Failed to get table specs from db
942 Thu Oct 31 10:40:11 2002 jdb_rq1.c6142
JDB9900275 - Failed to get foreign table specs
942 Thu Oct 31 10:40:11 2002 jdb_rq1.c5962
JDB3100050 - Failed to load table information
942 Thu Oct 31 10:40:11 2002 tcinit.c1075
TCE009101 - Couldn't open F4201SPB.
942 Thu Oct 31 10:40:12 2002 ipcpub.c3432
API ipcSawUnregisterProcV1 : process 942 unregistered in entry 7
942 Thu Oct 31 10:40:12 2002 runbatch.c1385
Processing PrintUBE request failed - see previous messages
942 Thu Oct 31 10:40:12 2002 runbatch.c1395
Job of type UBE failed with rcode = 0
-----------------------
Anyone have any ideas how we can successfully run a custom TC that access a foreign table on the server.
Xe sp19.1 update 6
as400 v5r1
win2k sp2
thanks in advance