• State Not Answered
  • Locked Locked
  • Replies 5 replies
  • Subscribers 95 subscribers
  • Views 10040 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Sync with SAP CUA issue - FULL SYNC Processing very long and slow for some step

m.p.
over 8 years ago

Hi,

I have some issues with synchronizing IM 7.1 with SAP CUA. I have configured projects according to the documentation. When I start Sync with CUA master (I have added SAP CUA childs before and did partial sync as described in doc) - I can observe that bellow steps:

'Executing synchronization step (userInCUARole) (Step 31 of 33)... (7421 of 98117)'

takes a very long time - and are executed very slowly. I can observe that following statement is the most time consuming in DB:

create trigger SAP_TISAPUserInSAPRole on SAPUserInSAPRole  for Insert not for Replication as begin  declare @DBQueueElements QBM_YDBQueueRaw declare @IsFullSync .......

Even after over 24 hours the job is still running and there is e very small number of assignments in IM (user to sap role).

Any idea why it is processing very slowly? This is fresh installation.

m.p.

Parents
  • 0 over 8 years ago
    Hi Markus,
    Thank you for helping. I have opened the SR for this issue.
    This is a test environment (v 7.1) - there are more than 15 child systems in CUA but I have connected only two of them to the IM (because I was not sure if I have to connect all of them). It is the first synchronization. The Job server is not such powerful but I do not see a lot of RAM/CPU utilization during the sync - I can see in logs that IM reads a lot of SAP roles, profiles (quite quickly) , and SAPUserInSAPRole records from CUA but for step "userInCUARole" insert to the table in IM takes ages ....
    Can you confirm that I have to connect all SAP child systems to the IM?
    Is it possible to filter clients to synchronize from CUA?
Reply
  • 0 over 8 years ago
    Hi Markus,
    Thank you for helping. I have opened the SR for this issue.
    This is a test environment (v 7.1) - there are more than 15 child systems in CUA but I have connected only two of them to the IM (because I was not sure if I have to connect all of them). It is the first synchronization. The Job server is not such powerful but I do not see a lot of RAM/CPU utilization during the sync - I can see in logs that IM reads a lot of SAP roles, profiles (quite quickly) , and SAPUserInSAPRole records from CUA but for step "userInCUARole" insert to the table in IM takes ages ....
    Can you confirm that I have to connect all SAP child systems to the IM?
    Is it possible to filter clients to synchronize from CUA?
Children
No Data