Getting error: Microsoft.Cloud.Platform.Utils.AcquireLockTimeoutException

[Anonymous]

Hi, we are making REST http calls to PBI, but sometimes we are getting this error:

{"error":{"code":"GeneralException","message":"Failed to process dataset PostRows","target":"PostRows","details":[{"message":"Exception of type 'Microsoft.Cloud.Platform.Utils.AcquireLockTimeoutException' was thrown."}]}}
Request URI: /v1.0/myorg/groups/HIDDENGUID/datasets/HIDDENGUID/tables/WORKORDER/rows

{"error":{"code":"GeneralException","message":"Failed to process dataset DeleteRows","target":"DeleteRows","details":[{"message":"Exception of type 'Microsoft.Cloud.Platform.Utils.AcquireLockTimeoutException' was thrown."}]}}
Request URI: /v1.0/myorg/groups/HIDDENGUID/datasets/HIDDENGUID/tables/WORKORDER/rows

Any idea on what it might be? Thanks! 

[Anonymous]

Hi  @Anonymous ,

I can understand that there is no other sources trying to update the tables, if possible, may you kindly try to configure some retry logic for the "Delete" API that randomly get 500 AcquireLockTimeoutException to further avoid this random error affecting the business in the future?

Retry a failing request - 🙋 Help - Postman Community

How to rerun the same request a few times - 🙋 Help - Postman Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks for the reply from lbendlin , please allow me to provide another insight: 

Hi  @Anonymous ,

This error indicates that there was a timeout while trying to acquire a lock, which prevented the dataset from processing the PostRows request. 

Please kindly check if there's a chance for your HTTP post process to add some retry logic to avoid the one time failure, and if you are posting a large number of rows, consider breaking them into smaller batches. This can reduce the likelihood of lock contention and improve the overall performance of your data load operations.

Another possible root cause is that you need to ensure that the dataset and table you are trying to post rows to are not being updated or processed by another operation simultaneously. This can cause lock contention and result in timeout errors.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

i can confirm that there is no other sources trying to update the tables. But i randomly get this 500 AcquireLockTimeoutException. Even when i am trying to delete the rows, which should be empty anyways because i had deleted them previously.

[Anonymous]

Yes 100% no other sources deleting/pushing rows.

[lbendlin]

Is someone else pushing rows into that dataset while you are trying to truncate the table?