IJ41339: MAXIMO MEMORY LEAK IN PSDI.APP.WORKORDER.WO.ISJPEDITABLE(WO.JAVA:5268) DB CONNECTION

APAR status

• Closed as program error.

Error description

• Maximo memory leak in
  psdi.app.workorder.WO.isJpEditable(WO.java:5268) DB
  connection
  
  STEPS TO REPRODUCE:
  The code shows that mbosets are
  being opened but are not being closed.
  The MBO Set is potentially left open until the JVM is restarted
  
  The DB connection watchdog is generating a warning. MBOSet/DB
  connection related resources are being used too long
  
  Stack trace:
  
  sdi.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.workorder.WO.isJpEditable(WO.java:5268)
  
  psdi.app.workorder.WO.setJobPlanFieldFlag(WO.java:5304)
  
  psdi.app.workorder.FldWOJobPlan.init(FldWOJobPlan.java:97)
  
  psdi.mbo.MboValue.init(MboValue.java:370)
  psdi.mbo.MboValue.hasFieldAccess(MboValue.java:2371)
  
  psdi.mbo.MboValue.isReadOnly(MboValue.java:1822)
  psdi.mbo.MboValueData.<init>(MboValueData.java:98)
  
  psdi.mbo.MboValueData.<init>(MboValueData.java:80)
  psdi.mbo.MboValue.getMboValueData(MboValue.java:441)
  
  psdi.mbo.Mbo.getMboValueData(Mbo.java:1416)
  psdi.mbo.MboData.<init>(MboData.java:98)
  
  psdi.mbo.Mbo.getMboData(Mbo.java:1527)
  psdi.webclient.system.beans.AppBean.getMboSet(AppBean.java:561)
  psdi.webclient.system.beans.AppBean.getCurrentRow(AppBean.java:8
  80)
  psdi.webclient.system.beans.DataBean.hasSigOptionAccess(Dat
  aBean.java:7994)
  psdi.webclient.system.beans.AppBean.hasSaveAcc
  ess(AppBean.java:2488)
  
  psdi.webclient.controls.HyperLink.render(HyperLink.java:69)
  ps
  di.webclient.controls.BulletinBoard.render(BulletinBoard.java:29
  9)
  psdi.webclient.controls.TitleBar.renderChildren(TitleBar.jav
  a:128) com.ibm._jsp._titlebar._jspService(_titlebar.java:938)
  psdi.webclient.controls.TitleBar.render(TitleBar.java:70)
  
  psdi.webclient.controls.Header.render(Header.java:44)
  com.ibm._jsp._include._jspService(_include.java:531)
  psdi.webclient.controls.Include.render(Include.java:59)
  com.ibm._jsp._page._jspService(_page.java:2169)
  com.ibm._jsp._response._jspService(_response.java:171)
  psdi.web
  client.system.session.WebClientSession.handleRequest(WebClientSe
  ssion.java:982) psdi.webclient.system.session.AsyncRequestManage
  r.handleRequest(AsyncRequestManager.java:555) psdi.webclient.sys
  tem.filter.HttpXFrameOptionsFilter.doFilter(HttpXFrameOptionsFil
  ter.java:38) psdi.webclient.system.filter.MTContextFilter.doFilt
  er(MTContextFilter.java:53)
  com.ibm.ws.util.ThreadPool$Worker.r
  un(ThreadPool.java:1909)
  
  
  CURRENT RESULT
  Mbosets are left open.
  
  EXPECTED RESULT
  The mboset should be closed after it has been used.
  
  REPORTED VERSION
  Maximo Asset Management 7.6.1.2
  

Local fix

Problem summary

• ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The DB connection watchdog is generating a warning.          *
  * MBOSet/DB                                                    *
  * connection related resources are being used too long         *
  ****************************************************************
  

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