SP23_R1 Issue

List,
I am having a major issue after having "successfully" tested SP23_R1 in a test environment. Now that we are in production as of Saturday, business functions stop working on the AS400 after a period of time (several hours, roughly). Some of the call object kernels begin generating massive, wrapping job logs that state:"Pointer not set for location referenced". The corresponding jde.log simply states the following:
9055 Tue Jul 31 11:04:25 2007 dbdrv_dt.c212
OS40001065 - FindSQLIndex: failed search for column: OMENHV

9055 Tue Jul 31 11:04:25 2007 jdb_drvm.c887
JDB9900168 - Failed to initialize db request

9055 Tue Jul 31 11:04:25 2007 jtp_cm.c1090
JDB9909007 - Unable to obtain driver request handle

9055 Tue Jul 31 11:04:25 2007 jdb_omp1.c2520
JDB9900258 - Failed to select from F986101

I have recycled services and it keeps it back up and running for a while, but not for long. I have relinked business functions twice, to no avail. Happens in all environments.

Oracle/JDE support is having me build a full package, which I don't remember being a pre-requisite of a service pack. That's building now, but in the meantime I thought I would send up a signal flare for help on the List.

Any ideas? Anyone?

Configuration:
Xe, SP23_R1
AS400 Enterprise Server, V5R3
Upgraded Vertex to 3.2.23 as a requirement of 23_R1
Mostly Citrix clients
Some Web clients via WAS6 running on W2K3

Hi,

In my opinion you'll have to deploy a full package, which has been compiled with the new service pack.
You can also try to clear all the *SQLPKG concerning JDE on the AS400. Pay attention, the JDE services need to be stopped to avoid locks. You can also try to clear the dddict*, ddtext* and glbltbl* files on the spec directory of your default environment...

Good luck!