locked
Dynamics CRM Reporting Problem RRS feed

  • Question

  • We had a working Dynamics CRM installation, with one Organization, xxxxx.
    Everything worked, including reporting.
    CRM is on one server, and SQL Server is on another server.

    Next, I created a new Organization ‘yyyyy’, using the deployment manager.
    I disabled the old organization, and then I deleted it.

    Everything is working now, except reporting.

    We are getting the following exception:

    Event Type:       Error
    Event Source:    MSCRMReporting
    Event Category: None
    Event ID:           19969
    Date:                17/09/2010
    Time:                7:28:33 AM
    User:                N/A
    Computer:         zzzzzzzzzzzzzzz
    Description:
    Web service request GetDataSources to Report Server http://wwwwwwwww:87/ReportServer failed with SoapException. Error: The path of the item '/yyyyy’_MSCRM/4.0/' is not valid. The full path must be less than 260 characters long; other restrictions apply. If the report server is in native mode, the path must start with slash. (rsInvalidItemPath)

    We are using SQL Connector for SSRS, with update rollup 7 and then 12 applied.

    Our servers are Windows Server 2003 R2.

     Note we also see this event:

     Event Type:       Error
    Event Source:    MSCRMReporting
    Event Category: None
    Event ID:           19969
    Date:                17/09/2010
    Time:                7:28:27 AM
    User:                N/A
    Computer:         zzzzzzzzzzzzzzz

    Description:

    Web service request GetDataSources to Report Server http://wwwwwwwww:87/ReportServer failed with SoapException. Error: Logon failed. (rsLogonFailed)

    Do you have any suggestions for us?

    Friday, September 17, 2010 11:53 AM

Answers

  • Hi,

    You can trace the exact error which is getting throw.

    For Error Description in Error Log:
    Log on to SQL Server, go to installation folder of SQL Server Reporting Services. Open the latest log file and see the error description.
    EG: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles

    Regarding Deployment:
    Do not use Shared Data Source, When you test it from SSRS, use the Report connectionstring.
    And When you deply the report to MS CRM, MS CRM automatically assign the Data Source to the REPORTS [according to your Organisation].

    Hope this helps.


    Thanks, Ranjitsingh R | http://mscrm-developer.blogspot.com/ | MS CRM Consultant
    • Proposed as answer by Ranjitsingh R Friday, September 17, 2010 12:52 PM
    • Marked as answer by Jim Glass Jr Thursday, October 7, 2010 3:49 PM
    Friday, September 17, 2010 12:52 PM