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

LVL 1
partymarty84Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Enterprise Software

From novice to tech pro — start learning today.