Getting error while migrating the project from 9.1 to 8.9 copy of project
We are getting error when we try to migrate the project from 9.1 demo to 8.9 copy of production.
Below are details.
File: E:\pt85124b-retail\peopletools\src\psmgr\mgrgensql.cppSQL error. Stmt #: 1747 Error Position: 0 Return: 805 - [Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot insert duplicate key row in object 'dbo.PSROLECANGRANT' with unique index 'PS_PSROLECANGRANT'. The duplicate key value is (ADMINISTRATOR, Wireless). Failed SQL stmt:INSERT INTO PSROLECANGRANT ( ROLENAME, GRANTROLENAME) VALUES ( :1, :2)
I have verified 9.1 demo instance and found there are few deuplicate rows present (one in UPPER CASE and other one in lower case)
eg: BUYER & Buyer