IBM Support

IJ03496: ORA-01000 OPEN CURSOR ISSUE CAUSED BY RUNNING ESCALATION.

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The following issue is reproduced in Maximo 7.6.0.9 with
    Scheduler 7.6.7 installed.
    
    In the escalation application create the following escalation
    against work order
    
    Condition:
    status in ('TECO','UTC') and sysdate > statusdate + 180 and not
    exists ( select 1 from maximo.poline pl where pl.refwo =
    workorder.wonum and pl.revisionnum = ( select max(revisionnum)
    from maximo.po po where po.ponum = pl.ponum
    and po.siteid = pl.siteid and po.historyflag = 0 ) ) and not
    exists ( select 1 from woancestor a where a.ancestor =
    workorder.wonum and a.hierarchylevels > 0 and exists ( select 1
    from maximo.poline pl where pl.refwo = a.wonum and
    pl.revisionnum = ( select max(revisionnum) from maximo.po po
    where po.ponum = pl.ponum and po.siteid = pl.siteid and
    po.historyflag = 0 )))
    
    Escalation point:
    
    Elapsed time attribute: STATUSDATE
    
    Elapsed time: 1.00 DAYS
    
    Action: WO CLOSE
    
    Object: WORKORDER
    
    Type: Change Status
    
    Value: CLOSE
    
    When the escalation runs it seems to be leaving open cursors,
    instead of them being closed once it runs. Eventually it leads
    to the error Ora-01000 message.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Users of the Escalation Application in Scheduler 7.6.7       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * ORA-01000 OPEN CURSOR ISSUE CAUSED BY RUNNING ESCALATION.    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • A code fix has been delivered.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ03496

  • Reported component name

    MAXIMO SCHEDULE

  • Reported component ID

    5724R46SE

  • Reported release

    767

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-01-22

  • Closed date

    2018-01-25

  • Last modified date

    2018-01-25

  • 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 SCHEDULE

  • Fixed component ID

    5724R46SE

Applicable component levels

  • R767 PSY

       UP



Document information

More support for: Maximo Asset Management Scheduler

Software version: 767

Reference #: IJ03496

Modified date: 25 January 2018