IJ31904: WORK DETAILS TAB IS SLOW IN CONFIGURATION ITEMS APPLICATION

APAR status

• Closed as program error.

Error description

• PROBLEM:
  Work Details tab is slow in Configuration Items application
  
  PERFORMANCE ISSUE:
  Yes
  
  STEPS TO REPRODUCE:
  1. Go To Configuration Items application
  2. Open CI.
  3. Switch to Work Details tab.
  
  CURRENT ERRONEOUS RESULT:
  It takes long time to load the data.
  
  EXPECTED RESULT:
  It should not take more than few second to display the data
  
  ADDITIONAL INFO:
  This can be fixed by optimizing SQL query that retrieves the
  data
  
  ENVIRONMENT:
  Servidor de Aplicativo IBM WebSphere Application Server 8.5.5.13
  
  Versão IBM Endpoint Manager Integration Configuration 7.6.1.2148
  Build ICD-PROD-427-202005271312 DB Build V7611-08SLA Hold for
  IBM Control Desk 7.6.1.2148 Build ICD-PROD-427-202005271312 DB
  Build V7530-01Live Chat for IBM Control Desk 7.6.1.2148 Build
  ICD-PROD-427-202005271312 DB Build V7604-01Common process
  components for IBM Control Desk for Service Providers 7.6.1.2148
  Build ICD-PROD-427-202005271312 DB Build V7511-00Rational Team
  Concert and Rational ClearQuest Integration for IBM Control Desk
  7.6.1.2148 Build BUILD DB Build V7511-00Service Desk
  Classification Content for IBM Control Desk 7.6.1.2148 Build
  ICD-PROD-427-202005271312 DB Build V7511-00Asset Management for
  IBM Control Desk for Service Providers 7.6.1.2148 Build
  202005271316 DB Build V7511-00IBM Endpoint Manager Integration
  Enablement 7.6.1.2148 Build ICD-PROD-427-202005271312 DB Build
  V7612-01ChatOps Integration for IBM Control Desk 7.6.1.2148
  Build ICD-PROD-427-202005271312 DB Build V7612-13Survey
  Management for IBM Control Desk 7.6.1.2148 Build
  ICD-PROD-427-202005271312 DB Build V7611-02Release management
  for IBM Control Desk 7.6.1.2148 Build ICD-PROD-427-202005271312
  DB Build V7604-01Search for IBM Control Desk 7.6.1.2148 Build
  ICD-PROD-427-202005271312 DB Build V7610-03OSLC Support for IBM
  Control Desk 7.6.1.2148 Build 202005271316M DB Build
  V750-06Change management for IBM Control Desk for Service
  Providers 7.6.1.2148 Build ICD-PROD-427-202005271312 DB Build
  V7511-00SmartCloud Provisioning and SmartCloud Orchestration
  Integration 7.6.1.2148 Build ICD-PROD-427-202005271312 DB Build
  V7511-04Service Desk Integration MEA for IBM Control Desk
  7.6.1.2148 Build ICD-PROD-427-202005271312 DB Build
  V7530-00Configuration items for IBM Control Desk 7.6.1.2148
  Build ICD-PROD-427-202005271312 DB Build V7612-01Change
  management for IBM Control Desk 7.6.1.2148 Build
  ICD-PROD-427-202005271312 DB Build V7611-01Tivoli Remote
  Diagnostics for IBM Control Desk 7.6.1.0319 Build
  ICD-PROD-149-201811151250 DB Build V7511-00Service Desk for IBM
  Control Desk 7.6.1.2148 Build ICD-PROD-427-202005271312 DB Build
  V7612-04Common process components for IBM Control Desk
  7.6.1.2148 Build ICD-PROD-427-202005271312 DB Build V7612-02Self
  Service Center for IBM Control Desk 7.6.1.2148 Build
  ICD-PROD-427-202005271312 DB Build V7611-01Configuration
  management for IBM Control Desk for Service Providers 7.6.1.2148
  Build ICD-PROD-427-202005271312 DB Build V7511-00Problem
  Management for IBM Control Desk 7.6.1.2148 Build
  ICD-PROD-427-202005271312 DB Build V7612-01Asset Management for
  IBM Control Desk 7.6.1.2148 Build 202005271316 DB Build
  V7611-01Service Desk for IBM Control Desk for Service Providers
  7.6.1.2148 Build ICD-PROD-427-202005271312 DB Build
  V7511-00Advanced Workflow Components for IBM Control Desk
  7.6.1.2148 Build ICD-PROD-427-202005271312 DB Build
  V7611-01Instant Messaging for IBM Control Desk 7.6.1.2148 Build
  ICD-PROD-427-202005271312 DB Build V7530-00Release management
  for IBM Control Desk for Service Providers 7.6.1.2148 Build
  ICD-PROD-427-202005271312 DB Build V7511-00Tivoli's process
  automation engine 7.6.1.1-IFIX20200824-1011 Build 20190514-1348
  DB Build V7611-365 HFDB Build HF7611-35IBM Maximo Asset
  Management Work Centers 7.6.0.4 Build 20190514-1348 DB Build
  V7604-119Incident Management for IBM Control Desk 7.6.1.2148
  Build ICD-PROD-427-202005271312 DB Build V7612-02Quick
  Configuration for IBM Control Desk 7.6.1.2148 Build
  ICD-PROD-427-202005271312 DB Build V7610-02IBM Maximo for
  Service Providers 7.6.3.3 Build 20190519-2208 DB Build
  V7633-13IoT Connection Utility 7.6.0.2 Build 20190426-2206 DB
  Build V7602-07Solution for IBM Control Desk 7.6.1.2148 Build
  ICD-PROD-427-202005271312 DB Build V7612-01Instant Messaging
  Integration for IBM Control Desk 7.6.1.2148 Build
  ICD-PROD-427-202005271312 DB Build V7200-02VNC for IBM Control
  Desk 7.6.1.2148 Build ICD-PROD-427-202005271312 DB Build
  V7612-01Configuration management for IBM Control Desk 7.6.1.2148
  Build ICD-PROD-427-202005271312 DB Build V7610-02IBM Tpae
  Integration Framework 7.6.1.1 Build 20190419-2330 DB Build
  V7611-01Service Portal for IBM Control Desk 7.6.1.2148 Build
  ICD-PROD-427-202005271312 DB Build V7612-06Screen Capturer for
  IBM Control Desk 7.6.1.0319 Build ICD-PROD-149-201811151250 DB
  Build V7530-00Service Request Management for IBM Control Desk
  7.6.1.2148 Build ICD-PROD-427-202005271312 DB Build
  V7612-01Mobile App for IBM Control Desk 7.6.1.2148 Build 1 DB
  Build V7611-02Service Catalog for IBM Control Desk 7.6.1.2148
  Build ICD-PROD-427-202005271312 DB Build V7612-05Configuration
  items for IBM Control Desk for Service Providers 7.6.1.2148
  Build ICD-PROD-427-202005271312 DB Build V7511-00Data
  Integration and Context Menu Service Configuration 7.5.0.0 Build
  20090911D2 DB Build V7117-07IBM Tivoli Integration Composer for
  IBM Control Desk 7.6.1.2148 Build 202005271316 DB Build
  V7612-01IBM License Metric Tool logger 7.6.1.2148 Build
  ICD-PROD-427-202005271312 DB Build V7612-01User interface
  widgets for IBM Control Desk 7.6.1.2148 Build
  ICD-PROD-427-202005271312 DB Build V7612-02Service Desk
  Everyplace for IBM Control Desk 7.6.1.2148 Build
  ICD-PROD-427-202005271312 DB Build V7510-03
  
  SO do Servidor: Linux 2.6.32-754.28.1.el6.x86_64
  BD do Servidor DB2/LINUXX8664 10.5 (SQL10056)
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * maximo, control desk                                         *
  ****************************************************************
  

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