SP23 S1 Upgrade Issues

Qbert6327

Member
Hi Listers,

We are currently on XE SP22 G1, and running into some issue when try to upgrade to SP23 S1. I know we miss a quite bit releases between, my question is have we have to applied each release in order to get SP23 S1 works?

The problem we are having now is we cant submit UBE jobs. In JDE.log, it show these error message:
50411 Wed Sep 12 16:38:33 2007 dbdrvsql.c1241
OS40002001 - Error Type: SQL sqlcode: -803

CPRCED API internal error!

16:38:23 2007 jdekdisp.c157
INITIALIZING UBE KERNEL

50411 Wed Sep 12 16:38:27 2007 combined.c344
RDEL0000045 - Could not open tables for reliable event delivery (F90703 and F90704). Reliable event delivery will be disabled

50411 Wed Sep 12 16:38:27 2007 jdb_drvm.c743
JDB9900164 - Failed to connect to WYATT - B7333 Server Map

50411 Wed Sep 12 16:38:27 2007 jtp_cm.c285
JDB9909003 - Could not init connect.

50411 Wed Sep 12 16:38:27 2007 jtp_tm.c960
JDB9909100 - Get connect info failed: Transaction ID =

50411 Wed Sep 12 16:38:27 2007 jdb_rq1.c1943
JDB3100013 - Failed to get connectinfo

50411 Wed Sep 12 16:38:27 2007 jdb_utl1.c2800
JDB9900354 - Failed to open F986111

50411 Wed Sep 12 16:38:32 2007 dbdrvsql.c449
OS40002001 - Error Type: OTHER enum: 6 - Illegabl connect handle specified!

50411 Wed Sep 12 16:38:32 2007 dbdrvag.c255
OS40001076 - DoPrepare: dbr->sql is null

50411 Wed Sep 12 16:38:32 2007 jdb_drvm.c887
JDB9900168 - Failed to initialize db request

50411 Wed Sep 12 16:38:32 2007 jtp_cm.c1090
JDB9909007 - Unable to obtain driver request handle

50411 Wed Sep 12 16:38:32 2007 jdb_utl1.c2821
JDB9900355 - Failed to Select from F986111

50411 Wed Sep 12 16:38:32 2007 dbdrvsql.c449
OS40002001 - Error Type: OTHER enum: 6 - Illegabl connect handle specified!

50411 Wed Sep 12 16:38:32 2007 dbdrvag.c255
OS40001076 - DoPrepare: dbr->sql is null

50411 Wed Sep 12 16:38:32 2007 jdb_drvm.c1299
JDB9900180 - Failed to rollback db connection

50411 Wed Sep 12 16:38:32 2007 jtp_tm.c1689
JDB9909106 - Failed to rollback connection

50411 Wed Sep 12 16:38:32 2007 dbdrvsql.c449
OS40002001 - Error Type: OTHER enum: 6 - Illegabl connect handle specified!

50411 Wed Sep 12 16:38:32 2007 dbdrvag.c255
OS40001076 - DoPrepare: dbr->sql is null

50411 Wed Sep 12 16:38:32 2007 jdb_drvm.c1299
JDB9900180 - Failed to rollback db connection

50411 Wed Sep 12 16:38:33 2007 jdb_drvm.c986
JDB9900401 - Failed to execute db request

50411 Wed Sep 12 16:38:33 2007 jdb_exet.c5224
JDB3400009 - Failed to perform Insert for F986110

50411 Wed Sep 12 16:38:33 2007 jdeknube.c1264
KNT0000086 - JDB_InsertTable failed for F986110


Any idea?

Thanks,

Carrie
---------------------------

OneWorld XE SP 22 G1 - World A7.3 - Coexistent
Enterprise AS400 (V5R2), NT Server
 
Carrie,
We tried SP23_S1 in our Test Environment and had similar issues. Simple UBEs like R0006P and R0010P worked fine, but anything advanced like Bill Of Materials or Payroll failed. I worked with Oracle Support on it for about 3 weeks before we backed of and applied an older Service Pack. We also tried SP23_R1, which tested out very well except for Payroll. SAR 8560934 addresses the issue we had with Payroll.

You do not need to apply each Service Pack since they are cumulative.


Here is a sample of what we were seeing in our UBE logs:

32738 Fri Aug 31 09:04:53 2007 dbdrvsql.c1241
OS40002001 - Error Type: SQL sqlcode: -601

Aug 31 09:04:41 2007 ipcpub.c3135
process 32738 <B73SPSYS/PRINTUBE> registered in entry 8

32738 Fri Aug 31 09:04:41 2007 runbatch.c680
Startup for User=AGREENE, Env=DM7333, Job#=1106084

32738 Fri Aug 31 09:04:47 2007 jdb_trig.c359
JDB3800024 - Trigger Library JDBTRG2 not found/loaded for table F41001.

32738 Fri Aug 31 09:04:47 2007 jdb_trig.c354
JDB9900886 - Fallback Trigger Library JDBTRIG not loaded.

32738 Fri Aug 31 09:04:47 2007 jdb_trig.c354
JDB9900886 - Fallback Trigger Library JDBTRIG not loaded.

32738 Fri Aug 31 09:04:47 2007 jdb_trig.c442
JDB9900340 - Failed to Get Proc address for F41001_INSERTBEFORE

32738 Fri Aug 31 09:04:47 2007 jdb_trig.c359
JDB3800024 - Trigger Library JDBTRG2 not found/loaded for table F41001.

32738 Fri Aug 31 09:04:47 2007 jdb_trig.c354
JDB9900886 - Fallback Trigger Library JDBTRIG not loaded.

32738 Fri Aug 31 09:04:47 2007 jdb_trig.c354
JDB9900886 - Fallback Trigger Library JDBTRIG not loaded.

32738 Fri Aug 31 09:04:47 2007 jdb_trig.c442
JDB9900340 - Failed to Get Proc address for F41001_UPDATEBEFORE

32738 Fri Aug 31 09:04:47 2007 jdb_trig.c359
JDB3800024 - Trigger Library JDBTRG2 not found/loaded for table F41001.

32738 Fri Aug 31 09:04:47 2007 jdb_trig.c354
JDB9900886 - Fallback Trigger Library JDBTRIG not loaded.

32738 Fri Aug 31 09:04:47 2007 jdb_trig.c354
JDB9900886 - Fallback Trigger Library JDBTRIG not loaded.

32738 Fri Aug 31 09:04:47 2007 jdb_trig.c442
JDB9900340 - Failed to Get Proc address for F41001_FETCHAFTER

32738 Fri Aug 31 09:04:49 2007 jdeobj.c1727
COB0000011 - Library load failed DM7333/CALLBSFN function jdeInitEnvBSFN Error = 0

32738 Fri Aug 31 09:04:49 2007 dbdrvcli.c107
OS40001090 - SQL error: SQLSTATE = 42977, Error Code = -7022, User zzagreene not the same as current user &2.

32738 Fri Aug 31 09:04:49 2007 jdb_drvm.c1586
JDB9900189 - Failed to verify that table exists in Business Data - CRP

32738 Fri Aug 31 09:04:49 2007 dbdrvcli.c107
OS40001090 - SQL error: SQLSTATE = 42977, Error Code = -7022, User zzagreene not the same as current user &2.

32738 Fri Aug 31 09:04:49 2007 jdb_drvm.c1586
JDB9900189 - Failed to verify that table exists in Business Data - CRP

32738 Fri Aug 31 09:04:49 2007 dbdrvcli.c107
OS40001090 - SQL error: SQLSTATE = 42977, Error Code = -7022, User zzagreene not the same as current user &2.

32738 Fri Aug 31 09:04:49 2007 jdb_drvm.c1586
JDB9900189 - Failed to verify that table exists in Business Data - CRP

32738 Fri Aug 31 09:04:49 2007 combined.c344
RDEL0000045 - Could not open tables for reliable event delivery (F90703 and F90704). Reliable event delivery will be disabled

32738 Fri Aug 31 09:04:51 2007 dbdrvcli.c107
OS40001090 - SQL error: SQLSTATE = 42977, Error Code = -7022, User zzagreene not the same as current user &2.

32738 Fri Aug 31 09:04:51 2007 jdb_drvm.c1586
JDB9900189 - Failed to verify that table exists in HNYPNY - B7333 Server Map

32738 Fri Aug 31 09:04:53 2007 jdb_drvm.c986
JDB9900401 - Failed to execute db request

32738 Fri Aug 31 09:04:53 2007 jdb_exem.c481
JDB21000091 - Failed to create table F98BLOB in data source HNYPNY - B7333 Server Map

32738 Fri Aug 31 09:04:53 2007 jdb_utl1.c4058
JDB9900505 - Failed to create F98BLOB table in HNYPNY - B7333 Server Map

32738 Fri Aug 31 09:04:53 2007 runbatch.c1197
RUNBATCH: Remote CP=1252, Remote OS=5, Local CP=37, ConvertToASCII=0

32738 Fri Aug 31 09:05:06 2007 dbdrvcli.c107
OS40001090 - SQL error: SQLSTATE = 42977, Error Code = -7022, User zzagreene not the same as current user &2.

32738 Fri Aug 31 09:05:06 2007 jdb_drvm.c1586
JDB9900189 - Failed to verify that table exists in Versions - DM7333 - DNT

32738 Fri Aug 31 09:05:07 2007 dbdrvsql.c1241
OS40002001 - Error Type: SQL sqlcode: -601

32738 Fri Aug 31 09:05:07 2007 jdb_drvm.c986
JDB9900401 - Failed to execute db request

32738 Fri Aug 31 09:05:07 2007 jdb_exem.c481
JDB21000091 - Failed to create table F98BLOB in data source Versions - DM7333 - DNT

32738 Fri Aug 31 09:05:07 2007 jdb_utl1.c4058
JDB9900505 - Failed to create F98BLOB table in Versions - DM7333 - DNT

32738 Fri Aug 31 09:05:13 2007 jdeobj.c1727
COB0000011 - Library load failed DM7333/CALLBSFN function GetInternalNextNumber Error = 0

32738 Fri Aug 31 09:05:13 2007 jdeobj.c1727
COB0000011 - Library load failed DM7333/CRUNTIME function GetCompanyAndReportDesc Error = 0

32738 Fri Aug 31 09:05:15 2007 jdeobj.c1727
COB0000011 - Library load failed DM7333/COPBASE function ConvertShortItemToLongItem Error = 0


-Andrew
 
I have almost the exact same system configuration and also attempted the SP23S upgrade with the same results. One think that caught my eye was the F986111 call that was failing so I investigated that and found that the F986111 table was blank and always has been. I am not sure what the system is looking for in that table but it's not finding it.
 
Did you ever solve this issue? I am having the exact problem on SP23 T1.

Tom
 
We had a similar problem when we upgraded to SP23 R1 as I recall. I believe that our system user ID (field SCSECUSR in F98OWSEC) worked as lower case prior to that service pack but was now case sensitive in R1 (and probably S1 and T1, now). We made it all caps and the problem went away. It may not be the same problem, but you might want to check that out.
 
I would also be interested on any information regarding SP23_S1 and SP23_T1. I have a current project to apply SP23_R1 but since I haven't started yet, I thought I might go to S1 or T1 instead.

Patty
 
Resolved: SP23 T1 Upgrade Issues

First, Thanks to Sully and Mark for your input.

I found the issue, the INI setting sqlServerMode=0 was inadvertantly placed in the [NETWORK ...] section (I forget the full name), when I moved it to the [DB SYSTEM SETTINGS] and bounced services everything worked just fine.

Tom
 
Back
Top