IBM Support

JR55707: YOU RECEIVE AN INTERNAL SERVER ERROR ON TASK LISTS WHEN ORACLE IS THE RUNTIME DATABASE IN A TIMEZONE WITH DAYLIGHT SAVING TIME

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • If you use Oracle as the runtime database, you are in a region
    with daylight saving time, the runtime database contains a task
    with the attribute "Task due date" or "At risk time", and that
    value occurs during the missing hour of daylight saving time
    shift, you see an internal server error on tasks lists in IBM
    Process Portal and the following Oracle error in the log files:
    
    "ORA-01878: specified field not found in datetime or interval".
    

Local fix

Problem summary

  • The generated SQL query of the task searches with the At Risk
    column contains a comparison of the current time stamp with the
    values stored in the "Task due date" and "At risk time" column.
    Oracle converts the current time stamp and the values stored in
    the "Task due date" and "At risk time" column into the current
    time stamp with the time zone. If the database contains a time
    stamp in one of those columns, which occurs during the hour of
    the time shift, Oracle reports the error "ORA-01878: specified
    field not found in datetime or interval".
    

Problem conclusion

  • A fix will be included in IBM BPM V8.5.7 CF2016.06.
    
    To determine whether the cumulative fix is available and
    download it if it is, complete the following steps on Fix
    Central:
    
    1. Select IBM Business Process Manager with your edition from
      the product selector, the installed version to the fix pack
      level, and your platform, and then click Continue.
    
    2. Select Text, enter "cumulative fix?, and click Continue.
    

Temporary fix

  • Not applicable
    

Comments

APAR Information

  • APAR number

    JR55707

  • Reported component name

    BPM STANDARD

  • Reported component ID

    5725C9500

  • Reported release

    850

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-04-07

  • Closed date

    2016-05-25

  • Last modified date

    2016-05-25

  • 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

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFTDH","label":"IBM Business Process Manager Standard"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
31 August 2023