"How to" collect the "Troubleshooting file for Support" and the SQL Reporting Server logs

If you have already opened a CRM support ticket you will know that we in support will probably ask for the “Troubleshooting file for Support”. This article should help to provide you all the information that is needed to create all relevant “troubleshooting files for support”.   General note: Please copy the CRMDiagTool4 on the…

0

"How to" activate CRM 4.0 Platform Tracing on Server, Client and E-Mail Router

If you have already opened a CRM support ticket you will know that we in support will probably ask for the CRM Platform traces. This article should help to provide you all the information that is needed to create a proper Platform trace.   CRM Server Platform Trace Download the CRMDiagTool4 via the following URL:…

0

Speeding up IIS web site access / IE throughput

As we receive several requests “how to speed up” the CRM web site access the following should help.   “HTTP Keep-Alive” allows Web browsers to reuse the same TCP connection to make multiple requests to a Web server such as Internet Information Server (IIS). If a Web server requires authentication such as Basic, Kerberos, or…

0

After Installing CRM 4.0 Rollup 7 client you might experience an error during the synchronizing

Within support we have seen the following problem several times. After installing Update Rollup 7, you might experience an error when synchronizing your CRM client with CRM server. A generic error is raised: "A SQL Server error occurred. Try this action again."   How to identify the issue Download CRMDiagTool4 from the following location: http://blogs.msdn.com/benlec/pages/microsoft-crm-support-tools-download-page.aspx…

1

Internet Information Services 6.0 may not function correctly after installing KB973917

  We received some information from our IIS colleagues that the above mentioned hotfix KB 973917 which is part of the security update for December will break your IIS 6.0 functionality. This affects web-based products such as CRM, SharePoint, …   After you applied the hotfix KB 973917 the IIS 6.0 application pools cannot startup…

0

How to evaluate the health of the indexes in the CRM databases

  In this article I want to present a way to generate an overview of the health status of the indexes in your CRM database. The following  script can be used to retrieve the fragmentation ratio of each index in the CRM database.  Additionally the script evaluates the point of time when the index’s statistics…

0

How to evaluate the storage space, that is used by the Dynamics CRM database tables

  If you have ever needed a query that shows you in detail the amount of storage space, that every single CRM database table is using, the SQL query in this article will surely be of great value for you.   The query returns for each table in your database the following information: ObjectID:        The SQL…

0

LCIE and CRM pop-up windows blocking

  Consider the following situation. Your CRM 4.0 Client for Outlook runs on Outlook 2007. You have installed IE8 and Rollup 7. When you click on an CRM item that would then need to open in a new window (e.g. one of the detail lines in an Opportunity) you may receive the following error message:…

0

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

  Popup are shown cut-off if the CRM window is maximized 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…

0

Error while importing an Organization: ExecuteNonQuery requires an open and available Connection

During the import of an Organization we have seen that the following error may occur: ExecuteNonQuery requires an open and available Connection. The connection’s current state is closed. The following error can be seen in the CRM Platform trace: 19:03:33| Error| Import Organization (Name=Test2, Id=fb88688b-46a2-de11-8a64-0013724e5a05) failed with Exception: System.InvalidOperationException: ExecuteNonQuery requires an open and available…

0