IJ32787: 7.6.1.1 - NEW ORG CREATION TAKING A LONG TIME.

APAR status

• Closed as program error.

Error description

• PROBLEM DESCRIPTION
  
  Maximo is taking up 3 hours to create new organizations,
  eventually losing the session.
  Symptom is observed when there is a large quantity of ITEMs in
  ITEM MASTER. Client has about 500K items and 70 organization.
  
  STEPS TO REPRODUCE
  
  Login to Maximo
  Go to > Administration > Organization > New Org
  Fill in the required fields
  Make sure ITEM SET is SET1.
  Save
  The screen will spin for hours. In our support in-house, it
  takes 3h to complete.
  
  
  RESULTS
  
  Never completes
  
  EXPECTED RESULTS
  
  Should complete
  
  PRODUCT VERSION
  
  7.6.1.1-IFIX20201221-2018
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Slow performance in creating a new organization when there   *
  * are large amount of item records. Creating the item orginfo  *
  * records triggered an unnecessary sql select of the default   *
  * insert org for each itemorg record. If there are 500,000     *
  * items, the same select is executed 500,000 times, resulting  *
  * in slow performance, some times memory leak.                 *
  ****************************************************************
  

Problem conclusion

• This is fixed in code.
  The fix for this APAR is contained in the following maintenance
  package:
   | release\fix pack | Interim Fix 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:

Modules/Macros

• MAXIMO
  

Fix information

• Fixed component name

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels