jdeKrnl
Active Member
Hi. I was wondering if anyone has seen this issue. UBE kernel displays the following error, keeps throwing similar errors, and eventually goes to zombie:
60 Wed Feb 16 07:05:52 2005 dbdrvag.c263
OS40001078 - DoPrepare: sql code is -113
60 Wed Feb 16 07:05:52 2005 jdb_drvm.c839
JDB9900168 - Failed to initialize db request
60 Wed Feb 16 07:05:52 2005 jtp_cm.c1088
JDB9909007 - Unable to obtain driver request handle
60 Wed Feb 16 07:05:52 2005 jdb_exet.c4091
JDB3500011 - Failed to delete for F98BLOB
This is on ERP 8.0, SP22_L1, AS400, V5R2. The issue is somewhat intermittent (every other day, usually early in the morning when there is heavy volume of UBE requests). Other UBE kernels perform correctly before, during, and after failure in this particular process.
It appears that once the report is in queue (status S), the UBE kernel does a blind DELETE on F98BLOB. The SQL statement is built using the report name and job number, something like
DELETE FROM SVM7334B/F98BLOB WHERE ( KSKEYSEQ = '%SERVER%-%JOBNUMBER%-' AND KSOBNM = 'F986110' )
It seems that the UBE kernel is failing when trying to build this statement. From the IBM DB2 Message reference:
“<identifier>” contains a character that is not allowed or does not contain any characters. Explanation: An SQL-variable-name, parameter-name or condition-name “<identifier>” contains an invalid character. Only characters that are valid for an SQL ordinary identifier are allowed.
Eventually a new UBE kernel is spawned and it works fine. The strange thing is that the kernel apparently cannot recover from this error.
Any ideas will be greatly appreciated.
Thanks
jdeKrnl
ERP 8.0, SP22_L1, AS400, V5R2
60 Wed Feb 16 07:05:52 2005 dbdrvag.c263
OS40001078 - DoPrepare: sql code is -113
60 Wed Feb 16 07:05:52 2005 jdb_drvm.c839
JDB9900168 - Failed to initialize db request
60 Wed Feb 16 07:05:52 2005 jtp_cm.c1088
JDB9909007 - Unable to obtain driver request handle
60 Wed Feb 16 07:05:52 2005 jdb_exet.c4091
JDB3500011 - Failed to delete for F98BLOB
This is on ERP 8.0, SP22_L1, AS400, V5R2. The issue is somewhat intermittent (every other day, usually early in the morning when there is heavy volume of UBE requests). Other UBE kernels perform correctly before, during, and after failure in this particular process.
It appears that once the report is in queue (status S), the UBE kernel does a blind DELETE on F98BLOB. The SQL statement is built using the report name and job number, something like
DELETE FROM SVM7334B/F98BLOB WHERE ( KSKEYSEQ = '%SERVER%-%JOBNUMBER%-' AND KSOBNM = 'F986110' )
It seems that the UBE kernel is failing when trying to build this statement. From the IBM DB2 Message reference:
“<identifier>” contains a character that is not allowed or does not contain any characters. Explanation: An SQL-variable-name, parameter-name or condition-name “<identifier>” contains an invalid character. Only characters that are valid for an SQL ordinary identifier are allowed.
Eventually a new UBE kernel is spawned and it works fine. The strange thing is that the kernel apparently cannot recover from this error.
Any ideas will be greatly appreciated.
Thanks
jdeKrnl
ERP 8.0, SP22_L1, AS400, V5R2