ERP8 Scheduler kernel dies (sqlcode: -952)

Hi. I was wondering if anyone has seen this issue:

Scheduler kernel dies after encountering multiple SQL errors with sqlcode 952 on ERP8/SP23_J1/AS400/V5R2. The issue is occurring on our Live Production environment. Therefore, it was not possible to turn on full debugging on the enterprise server.

The Scheduler kernel throws the following errors and eventually it dies (set to zombie).

22325 Sun Feb 19 20:46:24 2006 jdb_drvm.c938
JDB9900401 - Failed to execute db request

22325 Sun Feb 19 20:46:24 2006 jdb_drvm.c1051
JDB9900174 - Failed to free db request

22325 Sun Feb 19 20:46:24 2006 dbdrvsql.c1030
OS40002001 - Error Type: SQL sqlcode: -952

No jobs are launched after the Scheduler kernel enters this state.

Stopping and starting the Scheduler server using P91300 spawns a new Scheduler kernel, which launches the scheduled jobs missed by the zombie kernel.

Thanks!

jdeKrnl
ERP 8.0, SP23_J1, AS400, V5R2, Citrix

I dont have an answer for you, but the same thing happens to us in Xe. the only thing that seems to help some is purging the history file for scheduler. this seems to delay the crash for awhile. if anyone has any input, it would be appreciated.