IBM Support

IV71528: MAXIMUM OPEN CURSORS EXCEEDED WHEN DELETING LARGE FAILURE CODE STRUCTURES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Error Code 1000 when trying to delete very large Failure Code
    Hierarchies in our example we had 100's of Problem codes
    assocaited.
    
    Getting error:
    
    BMXAA6713E - The MBO fetch operation failed in the mboset with
    the SQL
    error code 1000.  The record could not be retrieved from the
    database.
    See the log file for more detail about the error.
    
    Or
    
    BMXAA4210E - Database error number 1000 has occured.  Invalid
    SQL
    queries are logged in the log file.  Check the SQL query to
    identify
    the error.
    
    
    Steps to recreate:
    For recreation in Failure Code Application PROB100 to PROB110
    have been
    set up with large number of Causes and Remedies.
    
    
    Go To -> Assets -> Failure Code
    Seach for "testcode"
    Click on "Failure Code" header under the Problems Section to
    sort
    Problems so that
    PROB100 is at the top
    Click *Trash Can* next to PROB100, PROB101, PROB102, PROB103
    Click Save
    Click the Trash Can next to PROB104
    
    
    As soon as I click the Trash Can on PROB104 you get:
    Error flash across the top of the screen "BMXAA6713E - The MBO
    fetch operation failed in the mboset with the SQL
    error code 1000.  The record could not be retrieved from the
    database."
    
    or
    
    Or a dialogue box with "BMXAA4210E - Database error number 1000
    has occured.  Invalid SQL
    queries are logged in the log file.  Check the SQL query to
    identify he error."
    

Local fix

  • Reload the application and delete the next set.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users who want to delete Problem(s) from an extensive        *
    * Failure Code hierarchy.                                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Maximum Open Cursors Exceeded error thrown after user        *
    * attempts to delete Problem(s) from an extensive Failure Code *
    * hierarchy. Message shown in UI, such as "BMXAA6713E - The    *
    * MBO fetch operation failed in the mboset with the SQL error  *
    * code 1000.  The record could not be retrieved from the       *
    * database. See the log file for more detail about the error." *
    * or "BMXAA4210E - Database error number 1000 has occured.     *
    * Invalid SQL queries are logged in the log file.  Check the   *
    * SQL query to identify the error."                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply Fixpack Release TPAE 7.5.0.9 or request an Interim     *
    * Fix.                                                         *
    ****************************************************************
    

Problem conclusion

  • Users now able to delete Problems from Failure Code hierarchies
    without error.
    
    The fix for this APAR is contained in the following maintenance
    package: Fixpack Release TPAE 7.5.0.9.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV71528

  • Reported component name

    MAXIMO SYSTEMS

  • Reported component ID

    5724R46AV

  • Reported release

    750

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2015-03-27

  • Closed date

    2015-04-08

  • Last modified date

    2015-04-08

  • 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

    ASSETS

  • Fixed component ID

    5724R46AS

Applicable component levels

  • R750 PSY

       UP

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"750","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
09 April 2023