I am implementing GRC Access Controls 5.2 and am encountering some issues with ERM (Role Expert) background jobs. I scheduled an immediate Activity Value Sync and the job was still "running" after 4 days. So I deleted it and created another Activity Value Sync job. This time, it completeld after several hours; however, when I checked the Log History > System Logs, I noticed that the job was erroring the following message:
[Thread-5369] ERROR [NWMss][SQLServer JDBC Driver][SQLServer]Violation of PRIMARY KEY constraint 'PK__VT_RE_OBJFLDVAL__6B45E334'. Cannot insert duplicate key in object 'dbo.VT_RE_OBJFLDVAL'.
2008-08-18 15:20:47,489 [Thread-5369] ERROR Couldn't insert record due to above error for object :0 field :1 value :06
This message repeated, identically, except that value :06 is variable for a number of activity values - 01, 02, 03, 27, 36, 90, etc.
What is the PRIMARY KEY constraint 'PK__VT_RE_OBJFLDVAL__6B45E334'? Does this error message prevent the activity value sync from fully syncing back-end data with ERM or does it simply indicate that existing values cannot be overwritten.
We are currently on SP9. I have searched OSS Notes and the board and have not found anything pertaining to this issue, so any advice would be greatly appreciated.