PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Getting error while migrating the project from 9.1 to 8.9 copy of project

edited Dec 4, 2013 8:51AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered
Hi Friends,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center