IJ37105: DATABASE CONNECTION LEAK IN PSDI.WEBCLIENT.SYSTEM.BEANS.APPBEAN.FIND - ISEMPTY

APAR status

• Closed as program error.

Error description

• Description:
  Database connection leak in
  psdi.webclient.system.beans.AppBean.find - isEmpty
  
  Detailed description:
  The stack trace shows that is was triggered from a find
  operation started from the front-end.
  The code is calling the MboSet.isEmpty method and that is known
  to leak DB connections if there are multiple records in the
  MBOSet.
  
  The logs show that this is leaked twice and for 4 and 6 minutes.
  
  
  Conn refs:
  
  1123559, 24309
  
  RESULT:
  The DB connection watchdog is generating a warning. MBOSet/DB
  connection related resources are being used too long.
  
  EXPECTED RESULT:
  MBOSet should be closed immediately after it is used. It should
  not be leaked and generate this warning.
  The isEmpty call can be replaced by a call to notExists.
  notExists does not leak a DB connection.
  
  PRODUCT:
  TPAE 7612
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Database connection leak in                                  *
  * psdi.webclient.system.beans.AppBean.find - isEmpty           *
  ****************************************************************
  

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 ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels