serenity_now
Active Member
Hi,
We are having issues where every few weeks our JDE will essentially crash. We are running on a iSeries and the logs seem to indicate IPC errors.
We shut down the system and clear IPC every Saturday night, and the few times this crash has happened it has been on a later on in the week usually a Friday. However, recently it happened as early as Monday.
Essentially what happens is when users try to submit a report they get the error that the UBE cant be submitted, and I see errors in the log like :
57551/2915 WRK:Starting jdeCallObject Mon Oct 18 15:57:13.005240 queueapi.c597
QUEUE05300060-Failed 11 to ReceiveMsg 4524 from SERVER
57551/2915 WRK:Starting jdeCallObject Mon Oct 18 15:57:13.005512 queueapi.c1276
QUEUE06000030-System failed to change 4524 job SERVER____143977
56978/2029 WRK:Starting jdeCallObject Mon Oct 18 16:39:09.550528 jtp_cm.c1004
JDB9909007 - Unable to obtain driver request handle
56978/2029 WRK:Starting jdeCallObject Mon Oct 18 16:39:09.623048 dbdrv_log.c196
OS400QL017 - PrepareAndOrDescriberepare failed. QSQLMSG *LIBL - SQL0204 - &1 in &2 type *&3 not found
The only way to fix it is to end services. I am unsure of what the exact culprit is, however most things I have found from Oracle point to IPC. Though I have read most of what Oracle has to offer for tuning, yet still have the issue.
The IPC portion of JDE.ini looks as follows;
[JDEIPC]
maxNumberOfResources=2000
maxNumberOfSemaphores=1000
startIPCKeyValue=2101
avgResourceNameLength=15
maxMsgqEntries=1024
maxMsgqBytes=65536
ipcTrace=0
We have less than 50 or 60 people that are ever on the system, frankly the iSeries we have is overkill for the amount of users.
Does anyone have experience with IPC issues like this in the past?
We are having issues where every few weeks our JDE will essentially crash. We are running on a iSeries and the logs seem to indicate IPC errors.
We shut down the system and clear IPC every Saturday night, and the few times this crash has happened it has been on a later on in the week usually a Friday. However, recently it happened as early as Monday.
Essentially what happens is when users try to submit a report they get the error that the UBE cant be submitted, and I see errors in the log like :
57551/2915 WRK:Starting jdeCallObject Mon Oct 18 15:57:13.005240 queueapi.c597
QUEUE05300060-Failed 11 to ReceiveMsg 4524 from SERVER
57551/2915 WRK:Starting jdeCallObject Mon Oct 18 15:57:13.005512 queueapi.c1276
QUEUE06000030-System failed to change 4524 job SERVER____143977
56978/2029 WRK:Starting jdeCallObject Mon Oct 18 16:39:09.550528 jtp_cm.c1004
JDB9909007 - Unable to obtain driver request handle
56978/2029 WRK:Starting jdeCallObject Mon Oct 18 16:39:09.623048 dbdrv_log.c196
OS400QL017 - PrepareAndOrDescriberepare failed. QSQLMSG *LIBL - SQL0204 - &1 in &2 type *&3 not found
The only way to fix it is to end services. I am unsure of what the exact culprit is, however most things I have found from Oracle point to IPC. Though I have read most of what Oracle has to offer for tuning, yet still have the issue.
The IPC portion of JDE.ini looks as follows;
[JDEIPC]
maxNumberOfResources=2000
maxNumberOfSemaphores=1000
startIPCKeyValue=2101
avgResourceNameLength=15
maxMsgqEntries=1024
maxMsgqBytes=65536
ipcTrace=0
We have less than 50 or 60 people that are ever on the system, frankly the iSeries we have is overkill for the amount of users.
Does anyone have experience with IPC issues like this in the past?