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

Reporting Interface - aggregation step should not fail if the configuration directory contains duplicate orders

    XMLWordPrintable

Details

    • Fix
    • Status: Released (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.9.1, 1.9.2, 1.9.3, 1.9.4
    • 1.9.5, 1.10
    • None

    Description

      *Current Situation*

      If the scheduler configuration directory contains duplicate orders (e.g. one of live subfolders have a copy) the execution of the aggregation step ends with the error (Oracle message sample):
      Fatal Error:process: java.lang.Exception: updateReportingFromInventory: java.lang.Exception: java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

      *Desired Behavior*
      The duplicate orders must be handled correctly by the aggregation step

      Workaround
      Skip the step aggregation in the job chain sos/reporting/Reporting. The data will no longer be aggreated but will be available for some reports that do not use of the aggreated data.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: