• 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

    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.

Reply
  • 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.

Children
No Data