Rajeev Pentyala – Microsoft Power Platform

Hi,

In one of my requirement I was accessing SSRS service API from my plugin to render and read the report

When the plugin execute the code, I was neither getting the expected result nor any error.

To troubleshoot the problem I open the event viewer and I got a warning stating below

Query execution time of 30.1 seconds exceeded the threshold of 10 seconds. Thread: 30; Database: orgname_MSCRM

Reason :- 

• My plugin registered on Post Update of Account
• In my plugin, I was rendering and reading a report which has dataset with “Select * From Account”
• So the problem is with DB lock
  • On update of ‘Account’, a lock establish
  • In the Plugin code, when I try to render report it tries to execute “Select” statement on “Account” we get the above error

Fix :-

• I modified my Select statement in report dataset with “No Lock” statement

             i.e., Select * From Account (nolock)

🙂