cancel
Showing results for 
Search instead for 
Did you mean: 

Role Expert - Activity Value Sync error

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

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.

Former Member
0 Kudos

better create message with SAP under component GRC

not many expert available in ERM

Former Member
0 Kudos

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

Former Member
0 Kudos

Hi Jes

Can you help me please? I get the same problem 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.

Former Member
0 Kudos

Guys... Anybody can resolve this? I`m having the same issue...

Thanks!

Former Member
0 Kudos

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.