web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / MS CRM 3.0 Report Error
Microsoft Dynamics CRM (Archived)

MS CRM 3.0 Report Error

(0) ShareShare
ReportReport
Posted on by Mayank Pujara 830
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

 

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    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

  • Mayank Pujara Profile Picture
    Mayank Pujara 830 on at

    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?

  • Mayank Pujara Profile Picture
    Mayank Pujara 830 on at

    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.

    1. On the Microsoft Dynamics CRM Server, click Start, click Run, type regedit , and then click OK.
    2. Open the following registry key: HKLM\Software\Microsoft\MSCRM
    3. Right-click MSCRM, point to New, and then click DWORD value.
    4. Type NTLMForSQLRSServer .
    5. Double-click NTLMForSQLRSServer , type 1 , and then click OK.

    This is working for me now !!!!!!!!!

  • Sohaib Qazi Profile Picture
    Sohaib Qazi 20 on at
    Hi Well i also faced the same problem some days ago And after spending some time on this issue I have find the solution Just to Start "Computer Browser" service from "services.msc" Thanks Regards Sohaib Qazi
  • Hemant Basaiwala Profile Picture
    Hemant Basaiwala 5 on at

    I too have same issue and that is only location specific. User at particular location is not able to access report from that location and once he tries from othe location he can.

    I have implemented both of above proposed solutions.

    Please suggest on this

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans