Hi, we are working on our 10.2.200.13 upgrade and have encountered an error during our DB conversion at the step in the header of this post.
This is the error listed on the log: Error Upgrade Process UpdateSchemaNameCols.sql Violation of PRIMARY KEY constraint ‘PK_ChgLog’. Cannot insert duplicate key in object ‘Ice.ChgLog’. The duplicate key value is (PTA, ACTRevision, Erp, ACTRevision, 44, 44~45, , 2015-05-09, 0, ).
Has anyone run into this, and if so how did you resolve it?
Looks like we had duplicate records in our ice.chglog table. Deleting them allowed me to continue with the DB conversion process.
aidacra
(Nathan your friendly neighborhood Support Engineer)
3
There is an existing SCR to address this automatically through the upgrade process. Support as a CTE that will find the duplicates on ice.Chglog and remove them for those that are running into the same issue with UpdateSchemaNameCols.sql and Ice.Chglog | ACTRevision