APAR status
Closed as program error.
Error description
System will throw SQL exception ORA-1000 when running LDAPSYNC. PROBLEM: Phone Mbo set for LDAP Synchronization are not being closed. PERFORMANCE ISSUE: Yes STEPS TO REPRODUCE: Have 50,000 users on Active Directory or higher number of users than the value of open cursor set in the database, then run LDAPSYNC. Check the open cursors from the database and notice that most of them were from Phone Mbo set. CURRENT ERRONEOUS RESULT: System hang and throw ORA-1000. EXPECTED RESULT: The system should not hang and release cursor. ADDITIONAL INFO: ENVIRONMENT (SYSTEM INFO): App Server IBM WebSphere Application Server 8.5.5.3 Version Tivoli's process automation engine 7.6.0.5 Build 20160611-0100 DB Build V7605-45, IBM TPAE Integration Framework 7.6.0.5 Build 20160610-2330 DB Build V7605-50, IBM Maximo Asset Management Scheduler 7.6.3.0 Build 20160611-0100 DB Build V7630-25, IBM Maximo Asset Management Work Centers 7.6.0.0 Build 20160610-1318 DB Build V7600-38, IBM Maximo Asset Management 7.6.0.5 Build 20160611-0100 DB Build V7604-01 Server OS Windows Server 2008 R2 Server DB Oracle 11.2 (Oracle Database 11g Enterprise Edition Release 11.2.0.4.0) LOCAL FIX: N/A
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: * * All Maximo Users * **************************************************************** * PROBLEM DESCRIPTION: * * MAXIMUM OPEN CURSOR EXCEEDED WHEN SYNCING THOUSANDS OF USERS * **************************************************************** * RECOMMENDATION: * * Upgrade to fixpack release 7.6.0.8 of TPAE or request an * * Ifix * ****************************************************************
Problem conclusion
No SQL exception ORA-1000 when running LDAPSYNC due to maximo open cursors exceeded The fix for this APAR is contained in the following maintenance package: | release\fix pack | Fix Pack Release 7.6.0.8
Temporary fix
Comments
APAR Information
APAR number
IV90435
Reported component name
MAXIMO SYSTEMS
Reported component ID
5724R46AV
Reported release
760
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-11-02
Closed date
2017-01-10
Last modified date
2017-01-10
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 SYSTEMS
Fixed component ID
5724R46AV
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:
10 January 2017