{"id":69,"date":"2012-02-28T11:03:00","date_gmt":"2012-02-28T05:33:00","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=69"},"modified":"2012-02-28T11:03:00","modified_gmt":"2012-02-28T05:33:00","slug":"issue-with-plug-in-in-crm-2011","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2012\/02\/issue-with-plug-in-in-crm-2011\/","title":{"rendered":"Issue with plug-in in CRM 2011"},"content":{"rendered":"
\n
We had a requirement to do some calculation and update self record of custom entity. We have created a plug-in and registered it on post operation of update event. The code was reading the post image, updating some fields and updating the same.<\/p>\n

The plug-in was working fine for single record. But when two records are saved simultaneously, the plug-in was giving below errors randomly.<\/p><\/div>\n

<\/p>\n

1. “ValidateOpen – Encountered disposed CrmDbConnection when it should not be disposed”
2. “You cannot create a SqlExecutionContext from another SqlExecutionContext on which OnBeginRequest has not been called”
3. ” System.InvalidOperationException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #58919D7E”
4. “System.NullReferenceException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #1638FFA8”<\/p>\n

When we checked in the Event viewer then we got that whatever error we get from CRM the Event viewer shows “System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first.” error.<\/p>\n

After searching on net we found that CRM does not re-initialize the plug-in object again, it uses the same object. In the plug-in, ignore to use class level variables. We had created service object at class level so it was using the same service object for retrieving and updating.<\/p>\n

Also we were reading post image and updating the post image as it is. This was also creating a problem. Please create a new object of Entity and then set only those fields which you want to update. Then update the record.<\/p>\n

Sometimes this plug-in takes too much time as it was doing so many calculation. We were getting the “Query execution time of 30.1 seconds exceeded the threshold of 10 seconds. Thread: 4; Database: inogic_MSCRM ” error when plug-in takes time. To resolve this, please add below keys in the registry on CRM server.
1) HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\MSCRM\\OLEDBTimeout
a<\/strong>. In seconds
b.<\/strong> The OLEDBTimeout value controls the SQL time-out value that is used for a single SQL query
c.<\/strong> Set it to 60 seconds <\/div>\n

<\/p>\n

2) HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\MSCRM\\ExtendedTimeout
a.<\/strong> In milliseconds
b.<\/strong> The ExtendedTimeout value controls the ASP.NET time-out value
c.<\/strong> Set it to 1,000,000 <\/div>\n

<\/p>\n

3) HKEY_LOCAL_MACHINE\\SOFTWARE\\Microsoft\\MSCRM\\NormalTimeout
a.<\/strong> In milliseconds
b.<\/strong> Specifies the SOAP call timeout for most operations
c.<\/strong> Set it to 300,000<\/div>\n

<\/p>\n

Hope this helps!!<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

We had a requirement to do some calculation and update self record of custom entity. We have created a plug-in and registered it on post operation of update event. The code was reading the post image, updating some fields and updating the same. The plug-in was working fine for single record. But when two records\u2026 Read More: Issue with plug-in in CRM 2011 »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[20,21,22,24,42],"tags":[745,1240,1330],"class_list":["post-69","post","type-post","status-publish","format-standard","hentry","category-dynamics-crm-2011","category-dynamics-crm-2013","category-dynamics-crm-2015","category-dynamics-crm-2016","category-plugin","tag-error","tag-multiple-users","tag-plugins"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t