Hi Team,

We are facing an issue with PMWO Cron task,Only a few  PM's are picked by the cron and listed in the Cron log file.We analyzed the logs and it shows the below error

13 Oct 2020 01:00:42:062 [ERROR] [MAXIMO] [CID-CRON-14410] BMXAA6701E - The discardable MBO for an mboset could not be retrieved. The SQL error code is -4470. Check the log files in the <HOME> directory to determine the source and cause of the error.
com.ibm.db2.jcc.am.SqlException: [jcc][t4][10120][10898][4.11.69] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null
 at com.ibm.db2.jcc.am.gd.a(gd.java:660)
 at com.ibm.db2.jcc.am.gd.a(gd.java:60)
 at com.ibm.db2.jcc.am.gd.a(gd.java:103)
 at com.ibm.db2.jcc.am.ym.Db(ym.java:4409)
 at com.ibm.db2.jcc.am.ym.c(ym.java:330)
 at com.ibm.db2.jcc.am.ym.next(ym.java:309)
 at psdi.mbo.MboSet.getNextRecordData(MboSet.java:3388)
 at psdi.mbo.MboSet.getDiscardableMbo(MboSet.java:2230)
 at psdi.mbo.MboSet.getMbo(MboSet.java:2062)
 at psdi.app.pm.PMWoGenCronTask.cronAction(PMWoGenCronTask.java:205)
 at psdi.app.pm.PMWoGenCronTask.cronAction(PMWoGenCronTask.java:1

There are no changes done with respect to DB  .We are not able to replicate it in lower environments. We also referred the below technotes
https://www.ibm.com/support/pages/invalid-operation-result-set-closed-errorcode.

Could you please let us know if any one has faced a similar issue like this and if yes, how it was solved?

Thanks,
Sreekala R

------------------------------
Sreekala R
------------------------------

#Maximo
#AssetandFacilitiesManagement