IJ03599: MAXIMO IS EXECUTING THE SAME SQL STATEMENT MULTIPLE TIMES , PERFORMANCE ISSUE

APAR status

• Closed as program error.

Error description

• Issue :- While fetching data through CLASSIFICATION JSON api
  service system is taking 9.5 seconds and monitoring through
  Perfmon tool it shows 1412 statements running in backend. Issue
  is  related to the NUMERIC  domains. The same issue can be
  reproduce by steps
  1. Go to Incident app
  2. Bring up an existing record
  3. Look up the Reported Priority field
  4. You'll see MAXDOMAIN is fetched 4 times with the same sql
  statement
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Maximo repeatedly performs the same fetch against the        *
  * MaxDomain table when looking up domain values.               *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is included in the following package:
                           | Release 7.6.1.0 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

  INTEGRATION

• Fixed component ID

  5724R46I1

Applicable component levels

• R760 PSY

     UP