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 number
IJ15871
Reported component name
ADMINISTRATION
Reported component ID
5724R46A1
Reported release
760
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2019-05-02
Closed date
2019-11-21
Last modified date
2019-11-21
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
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCHPP5","label":"System Related"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"760","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
21 November 2019