Archive
Azure Web Deploy – Time out errors
Recently when we were trying to publish a web site to Azure ‘Deployment Slot’ using Visual Studio “Web Deploy” option, we encountered either Time out exception or VS hung after few files push.
Reason for this exception could be due to the enormous transactions on main (Prod) web app of the ‘Deployment Slot’.
Work around:
- We found a work around by using Drag and Drop feature of Kudu service deploying to wwwroot folder directly.
Steps:
- Publish the web site to your machines local drive
- ZIP the files (***You must select all the files and Zip it; Don’t zip the folder)
- Open the Deployment Slot’s Kudu Service (Go to ‘Advanced Tools’ -> Go)
- On the Kudu page, navigate to Home -> site -> wwwroot
- Drag and drop the zipped folder of your published web site.
- Wait for the process to complete publish.
🙂
“Query execution time exceeded the threshold” error in Plugins
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)
🙂
Rajeev Pentyala - Microsoft Power Platform 