IV47577: MIGRATION MANAGER DATABASE COMPARISON FAILS WITH A JAVA.SQL.SQLEEXHAUSTED RESULTSET.

APAR status

• Closed as program error.

Error description

• Migration Manager database comparison fails with a java.sql.SQLE
  Exhausted Resultset.
  
  
  Migration Manager compare will fail with error reported
  
  The asynchronous job has been submitted.
  The asynchronous job is picked up by the server.
  The asynchronous job is started.
  The asynchronous job completed successfully.
  com.ibm.db2.jcc.b.SqlException: [jcc][t4][10120][10898][3.53.70]
  Invalid operation: result set is closed. ERRORCODE=-4470,
  SQLSTATE=null
   at com.ibm.db2.jcc.b.bd.a(bd.java:660)
   at com.ibm.db2.jcc.b.bd.a(bd.java:60)
   at com.ibm.db2.jcc.b.bd.a(bd.java:103)
   at com.ibm.db2.jcc.b.ul.Fb(ul.java:4171)
   at com.ibm.db2.jcc.b.ul.a(ul.java:1621)
   at com.ibm.db2.jcc.b.ul.getObject(ul.java:1525)
   at psdi.dm.util.DBCompare.compareKeys(DBCompare.java:1075)
   at psdi.dm.util.DBCompare.doCompare(DBCompare.java:586)
   at psdi.dm.util.DBCompare.process(DBCompare.java:242)
   at psdi.dm.virtual.DmCompareAsyncJobHandler.asyncProcess
  (DmCompareAsyncJobHandler.java:88)
   at
  psdi.common.asyncjob.AsyncJobCron.cronAction(AsyncJobCron.java:1
  49)
   at
  psdi.server.CronTaskManager.callCronMethod(CronTaskManager.java:
  1569)
   at
  psdi.server.CronTaskManager.access$400(CronTaskManager.java:87)
   at
  psdi.server.CronTaskManager$CronThread.run(CronTaskManager.java:
  2135)
  
  
  Reported and duplicated in Base Code 7.5.0.4 and SCCD 7.5.1
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo Users on 750 comparing databases in Migration         *
  * Manager.                                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Migration Manager database comparison fails with a           *
  * java.sql.SQLExhausted Resultset.                             *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixpack Release 7.1.1.13 of Base Services, Release     *
  * 7.5.0.6 of Base Services or request an interim fix           *
  ****************************************************************
  

Problem conclusion

• Fix has been made to fix Maximo Users on 750 comparing databases
  in Migration Manager.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• MAXIMO
  

Fix information

• Fixed component name

  SERVICE PROVIDE

• Fixed component ID

  5724R46SV

Applicable component levels