• State Not Answered
  • Locked Locked
  • Replies 5 replies
  • Subscribers 95 subscribers
  • Views 10037 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.

  • 0 over 8 years ago

    The SAP synchronization with CUA reads not only objects from the central client, but also from child clients (also if you configure central client only).

    First of all 1IM reads the ALE distribution model (CUA structure, tables in SAP: USZBVLNDSC and USZBVLNDRC).

    If the whole CUA structure is configured in 1IM, so all assignments from central and child clients are created during the sync.

    I’m not fully sure, what you have done for the configuration of CUA in 1IM. But from my point of view the config of CUA (all child clients) should be fully done, because the error processing (due to lack of full config) consumes a lot of time (only assumption!).

     

    During the sync the list of all CUA roles and CUA profiles are read from the USRSYSACT.

    That table can be really big. How powerful is your job server? Do you see a lot of paging?

    Is it the first, initial synchronization? You should use the revision filters for the next synchronization runs.

     

    But honestly, i would suggest to contact support to help you on that matter.

  • 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?
  • 0 over 8 years ago
    In regards to question one, as I said. From my point of view the config of CUA (all child clients) should be fully done, because the error processing (due to lack of full config) consumes a lot of time (only assumption!).

    In regards to your second question, please be in touch with support. I think yes, but in regards to CUA I am not the expert.
  • 0 over 8 years ago
    Thanks!
    Is it possible to see errors related to the "lack of full config"? I have enabled debug options in Job Server Config but do not see any errors.
  • 0 over 8 years ago
    There will be are no explicit errors but many retries and data in the table DPRAttachedDataStore.