IJ35564: MAXIMO PURCHASE ORDER PRLINE GETMBOSET MEMORY LEAK IN PSDI.APP.PO.FLDPOLINEPRNUM.INITVALUE

APAR status

• Closed as program error.

Error description

• PROBLEM DESCRIPTION
  
  The problem is that the prLineRemote mboset is opened but it is
  not closed when it is finished.
  This will leave the mboset open until the MBOset is cleaned
  
  This has the potential to create substantial performance
  problems because it uses memory and keeps database connections
  open.
  
  STEPS TO REPRODUCE
  These steps have been put together based on the logs:
  
  User is logged in to Maximo
  User is in the PO application
  The user is clicking on a tab containing the field PRNUM - Java
  class psdi.app.po.FldPOLinePRNum.
  The field appears to be in a table.
  
  The data is displayed and the query is triggered.
  The log entries show that the connection is being kept open for
  long periods of time
  
  RESULTS
  The connection is not being closed immediately when the MBO is
  initiated.
  
  EXPECTED RESULTS
  The table should be displayed and any connections should be
  opened and then closed immediately.
  
  LOG DETAILS
  
  [10/10/21 11:46:48:863 BST] 000000d2 SystemOut     O 10 Oct 2021
  11:46:48:863 [INFO] [UI1] [] BMXAA7084I - The database
  connection has been opened for: 423636 ms
  DbConnectionWatchDog:Db Connection reference id=95201 SPID=04
  	Create time:16339483426
  	Create stack trace:
  		psdi.server.DbConnectionWatchDog$ConnectionData.<init>(DbConn
  ectionWatchDog.java:60)
  psdi.server.DbConnectionWatchDog.addConnection(DbConnectionWatc
  hDog.java:252)
  psdi.server.ConRef.notifyDBConnectionWatchDog(ConRef.java:238)
  psdi.server.DBManager.getConnectionDetail(DBManager.java:1732)
  psdi.server.DBManager.getConnection(DBManager.java:1472)
  psdi.server.AppService.getDBConnection(AppService.java:572)
  psdi.mbo.MboSet.getNextRecordData(MboSet.java:3289)
  		psdi.mbo.MboSet.fetchMbosActual(MboSet.java:2948)
  		psdi.mbo.MboSet.fetchMbos(MboSet.java:2905)
  
  REPORTED IN VERSION
  
  Maximo Asset Management 7.6.1.2
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo Purchase Orders users                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Memory leak: PRLINE set not explicitly closed when no longer *
  * needed.                                                      *
  ****************************************************************
  User is logged in to Maximo
  User is in the PO application
  The user is clicking on the PO Lines tab and the field PRNUM -
  Java class psdi.app.po.FldPOLinePRNum.initValue() is invoked to
  populate the non-persisent PRNUM and PRLINENUM fields.
  The query is triggered and the data is displayed.
  The log entries show that the connection is being kept open for
  long periods of time.
  RESULTS
  The connection is not being closed immediately when the MBO is
  initiated.
  EXPECTED RESULTS
  The table should be displayed and any connections should be
  opened and then closed immediately.
  

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:

Fix information

• Fixed component name

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels