ext_order_group_assignment_in.sh script will fail with an error
While running the overnight batch, aip online script ext_order_group_assignment_in.sh fails with the attached error. While doing some back testing, I found that there are some duplicate records that were present in database. After removing the duplicates as well, the script again fails with same error.
To prevent the overnight batches from failing every night, i have been removing the duplicates and static locks everyday before the batch runs..
What i don't understand is how these duplicate records are getting created everyday and how can this issue be fixed ?
I'm currently on RPAS version 14.1.3.35