SAP Public Cloud 2508 / Errors during the Mass Creation of Business Partner Relationships

[LukasKuhn]

Hello Experts,
we have the following issue during the migration of 2000 Business Partner relationships.
We are using the app  "Manage Mass Creation Processes - BP Relationships (F6560A)" to import BP-Relationships for existing Business Partners.
We split the import into batches of 500, but if we try to activate these, then the system activates 100 of those and then gives the following error:
"User SAP_WFRT is processing the business partners relationship XY"
The error counter varies, if you reprocess the activation, sometimes it goes up one or two, then it drops down, till it activates another 100 entries. Eventually it activates all 500, so we were able to import the first batch. All of this takes a lot of time.

Our question is, is this standard behavior ? Can the tool only import 100 relationships at once and then needs time to process some stuff in the background ? 

We appreciate and advice on how to improve this process.
Best regards
Lukas

[Chris1973 · Accepted solution]

Hello @LukasKuhn 

Thank you for your question.

Yes, and it is a standard behaviour. The simple reason for that error is, the system works in packages and that is set to 100 relationships. Basically, saying you may have “exceeded the limit”.

Let me explain, the error is caused by the MDG mass creation framework locking BP relationships while the technical user SAP _WFRT activates them in the background. This explains why you see about 100 BPs activated, then lock, then another 100 until all 500 are done.

I recommend you activate 500 in the process you are now, click activate just once and let the background job finish. You can monitor through the process log and Application Jobs, rather than re-triggering activation. Also, consider running these jobs when there is less traffic (off-peak hours).

If it is extremely slow, you may consider opening a ticket with SAP to better analyse the performance in your tenant.

Best regards

Chris

[LukasKuhn · Accepted solution]

Hello @Chris1973,
thank you for the response. This seems to be the cause for our problem. At the moment we seem to face a deadlock, because of these locks and the fact that we have relationships for the same business partner spread accross different sets of 100. Can you tell me, if this would be avoided, if we group relationships that contain the same business partners in one set of 100 ?

Best regards 
Lukas 

[Chris1973 · Accepted solution]

Hello @LukasKuhn

Yes,  grouping relationships involving the same BP into one set of 100 can significantly help avoid the locking conflicts you are currently facing. Considering creation happens in parallel background jobs, if the same BP appears across different parallel jobs, it can easily cause deadlocks or serialization issues, especially since SAP_WFRT attempts to lock and activate those records simultaneously.

Best regards

Chris