You’re offline. This is a read only version of the page.
390
Hi,
We are getting a generic sql error while updating a record inside the workow. This error occurs not for all cases but the error occurs for the same update entity. We are not having clue to find what is causing this issue. Any idea please help.
*This post is locked for comments
Hi Jayakumar ,
Once I had got this Generic SQL error
and it occurred because the same field is updating at the same time by Mapping and plugins
Make sure to check if there any OOB functionality or custom functionality is running on same thing
Hi,
Generic Sql error is mostly due to a deadlock. Ensure your workflow logic and any plugins related to the same operation. If you are doing an update and also doing a retrievemultiple in some kind of a loop then it may cause this.
Hope this helps.
Hi Jayakumar,
what is exactly the error that you are getting? and can you please give us more details about?
Thanks.
Hi
Please enable trace and try the workflow to get to the actual error message.
Please see below for how you can enable trace and read the logs
You can enable tracing using the following tool
Download the archive, unzip, under the releases folder, rename the file inside the folder 5 to .zip and unzip this to get the actual exe. Copy this across to crm server an run and enable trace
And you can use the traced reader to identify the error easily
Download the archive, unzip the file, under the releases folder, rename the file in folder 3 to .exe and this is the reader application. Copy this across to CRM server to read the trace file
Make sure you disable the tracing once you done the debugging as it will be logging a lot of data and might quickly fill up the server hard disk
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (