on 08-18-2008 9:39 PM
Hi all,
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.
Thanks!
Joy
Hi Joy
Can you help me please? I get the same error as you did and would like to know what this issue was and how you manage to solve it.
Your assistance would really be appreciated
Best wishes
Donovan.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
better create message with SAP under component GRC
not many expert available in ERM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Joy,
Were you able to find a solution for your issue? We too are having trouble getting the Activity Value Sync job to complete successfully.
Any info would be greatly appreciated!
Thanks,
--
Jes Behrens
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Everyone,
Whenever the Activity Sync job is being run, the table VT_RE_OBJFLDVAL is first emptied for a particular connector and then it is repopulated with values from the backend system. During this process, many a times duplicate values can be fetched from the backend system and these are values which the ERM code is unable to insert since it had already inserted one of the values beforehand.
Therefore, it would not cause any issue, because the value is already there in the database. Hence you can safely ignore the error message in the logs.
Hope this helps.
Best Regards,
Sirish Gullapalli.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.