Uploaded image for project: 'JITL - JobScheduler Integrated Template Library'
  1. JITL - JobScheduler Integrated Template Library
  2. JITL-266

Monitoring Interface. Oracle: SQLException: ORA-01407: cannot update ("SCHEDULER"."SCHEDULER_MON_NOTIFICATIONS"."ERROR") to NULL

    XMLWordPrintable

Details

    • Fix
    • Status: Released (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.9.7, 1.10.1
    • 1.9.8, 1.10.2, 1.11
    • 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

      Attachments

        Activity

          People

            re Robert Ehrlich
            re Robert Ehrlich
            Robert Ehrlich Robert Ehrlich
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: