IJ15871: PERFORMANCE ISSUE WITH GLNAVIGATOR

APAR status

• Closed as program error.

Error description

• GLNAVIGATOR taking to long to open
  STEPS TO REPRODUCE:
  1. Go to any application that has a GL lookup such as Work
  Order Tracking.
  2. Click the GL lookup
  It takes 20 seconds to render the data.
  SQL in code issue:
  Select count(*) from glcomponents where glorder = 0 and exists
  (select 1 from chartofaccounts where glcomp01
  =glcomponents.compvalue and ((expiredate is null and { ts
  '2019-04-04 23:00:07.700' } >= activedate) or ({ ts '2019-04-04
  23:00:07.700' } >= activedate and { ts '2019-04-04
  23:00:07.700' } < expiredate)) and orgid = 'XXXXXX' group by
  glcomp01) and orgid = 'XXXXXX' for read only (execution took
  14541 milliseconds)
  CURRENT ERRONEOUS RESULT:
  taking too long (20 seconds to render)
  EXPECTED RESULT:
  Should render quickly
  Product Version:
  Tivoli's process automation engine 7.6.0.9-IFIX20190102-1331
  Build 20171127-0100 DB Build V7609-45 HFDB Build HF7609-06,
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo users with large amount of CHARTOFACCOUNTS records    *
  * who use GL Navigator                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Slow performance in the GL Navigator dialog when the user    *
  * has a large amount of CHARTOFACCOUNTS  records.              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• This is fixed in code with a new system property
  mxe.app.financial.ExcludeCOACheckinNavigator.  Users need to
  change the property value to 1 for the code to bypass the check
  of COA in the GLNAVIGATOR to help the performance.
  
  The fix for this APAR is contained in the following maintenance
  package:
  	 | release\fix pack | Interim Fix for Release 7.6.1.2 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:

Modules/Macros

• maximo
  

Fix information

• Fixed component name

  ADMINISTRATION

• Fixed component ID

  5724R46A1

Applicable component levels