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 number
IJ07949
Reported component name
MAXIMO SYSTEMS
Reported component ID
5724R46AV
Reported release
760
Status
CLOSED UR5
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-07-20
Closed date
2019-04-01
Last modified date
2019-04-01
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
[{"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:
01 April 2019