SQL Server Trace Flag 4616 no longer required for Dynamics NAV 5.0 SP1 or Dynamics NAV 2009 SP1

Starting with Dynamics NAV 4.0 SP3 build 24080, all builds of NAV (SQL option) have a prerequisite that SQL  Server trace flag 4616 must be turned on. This was initially required when running NAV with SQL Server 2005 but subsequently was also required for SQL Server 2008 when that became a supported database platform. Why…

1

Calendar Control cut off within IE8 in CRM 4.0 web clients.

Popup are shown cut-off if the CRM window is maximised and the popup is near the edge of the window. This was resolved in the following Updates for Internet Explorer 8 http://support.microsoft.com/kb/974455 To fix this issue install the update by going to Windows Update: Windows Update is included in Control Panel. Click the Start button,…

1

Import Organization problems – ExecuteNonQuery requires an open and available Connection. The connection’s current state is closed

The Import organization process is failing with the following error message: Platform Error ===================================== 19:03:33| Error| Import Organization (Name=<OrgName>, Id=<OrgID>) failed with Exception: System.InvalidOperationException: ExecuteNonQuery requires an open and available Connection. The connection’s current state is closed. at System.Data.SqlClient.SqlConnection.GetOpenConnection(String method) at System.Data.SqlClient.SqlConnection.ValidateConnectionForExecute(String method, SqlCommand command) at System.Data.SqlClient.SqlCommand.ValidateCommand(String method, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName,…

0

Slow CRM performance with McAfee script scanning enabled

We have had numerous reports that the loading of CRM pages is delayed on clients that use McAfee and have the script scanning option enabled. An option to whitelist the CRM namespace is now avalable. Further details at https://kc.mcafee.com/corporate/index?page=content&id=KB65382 Best Regards Lutz Eickenberg CRM Escalation Engineer

2

Identify and kill SQL processes causing CPU shortage

There might be cases in which the SQL processes running against the MSCRM database, start using all available CPU resources causing bad performance and downtimes. Using the following script it is easy to identify which processes are running in the SQL instance and, take reactive actions. — THIS SCRIPT HAS TO BE USED IN CASE THE…

1

Update Rollup 4 for Microsoft Dynamics CRM 4.0 is available

       KB968176    Update Rollup 4 for Microsoft Dynamics CRM 4.0 is available: http://support.microsoft.com/kb/968176          You can download Rollup 3 from the following link: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0ddf8e83-5d9c-4fe7-9ae6-f2713a024071 The update is applicable to the following CRM Components: ·         Microsoft Dynamics CRM 4.0 Server ·         Microsoft Dynamics CRM 4.0 Email Router ·         Microsoft Dynamics CRM 4.0 Outlook Client ·         Microsoft Dynamics…

1

Script to clean up SyncEntry_<GUID> and SubscriptionStatistics_<GUID> tables in the SQL database

SyncEntry_<GUID> and SubscriptionStatistics_<GUID> tables are created in the <CompanyName>_MSCRM SQL Database when using the CRM-outlook clients.  Generally you will have 2 of each table for each Online Client, and 3 of each table for each Offline Client.  However, these tables are created per user per machine, so in a citrix farm environment or if users…

9

Update Rollup 3 for Microsoft Dynamics CRM 4.0 is available

Update Rollup 3 for Microsoft Dynamics CRM 4.0 is available. This update rollup is available for all languages that are supported by Microsoft Dynamics CRM 4.0. The Below link contains the Issues addressed in this rollup 961768    Update Rollup 3 for Microsoft Dynamics CRM 4.0 is available http://support.microsoft.com/default.aspx?scid=kb;EN-US;961768 You can download Rollup 3 from the following link http://www.microsoft.com/downloads/details.aspx?FamilyID=05453fa4-9551-4a88-9852-634a9ad0e140&displaylang=en…

0

Update Rollup 2 for Microsoft Dynamics CRM 4.0 is available

Update Rollup 2 for Microsoft Dynamics CRM 4.0 is available. This update rollup is available for all languages that are supported by Microsoft Dynamics CRM 4.0. The Below link contains the Issues addressed in this rollup 959419    Update Rollup 2 for Microsoft Dynamics CRM 4.0 is available http://support.microsoft.com/default.aspx?scid=kb;EN-US;959419 You can download Rollup 2 form the…

1