Repository sync is not updating GRACUSERCONN
Some customers are experiencing the following issue after upgrade to GRC 10.1 SP 10 and SP11:
Despite repository sync job is completed without any dumps the table GRACUSERCONN is not updated,
To solve this issue implement SAP Notes below
2221261 – Code changes in repository sync for performance improvement
2168872 – Inconsistent entries in table GRACUSER and GRACUSERCONN
2256786 – All data for Portal Users not updated in Repository Sync
IF the issue still persists follow the steps in SAP Note below:
2253834 – Repository sync collection of corrections
For missing user type in GRACUSERCONN please implement SAP Note below:
2250690 – Some Portal Users missing in Repository Sync
2259378 – Repository Sync issue with expired and locked users – plugin
Regards
Rafael Guimbala
Hi Rafael,
As the notes are part of SP11, system doesn't allow to implement or de-implement to implement again.
Can you suggest a process to do that?
Thanks,
Sabita
Hi Sabita,
If you are already in SP 11 is not possible do implement or de-implement those notes, please open a thread with more details about the connector type and with the symptoms that you are getting,
Thanks,
Rafael
Thanks Rafael,
I saw one similar post where they said that even though they were at SP11, they had to re-implement the note, that led me to this question 🙂 The second note (and side-effect note with it) helped me resolve the issue! SAP also referred to one Master note related to sync issues and this was the only one applicable 🙂
Many thanks!
Regards,
Sabita
Hi Sabita,
I have also faced the same issue recently and not it got resolved.
in SP11, the below notes are already included
2221261 - Code changes in repository sync for performance improvement
2168872 - Inconsistent entries in table GRACUSER and GRACUSERCONN
Please schdule the back ground jobs with all the sync jobs then the table GRACUSERCONN will be updated.
Regards,
baburao
Thanks a lot for sharing Baburao and Sabita!
No problem Rafael..
After generating the rule set it is not updating by last updated by name ?
Thankyou for this information Rafael .. We too faced this issue in our upgrade . I would like to add one more consolidated note here related to rep sync
2253834 - Repository sync collection of corrections
Thanks for sharing Harsha, I will include your suggestion 🙂
Hi Rafael,
It was applied to the notes informed and the environment continues with the same problem, have any more suggestions.
The sync is performed to Role, but for users is not added anything in GRACUSERCONN table, even after the application of informed notes.
We are in NW7.4 GRC AC 11 SP 11 - Oracle and AIX.
I appreciate the help.
My cell contact <redacted by Moderator, per SCN Rules of Engagement>
Hi Inacio,
The job GRAC_ROLEREP_USER_SYNC is running without issues (stad, st22)?
what type of connector you are trying to sync?
Regards
Rafael
Hi Rafael,
The job runs without errors, there is not error in the log of SLG1, ST22, but grauserconn table is not populated.
Carried out a debug in GRAC_ROLEREP_USER_SYNC program and noticed strange behavior in implementing these lines 233- 234:
The connector is legacy, as I said the same settings in another GRC AC NW74 in SP09 and runs normally.
Regards
Inacio
Hi Inacio,
Try to implement the SAP Note 2256786 - All data for Portal Users not updated in Repository Sync
Regards
Hi Rafael,
The note 2256786 is appliad
Hi Rafael,
The note that you mentioned, had already been implemented, and continue with the problem.
Have any more suggestions?
Regards,
Inacio
Hi Inacio,
Please open a thread in SCN, if this not resolve please open a SAP Incident,
Regards,
Rafael