This discussion is archived
0 Replies Latest reply: Apr 19, 2010 8:15 AM by 807573 RSS

SQL Error while creating data Owner certification in SRM 5.0.3

807573 Oracle ACE
Currently Being Moderated
Hi , In SRM 5.0.3, while creating data Owner certification by choosing data owner, I m getting the following error. database i upgraded and the migration script is also run.
java.sql.SQLException: Violation of PRIMARY KEY constraint 'pk_id_attr_val_users'. Cannot insert duplicate key in object 'dbo.id_attr_val_users'. Since Primary key is clustered(cert_id,user_id,attr_val_id) and we have updated currentvalue of CertificationID in sequences table, We are not sure if SRM is trying to enter duplicate attribute value for same user in D.O certification. Any pointers regarding this error will be of great help, thanks.