Rajeev Pentyala – Microsoft Power Platform

Other day my CRM solution export stopped working and I was getting ‘SQL Timeout’ exception while export.

In the event viewer there was an entry with below content

Query execution time of 30.7 seconds exceeded the threshold of 10 seconds. Thread: 38; Database: {Organization_MSCRM}; Server:192.168.36.7; Query: update [WorkflowBase] set [SupportingSolutionId]=’00000000-0000-0000-0000-000000000000′, [OverwriteTime]=’01/01/1900 00:00:00′

Its bit surprising because my solution hardly had 10 components and timeout due to oversize is unlikely.

Troubleshoot steps 

• Reset IIS and Restarted CRM Async & SQL Services

• Finally restarted both CRM Application server and DB Server to complete software updates. But no luck.

 Reason

With failed restart machines solution I dig deeper in to event viewer log and found the reason

• In my case since my event viewer log pointing to “update [WorkflowBase]” query I thought problem would be with workflow. I removed all workflows from my solution and tried exporting. But no luck.
• Then I removed my ‘SLA’ from the solution since SLA create workflows when you configure SLA Items. Now solution export worked.

Fix

• By fixing the SLA issue (i.e., In our case we delete a field from Case entity and same not updated in SLA Success criteria). After correcting my SLA  I was able to include SLA in my solution and export .

🙂