Direct links to fixes
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