GRAC_SPM_LOG_SYNC_UPDATE Job Performance

[Former Member]

We are about to Go live with our Super user Auto Provisioning and Firefighter Log reporting in GRC 10.
Right now GRAC_SPM_LOG_SYNC_UPDATE Job runs for more than day in our ECC/PRD system and we have 11 App Servers in the system.
Currently our RTA Plugins are:
ECC/PRD system is GRCPINW V1000_700 0009 SAPK-10309INGRCPINW
SAP GRC NW Plug-in .
In BI we are on GRCPINW V1000_731 0002 SAPK-
10502INGRCPINW SAP GRC NW Plug-in
In APO we are on GRCPINW V1000_700 0005 SAPK-10305INGRCPINW
SAP GRC NW Plug-in
In SRM we are on GRCPINW V1000_700 0005 SAPK-10305INGRCPINW
SAP GRC NW Plug-in

Our GRC Support pack is 17
Why the job is taking so much time to run in ECC/PRD.
In BI/APO/SRM the job runs every hour successfully.
We are running the GRAC_SPM_LOG_SYNC_UPDATE job every hour in ECC also but only one job runs for more than a day and all other jobs fail.

[Former Member]

Hi Venkat,

could you give more gap between jobs for ecc, and similarly for each connector. There might be locks created by one(for updating table), and therefore result in time-out, for others

regards

plaban

[Former Member]

Hi Plaban,

Thanks for your reply.

We run the Jobs every hour and the time difference between the jobs is 15 mins the jobs in SRM/APP/BI run for just few seconds only because we have only one app server in each system where as in PRD we have 11 App servers.

I have opened the OSS message waiting for there reply.

May be I am thinking  we need to upgrade our  RTA in ECC Right now we are at 5 the latest one is 19.

Regards,

Venkat

[former_member185447]

Hello Venkat,

Please check these Notes for improving the performance of EAM sync job.

1617529 - Best Practices For Improving Performance of EAM Log Sync job

1741151 - GRC 10.0 Indexing on CDHDR table in case of time out issue due to huge data

Regards,

Deepak M

[Former Member]

Hi Deepak,

Thanks we will review the notes.

Regards,

Venkat