Upgrade: The duplicate key value - PSPROJECTWORK - AR_POSTING.DRREALGL.Step01A.SQL
As part of upgrade from 8.9 to 9.1 application and 8.50 to 8.51 tools, we were running one of the step in Change Assistance which compares 8.9 demo with 8.9 Prod copy.
But we are getting an error.
Error Message
The duplicate key value is (UPGCUST , AR_POSTING DRREALGL Step01A S Failed SQL stmt:INSERT INTO PSPROJECTWORK (PROJECTNAME, DBINDICATOR, OBJECTVALUE1, OBJECTVALUE2, OBJECTVALUE3, OBJECTVALUE4) VALUES (:1, :2, , :4, :5, :6)
I have verified AR_POSTING and found there are two steps with same name in DRREALGL section i.e. Step01A (lower case) and STEP01A (upper case).
I have modified the step name from Step01A to Step01A9 and ran the compare report step through Change Assistance and it went to success.