TC with foreign tables not running on server

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

Have you looked at the OCM entries for the Server Map? The Client looks at
the System OCM entries for where to find things but the Server looks at the
Server Map OCM's. The Server map OCM's are not automatically updated when
you create a new env.

Just a thought. I haven't actually done this myself.

Regards and Good Luck,

Gerald






e46mike
<mike_chang00@hot To: Gerald Kastanek/Toronto/IBM@IBMCA
mail.com> cc:
Sent by: Subject: TC with foreign tables not running on server
owner-jdelist@jde
list.com


11/05/2002 05:42
PM
Please respond to
jdelist





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=12!
52, 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 2!
002 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
--------------------------
To view this thread, go to:
http://www.jdelist.com/ubb/showthreaded.php?Cat=&Board=OW&Number=44663
+ - - - - - - - - - - - - - - - - - - - - - - - -+
This is the JDEList One World® / XE mailing list/forum.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found on the JDEList Forum at
http://www.JDEList.com

JDEList is not affiliated with JDEdwards®

+ - - - - - - - - - - - - - - - - - - - - - - - -+

Yes, the server map OCM are created for the environment and for the objects that are accessed. The TC will just fail. And I'm out of ideas.

Does the relational Database Entry exist for the database named ACSDALM01 on the AS/400. Use the WRKRDBDIRE command to check the name that the system's database has been given.

If you system does not have a *local Database name, then use the ADDRDBDIRE command to add the ACSDALM01 system as the local database name. I may not be correct on this, but I think that the names of the relational databases may be restricted to 8 characters.


Hope this works for you.


andy

The relational database entry does have ACSDALM01 listed. However, it is not set to *LOCAL. The AS400 serial name is set to *LOCAL. I cannot change this without knowing just what type of impact it will have on users that are accessing other applications on that server.

We are actually getting garbage characters as the error messages now. It is a SQL error but the error code is unreadable.

As far as we can figure out, TC will not run on the server. But there shouldn't be any reason why it wouldn't run.

Mike,

I had a simlar issue in the past, where the Database name was the serial number of the AS/400 and the TC's would not run. When OneWorld attempts to access a foreign table, it looks at the RDB name with the *LOCAL address.

After changing this, the problem went away.

When I made this change, the only things that I had to change in advance were RPGSQL programs that made remote calls to this system. And I am aware of some old LANSA programs that used this name (for what I don't know).


Hope this helps.

AM