Details
-
Fix
-
Status: Released (View Workflow)
-
Major
-
Resolution: Fixed
-
1.9.1, 1.9.2, 1.9.3, 1.9.4
-
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.