MS CRM 3.0 Report Error

• 06-23-2008 3:07 AM

  Mayank Pujara Joined on 06-12-2008 Posts 10

  MS CRM 3.0 Report Error Reply Contact We are using MS CRM 3.0... We had to add one custom report (made in VS 2003 Business intelligence project). We have added via Reports --> New --> then Selected contract.Rdl (it was contract report) --> selected other relevant fields --> pressed Save and Closed. Now reports works fine on this server...when we asked other user to check this reports from their system.. Surprisingly all the reports for other users stopped working...Whenever user clicks on report tab --we get MS error dialog saying -- "An error has occurred. for more information, contact your system administrator. Try Again or Cancel" Can anybody help what's going on in CRM 3.0 over here?If anybody has got any solution...Please reply me at Mayank.pujara@iris.co.uk. any help will be much appreciated. Thanks Mayank

• 06-23-2008 11:30 AM

  In reply to

  craigde Joined on 03-07-2007 Posts 94	Re: MS CRM 3.0 Report Error Reply Contact Have you checked Technet? There are a number of examples of this error message with reports. http://search.technet.microsoft.com/Default.aspx?locale=en-us&Query=%22An%20error%20has%20occurred.%20for%20more%20information%2c%20contact%20your%20system%20administrator.%22%20CRM%20report&lang=00&Brand=technet
  	Tags: Error, CRM

• 06-25-2008 7:14 AM

  In reply to

  Mayank Pujara Joined on 06-12-2008 Posts 10

  Re: MS CRM 3.0 Report Error Reply Contact checked there but not founding anything to our needs !!! we have enabled development error in CRM. and now if user clicks it displays following error message   The request failed with HTTP status 401: Unauthorized. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Net.WebException: The request failed with HTTP status 401: Unauthorized.   Source Error: The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL: 1. Add a "Debug=true" directive at the top of the file that generated the error. Example:   <%@ Page Language="C#" Debug="true" %> or: 2) Add the following section to the configuration file of your application: <configuration>    <system.web>        <compilation debug="true"/>    </system.web> </configuration> Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode. Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario. Stack Trace:   [WebException: The request failed with HTTP status 401: Unauthorized.]    System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +1296    System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +218    Microsoft.Crm.ReportingServices.ReportingService.ListChildren(String Item, Boolean Recursive) +80    Microsoft.Crm.Application.Controls.ReportsGridDataProvider.GetReports(Int32& numReports) +738    Microsoft.Crm.Application.Controls.ReportsGridDataProvider.Execute() +29    Microsoft.Crm.Application.Controls.AppGridUIProvider.Render(HtmlTextWriter output) +229    Microsoft.Crm.Application.Controls.ReportsGridUIProvider.Render(HtmlTextWriter output) +8    Microsoft.Crm.Application.Components.UI.DataGrid.RenderData(HtmlTextWriter output) +531    Microsoft.Crm.Application.Components.UI.DataGrid.RenderInnerHtml(HtmlTextWriter output) +471    Microsoft.Crm.Application.Components.UI.DataGrid.Render(HtmlTextWriter output) +125    Microsoft.Crm.Application.Controls.AppGrid.Render(HtmlTextWriter writer) +128    System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243    _ASP.home_reports_aspx.__Render__control1(HtmlTextWriter __output, Control parameterContainer) +420    System.Web.UI.Control.RenderChildren(HtmlTextWriter writer) +27    System.Web.UI.Control.Render(HtmlTextWriter writer) +7    System.Web.UI.Control.RenderControl(HtmlTextWriter writer) +243    System.Web.UI.Page.ProcessRequestMain() +1926   can anybody help to resolve this issue?

• 06-30-2008 4:07 AM

  In reply to

  Mayank Pujara Joined on 06-12-2008 Posts 10

  Re: MS CRM 3.0 Report Error Reply Contact Today Microsoft Customer Support & Services has solved our issue with the customer. Short summary is given below. Error: When we try to connect to the Reports Module in Microsoft Dynamics from a desktop (browser) but we receive a Server Error in '/' Application. The request failed with HTTP status 401: Unauthorized. We also get the same error when we try to connect to Settings\Organization Settings\System Settings. When we're loggin into the server (by Remote Desktop) we don't get any errors. Note that there are 2 ip-addresses configured and DNS is resolving an other ip-address than the server is opening Microsoft Dynamics. Solution: Reports in Microsoft Dynamics CRM 3.0 require Kerberos authentication if Microsoft Dynamics CRM and SQL Server Reporting Services (SSRS) are installed on different computers. This requirement means that you cannot use NTLM negotiation. Add the NTLMForSQLRSServer reg key on the server side. On the Microsoft Dynamics CRM Server, click Start, click Run, type regedit , and then click OK. Open the following registry key: HKLM\Software\Microsoft\MSCRM Right-click MSCRM, point to New, and then click DWORD value. Type NTLMForSQLRSServer . Double-click NTLMForSQLRSServer , type 1 , and then click OK. This is working for me now !!!!!!!!!