IJ49569: DATABASE LEAK IS SUSPECTED WHEN THE ASSET CATALOGUE IS SAVED.

APAR status

• Closed as program error.

Error description

• PROBLEM: Database leak is suspected when the asset catalogue is
  saved.
  
  The DB connection watchdog is generating a warning. MBOSet/DB
  connection-related resources are being used for too long.
  
  
  
  
  STEPS TO REPRODUCE:
  When opening the asset catalogue and saving.
  
  
  RESULT:
  In dbwatchdog logfile:
  Stack trace:
  Create stack trace:
  psdi.server.DBManager.getConnection(DBManager.java:1477)
  psdi.mbo.MboSet.fetchMbos(MboSet.java:2907)
  psdi.mbo.MboSet.getMbo(MboSet.java:2123)
  psdi.mbo.MboSet.isEmpty(MboSet.java:4419)
  psdi.app.assetcatalog.ClassStructure.setSortOrder(ClassStructur
  e.java:814)psdi.app.assetcatalog.ClassStructure.save(ClassStruct
  48)psdi.plusp.app.assetcatalog.PlusPClassStructure.save(PlusPCla
  Structure.java:349)psdi.plusd.app.assetcatalog.PlusDClassStructu
  Structure.java:55)psdi.mbo.MboSet.saveMbos(MboSet.java:7917)
  psdi.mbo.MboSet.validateTransaction(MboSet.java:7897)
  psdi.mbo.MboSet.save(MboSet.java:7543)
  psdi.mbo.MboSet.save(MboSet.java:7467)
  psdi.webclient.system.beans.AppBean.save(AppBean.java:642)
  psdi.webclient.system.beans.AppBean.SAVE(AppBean.java:1357) psd
  i.webclient.system.session.WebClientSession.processRequestEvent
  (WebClientSession.java:6219)psdi.webclient.system.session.WebCli
  bClientSession.java:892)psdi.webclient.system.session.AsyncReque
  (AsyncRequestManager.java:555)psdi.webclient.system.filter.HttpX
  ttpXFrameOptionsFilter.java:38)psdi.webclient.system.filter.MTCo
  Filter.java:53)com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.
  
  
  EXPECTED RESULT:
  The connection gets closed after saving.
  
  ENVIRONMENT:
  Maximo 7.6.1.2
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * DATABASE LEAK IS SUSPECTED WHEN THE ASSET CATALOGUE IS       *
  * SAVED.                                                       *
  ****************************************************************
  Database leak is suspected when the asset catalogue is saved.
  The DB connection watchdog is generating a warning. MBOSet/DB
  connection-related resources are being used for too long.
  Change: Added a try-finally block around the block of
  classStructureAssetCatalogueSet, and replaced isEmpty() with
  notExist() to avoid database leakage.
  

Problem conclusion

• The fix for this APAR will be contained in a future release.
  

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:

Fix information

• Fixed component name

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels