IJ38163: MAXIMO 7.6.1.2 - PSDI.APP.REPORT.VIRTUAL.QUICKPRINTSET.INIT() - DB CONNECTION LEAK

APAR status

• Closed as program error.

Error description

• Problem:
  The logs show that this is leaked for long periods of time.
  In one case it leaked for 6 minutes.
  
  Result
  The DB connection watchdog is generating a warning. MBOSet/DB
  connection related resources are being used too long.
  
  Stack trace:
  Create stack trace:
  psdi.server.DBManager.getConnection(DBManager.java:1472)
  psdi.mbo.MboSet.fetchMbos(MboSet.java:2905)
  psdi.mbo.MboSet.getMbo(MboSet.java:2121) psdi.app.report.virtua
  l.QuickPrintSet.init(QuickPrintSet.java:90)psdi.mbo.MboSet.init(
  psdi.mbo.MboSet.resetThis(MboSet.java:5258)
  psdi.mbo.MboSet.reset(MboSet.java:5174) psdi.webclient.controls
  .DynamicToolbar.buildButtonList(DynamicToolbar.java:97)psdi.webc
  r.java:66)psdi.webclient.system.session.WebClientSession.process
  ent(WebClientSession.java:6219)psdi.webclient.system.session.Web
  ueueRequest(WebClientSession.java:6441)psdi.webclient.system.ses
  bClientSession.java:897)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 RESULTS:
  
  The connection gets closed after the report has run.
  
  REPORTED IN VERSION:
  
  Maximo: Tivoli's process automation engine
  7.6.1.2-IFIX20210323-1206 Build 20200715-0100 DB Build V7612-284
  HFDB Build HF7612-20
  IBM Maximo Asset Management Work Centers 7.6.0.4 Build
  20200715-0100 DB Build V7604-119 HFDB Build HF7680-10
  IBM Tpae Integration Framework
  7.6.1.2-MIF_7612_IFIX.20210303-1359 Build 20200715-1444 DB Build
  V7612-11
  IBM Maximo Asset Management 7.6.1.2 Build 20200715-0100 DB Build
  V7611-01
  IBM Maximo for Oil and Gas 7.6.1.0-20210111-0931 Build
  20161020-0803 DB Build V7610-139 HFDB Build HF7610-56
  IoT Connection Utility 7.6.0.3 Build 20200701-1409 DB Build
  V7603-32
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * DBConnection watchdog logs "BMXAA7084I - The database        *
  * connection has been opened for:..." for                      *
  * psdi.app.report.virtual.QuickPrintSet.init                   *
  ****************************************************************
  

Problem conclusion

• _The fix for this APAR is contained in the following maintenance
  package: release\fix pack for Release 7.6.1.3 Product_
  

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 REPORTIN

• Fixed component ID

  TIVOREPTS

Applicable component levels