topic Re: Getting error: Microsoft.Cloud.Platform.Utils.AcquireLockTimeoutException in Developer

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

Anonymous — Thu, 24 Oct 2024 16:28:25 GMT

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!

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

lbendlin — Fri, 25 Oct 2024 01:04:36 GMT

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

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

Anonymous — Fri, 25 Oct 2024 06:15:18 GMT

Yes 100% no other sources deleting/pushing rows.

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

Anonymous — Tue, 29 Oct 2024 07:29:47 GMT

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.

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

Anonymous — Wed, 30 Oct 2024 11:27:15 GMT

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.

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

Anonymous — Thu, 31 Oct 2024 07:56:09 GMT

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.