IBM Support

JR57597: YOU RECEIVE THE ORA-01873 EXCEPTION WHEN YOU RUN THE BPMDELETE DURABLEMESSAGES COMMAND AND THE MESSAGE IS OLDER THAN 99 DAYS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If you use Oracle as the IBM Business Process Manager (BPM)
    database and you run the BPMDeleteDurableMessages command to
    delete durable subscription messages that are older than 99
    days, you receive the following database exception:
    
    ORA-01873: the leading precision of the interval is too small
    
    
    PRODUCTS AFFECTED
    IBM BPM Advanced
    IBM BPM Standard
    IBM BPM Express
    

Local fix

Problem summary

  • The Oracle database query to delete durable subscription
    messages uses the interval literal operator to select messages
    for deletion. However, the query does not specify a value for
    the interval parameter of the operator. Because the precision of
    the interval literal operator defaults to 2, you receive the
    ORA-01873 exception when you use a value for the olderThan
    parameter of the BPMDeleteDurableMessages command that is more
    than 2 digits.
    

Problem conclusion

  • A fix will be available in IBM BPM V8.5.7 cumulative fix 2017.03
    that adjusts the database query to use the correct interval
    precision.
    

Temporary fix

Comments

APAR Information

  • APAR number

    JR57597

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    857

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-03-14

  • Closed date

    2017-03-20

  • Last modified date

    2017-03-20

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    BPM STANDARD

  • Fixed component ID

    5725C9500

Applicable component levels

  • R857 PSY

       UP

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"857","Edition":"","Line of Business":{"code":"LOB36","label":"IBM Automation"}}]

Document Information

Modified date:
20 March 2017