Archive

Archive for August 22, 2015

SQL Timeout error while exporting solution – CRM

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 .

🙂

Categories: CRM Tags: , ,

Trigger USD event from CRM Hosted Control’s Jscript

August 22, 2015 1 comment

In one of our requirement we had to trigger a USD Event from CRM Hosted Control’s onchange event of an option set.

Below are the steps to invoke USD event from option set’s ‘onchange’ event.

  • Assume your USD event name is “USDOnChange
USD - Events

USD – Events

  • In my CRM Hosted Control’s onchange event placed this statement

function TriggerUSDOnchangeEvent() {

window.open(“http://event/?eventname= USDOnChange“);

}

🙂

Categories: CRM, USD Tags: ,