IJ07949: SEARCHING ON LONG DESCRIPTION CAUSES CURSORS TO NOT PROPERLY CLOSE

APAR status

• Closed as unreproducible.

Error description

• PROBLEM:
  Cursors remain open in database when searching long description
  in any application.
  
  PERFORMANCE ISSUE:
  Yes
  
  STEPS TO REPRODUCE:
  In application designer, long description to the additional
  search fields screen.
  Open application, navigate to additional searches, and then
  search on long description.
  
  CURRENT ERRONEOUS RESULT:
  Causes a cursor leak which limits database resources.
  
  EXPECTED RESULT:
  When the search is performed, database resources should be
  freed up allowing reused connections.
  
  ADDITIONAL INFO:
  N/A
  
  ENVIRONMENT (SYSTEM INFO):
  App Server IBM WebSphere Application Server 9.0.0.7
  Version Tivoli's process automation engine
  7.6.0.9-IFIX20180227-1319 Build 20171127-0100 DB Build V7609-45
  HFDB Build HF7609-02IBM Maximo Asset Management Work Centers
  7.6.0.3 Build 20171121-0723 DB Build V7603-175IBM Maximo
  Enterprise Adapter for Oracle Applications
  7.6.0.0-20171120-1031 Build 20150804-1717 DB Build V7600-05
  HFDB Build HF7600-02IBM TPAE Integration Framework 7.6.0.9
  Build 20171126-2330 DB Build V7609-32IBM Maximo Asset
  Management 7.6.0.9 Build 20171127-0100 DB Build V7604-01
  Server OS Windows Server 2012 R2 6.3
  Server DB Microsoft SQL Server 12.0 (12.00.5571)
  
  LOCAL FIX:
  N/A
  

Local fix

• Do not add long description search to applications.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO users on SQL Server                                   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * PROBLEM:                                                     *
  * Cursors remain open in database when searching long          *
  * description                                                  *
  * in any application.                                          *
  *                                                              *
  * PERFORMANCE ISSUE:                                           *
  * Yes                                                          *
  *                                                              *
  * STEPS TO REPRODUCE:                                          *
  * In application designer, long description to the additional  *
  * search fields screen.                                        *
  * Open application, navigate to additional searches, and then  *
  * search on long description.                                  *
  *                                                              *
  * CURRENT ERRONEOUS RESULT:                                    *
  * Causes a cursor leak which limits database resources.        *
  *                                                              *
  * ============================================================ *
  * =====================                                        *
  * This problem has been addressed by APAR IJ09070. If the fix  *
  * for this APAR IJ07949 is needed, request fix for IJ09070.    *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

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

Applicable component levels

• R760 PSY

     UP