Details
-
Fix
-
Status: Released (View Workflow)
-
Major
-
Resolution: Fixed
-
1.9.7, 1.10.1
-
None
Description
Curent Situation
sos/notification/CheckHistory job ends in some cases whith the Oracle SQL Exception:
ORA-01407: cannot update ("SCHEDULER"."SCHEDULER_MON_NOTIFICATIONS"."ERROR") to NULL
Cause: update end times in the monitoring tables cannot find the related items in the scheduler history tables.
Workaround
Set job/order parameter allow_db_dependent_queries = false
Desired Behavior
sos/notification/CheckHistory update end times statement must be executed without error