AnsweredAssumed Answered

Problem with copy of Clarity Database SQL 2008

Question asked by joni.campos on May 18, 2011
Latest reply on Nov 24, 2011 by another_martink
HI,

I copied the Clarity niku database to antoher database nikudev for making our develop enviroment. I am not a DBA...

Now I am getting this error :

SQL error code: 2627
Error message: [CA Clarity][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'CMN_SEC_ASSGND_OBJ_PERM_PK'. Cannot insert duplicate key in object 'niku.CMN_SEC_ASSGND_OBJ_PERM'.

It seems to be a permission problem. It works in the production environment.

Any ideas ?

Outcomes