Symptom
When you try to upload (Create/Update) records through Data Workbench, system throws below error.
Error: Locking object not possible; object locked by XXX (where XXX is the User ID).
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to Data Workbench work center
- Click on Import
- Select Individual Object
- Select Update
- Search for the Object
- Click on Next
- Upload the exported file
- Click on Next until Import Data
- Click on Import Data
- Click on Monitor
- The task has been finished with errors. In the column Errors, the above error message is displayed.
Cause
This issue could happen for any object and the cause may vary, based on object, record, sequence and so on.
Below are some of the known causes and ways to rectify the issue.
Resolution
S.No | Object | Cause | Resolution/Workaround | Additional Info |
1 | Service Request / Tickets |
If HeaderObjectId and ParentObjectId are removed from the export file, then this leads to data records being sent in parallel and to a locking issue. |
Ensure that you don't remove HeaderObjectId and ParentObjectId and only update the column value that needs to be updated. | |
2 | Account Contact Persons |
You try to assign the same contact ABC to a list of multiple accounts. As this is a rather seldom use case, the service is optimized to import account contact relationships grouped by account, and to perform changes for different accounts in parallel sessions. This optimizes throughput - many more customers have multiple contacts assigned to one account, instead of having the same contact assigned to multiple accounts. Unfortunately there is no flexibel way to control the way of processing, based on data provided in an input file. |
To import account contact relationships, you can use service BusinessPartnerRelationship as this service does not use parallel sessions. |
Account Contact Persons is a sub-entity in customer service. For sub entities, the records group them on parentID (parent External key or parent internal ID). |
Keywords
cannot, can't, not possible, not able , KBA , LOD-CRM-INT-DWB , Data Workbench , Problem