IJ33431: DATABASE CONNECTION LEAK - PSDI.APP.WORKORDER.FLDASSIGNLABORCODE.VALIDATE(FLDASSIGNLABORCODE.JAVA:82)

APAR status

• Closed as program error.

Error description

• PROBLEM:
  the stack trace suggests: User is in the workorder tracking
  application is the cause of leak database connections. The user
  is using a lookup. The lookup looks like a labor code domain.
  
  STEPS TO REPRODUCE:
  1 go to work order tracking
  2 use lookup for Labor
  
  RESULT:
  The DB connection watchdog logger is warning about a leaked
  database connection.
  Two connections were leaked for several minutes.
  
  Stack:
  Suspect method: psdi.app.workorder.FldAssignLaborCode.validate(
  FldAssignLaborCode.java:82)
  Create stack trace:
  psdi.server.DBManager.getConnection(DBManager.java:1472)
  psdi.mbo.MboSet.fetchMbos(MboSet.java:2898)
  psdi.mbo.MboSet.getMbo(MboSet.java:2114)
  psdi.mbo.MboSet.isEmpty(MboSet.java:4410) psdi.app.workorder.Fl
  dAssignLaborCode.validate(FldAssignLaborCode.java:82)psdi.mbo.Mb
  psdi.mbo.MboValue.setValue(MboValue.java:905)
  psdi.mbo.MboValue.setValue(MboValue.java:1156)
  psdi.mbo.Mbo.setValue(Mbo.java:2409) psdi.mbo.MAXTableDomain.se
  tValueFromLookup(MAXTableDomain.java:517)psdi.mbo.MAXTableDomain
  548)psdi.app.workorder.FldAssignLaborCode.setValueFromLookup(Fld
  ignLaborCode.java:452)psdi.mbo.MboValue.setValueFromLookup(MboVa
  psdi.mbo.Mbo.setValue(Mbo.java:7706) psdi.webclient.system.bean
  s.DataBean.setValue(DataBean.java:4123)psdi.webclient.system.bea
  2)psdi.webclient.system.beans.DataBean.returnLookupValue(DataBea
  .java:4290)psdi.webclient.system.beans.LookupBean.selectrecord(L
  java:114)psdi.webclient.system.session.WebClientSession.processR
  ent(WebClientSession.java:6193)psdi.webclient.system.session.Web
  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:
  No database leak when performing the action in a workorder
  application
  
  ENVIRONMENT:
  Maximo 7.6.1.2
  

Local fix

Problem summary

• ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * DATABASE CONNECTION LEAK                                     *
  ****************************************************************
  The DB connection watchdog logger is warning about a leaked
  database connection.Two connections were leaked for several
  minutes.
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package:
  Release 7.6.1.3 of Base Services
  

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 W
  

Fix information

• Fixed component name

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels