IJ36984: MAXIMO FOR OIL AND GAS MEMORY LEAK IN PSDI.PLUSC.APP.PLUSCTMPLT.VIRTUAL.PLUSCPREVIEWGENASSETSET.ASSETALREADYEXISTS(STRING)

APAR status

• Closed as program error.

Error description

• ROBLEM DESCRIPTION
  Maximo for Oil and Gas memory leak in psdi.plusc.app.plusctmplt
  .virtual.PlusCPreviewGenAssetSet.assetAlreadyExists(String)
  
  REPRODUCTION STEPS
  The code shows that mbosets are being opened but are not then
  being closed.
  Failing to close the mboset means that the mboset will be open
  until the JVM is restarted as the DB connections that are left
  open potentially for hours at a time.
  
  RESULTS
  The mboset should be given closed after it has been used.
  
  UNEXPECTED BEHAVIOUR
  Database connection remains open causing the memory leak.
  
  Code samplepsdi.plusc.app.plusctmplt.virtual.PlusCPreviewGenAss
  etSet.assetAlreadyExists(String)
  
  /* */ private boolean assetAlreadyExists(String assetNum) throws
  RemoteException, MXException {
  /* */ MboSetRemote assetSet =
  MXServer.getMXServer().getMboSet("ASSET", getUserInfo());
  /* */ assetSet.resetQbe();
  /* */ assetSet.setQbe("siteid", getOwner().getString("siteid"));
  
  /* */ assetSet.setQbe("assetnum", assetNum);
  /* */ assetSet.setQbeExactMatch(true);
  /* */ assetSet.reset();
  /* */ return !assetSet.isEmpty();
  /* */ }
  
  The ASSET mboset isn?t closed. It is generated from the MXServer
  object so it would be left open.
  
  REPORTED VERSION
  
  Maximo Asset Management 7.6.1.2
  

Local fix

Problem summary

• ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Database connection leak                                     *
  ****************************************************************
  

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