Memory Based Planner - Ends in Error
Hello ,
I am receiving the below MBP error as part of the supply plan run in ASCP. if I run again sometimes this MBP runs sucessfuly. Please let me know if there is a resolution or root cause for this issue/any suggestion to troubleshooting is appreciated.
Thank you!
Ray
value used for ROWS parameter changed from 1000 to 167 Record 5727295: Rejected - Error on table "MSC"."MSC_FULL_PEGGING#". ORA-00001: unique constraint (MSC.MSC_FULL_PEGGING_U1) violated MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run. Table "MSC"."MSC_FULL_PEGGING#": 5727294 Rows successfully loaded. 1 Row not loaded due to data errors. 0 Rows not loaded because all WHEN clauses were failed. 0 Rows not loaded because all fields were null. Space allocated for bind array: 997658 bytes(167 rows) Read buffer bytes: 1048576 Total logical records skipped: