• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4596
  • Last Modified:

Reporting Services not creating reports for CRM

Trying to run a report in CRM 4.0 but it fails and says: Reporting Error. The report cannot be displayed.

This error occurs in the reporting server log as well as the application log:


w3wp!library!5!01/29/2008-16:52:25:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: The path of the item '/ORGANISATION_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., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidItemPathException: The path of the item '/ORGANISATION_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.
w3wp!library!1!01/29/2008-16:57:57:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
 Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'SnapshotDataID', table 'ReportServerTempDB.dbo.SessionData'; column does not allow nulls. INSERT fails.

Open in new window

0
partymarty84
Asked:
partymarty84
  • 3
1 Solution
 
partymarty84Author Commented:
Also, there is a warning in the application event log  ID: 1309 Source: ASP.NET 2.0.50727.0

Exception information:
    Exception type: CrmReportingException
    Exception message: An internal error occurred on the report server. See the error log for more details. (rsInternalError)
 
Request information:
    Request URL: http://crm.companyname.com/ORGANISATION/CRMReports/rsviewer/reportviewer.aspx 
    Request path: /ORGANISATION/CRMReports/rsviewer/reportviewer.aspx
    User host address: ***.***.***.***
    User: DOMAIN\user
    Is authenticated: True
    Authentication Type: Negotiate
    Thread account name: NT AUTHORITY\NETWORK SERVICE
0
 
partymarty84Author Commented:
Further error in the application log: Source: MSCRMReporting ID: 19969

Web service request GetDataSources to Report Server http://servername/ReportServer failed with SoapException. Error: An internal error occurred on the report server. See the error log for more details. (rsInternalError)

Also the error below sometimes appears in application log but not on every occurence:

Source: MSCRMReporting ID: 19969

Web service request GetDataSources to Report Server http://servername/ReportServer failed with SoapException. Error: The path of the item '/ORGANISATION_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)
0
 
partymarty84Author Commented:
Removed and reinstalled Reporting Services. Deleted all CRM reports, recreated them using the tool on the CRM CD.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now