Troubleshooting
Problem
After 6.2.x upgrade to 7.5 InvReservationTypeUpdateCronTask error.
Symptom
The below error seen in the log
[3/18/14 16:46:59:855 CDT] 00000052 SystemOut O 18 Mar 2014 16:46:
59:855 [INFO] [MXServer] [CID-CRON-3942] InvReservationTypeUpdateCronTask started....
[3/18/14 16:47:36:426 CDT] 00000034 SystemOut O 18 Mar 2014 16:47:
36:426 [DEBUG] [MXServer] [CID-CRON-3946] performing cronAction of ReportQueueLockReleaseCronTask
[3/18/14 16:48:19:199 CDT] 00000052 SystemOut O 18 Mar 2014 16:48:
19:184 [ERROR] [MXServer] [CID-CRON-3942] BMXAA6714E - The data for the
next record in the mboset could not be retrieved for the SQL query
select * from item where itemnum = 'xxxx' and itemsetid =
'ITEMSET'. See the log file for more details about the error.
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
Resolving The Problem
As per the install document if you have set the open_cursors to 1000 increase the value to 2000
Restart the database server
Stop and Restart the application server
[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSWT9A","label":"IBM Control Desk"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21670893