0 Replies Latest reply: Apr 19, 2010 10:15 AM by 807573 RSS

    SQL Error while creating data Owner certification in SRM 5.0.3

    807573
      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.