SAP Knowledge Base Article - Public

2831761 - Error in Data Workbench: 'Locking Object Not Possible; Object Locked By XXX'

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

  1. Go to Data Workbench work center
  2. Click on Import
  3. Select Individual Object
  4. Select Update
  5. Search for the Object
  6. Click on Next
  7. Upload the exported file
  8. Click on Next until Import Data
  9. Click on Import Data
  10. Click on Monitor
  11. 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 and much more customers have multiple contacts at one account as 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.

You can do to import account contact relationships is to 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 grouping 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

Product

SAP Cloud for Customer core applications 1905