Answered by:
CRM Reporting issues

Question
-
My CRM 4 deployment is as follows:
1.) CRM Server 4.0 - Server 2008 x64 ( CRMhost01)
----Service account used for initial install was Network Service, changed after to domain\CrmService (web app account) and all changed made to support 2008.
2.) SQL Server (database) - SQL server 2008 Enterprise (SQLhost01)
3.) Reporting Services Server - 2008 Installed on CRM server
When opening the reports from in CRM using localhost the reports display without any issues, However if i open the reports from in crm using the hostname of the server it displays a reporting error.
The event viewer is giving the following to errors.
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 24/07/2009 10:34:48 AM
Event time (UTC): 24/07/2009 12:34:48 AM
Event ID: a61992b7506643c2a5852c19f8e804aa
Event sequence: 10
Event occurrence: 1
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/ROOT-3-128928681634157084
Trust level: Full
Application Virtual Path: /
Application Path: C:\inetpub\wwwroot\
Machine name: ERISCRM01
Process information:
Process ID: 3672
Process name: w3wp.exe
Account name: ERIS\crmservice
Exception information:
Exception type: CrmReportingException
Exception message: An error has occurred during report processing. (rsProcessingAborted)
Request information:
Request URL: http://eriscrm01/erisdefault/CRMReports/rsviewer/reportviewer.aspx
Request path: /erisdefault/CRMReports/rsviewer/reportviewer.aspx
User host address: fe80::91bc:9637:d916:1b4eC:\inetpub\wwwroot\
User: ERIS\Administrator
Is authenticated: True
Authentication Type: Negotiate
Thread account name: ERIS\crmservice
Thread information:
Thread ID: 3
Thread account name: ERIS\crmservice
Is impersonating: False
Stack trace: at Microsoft.Crm.Web.Reporting.SrsReportViewer.ConfigurePage()
at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e)
at System.Web.UI.Control.PreRenderRecursiveInternal()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
And
Event 19969
MscrmReportingWeb service request SetParameters to Report Server http://eriscrm01/ReportServer failed with SoapException. Error: An error has occurred during report processing. (rsProcessingAborted)
Opening the reports server path http:\\eriscrm01\reportserver i am able to execute any reports. Reporting service was installed on the sql server to start off with however moved to the crm server to attempt to resolve this issue however has not changed anything.
This site is also Public facing over ISA, and i am unable to open the reports there, receive the same error.Friday, July 24, 2009 12:42 AM
Answers
-
Did you install the SRSS Data Connector? I have seen this help even when the Report Server and CRM are on the same server although it is not required.
Best Regards, Donna- Marked as answer by Jim Glass Jr Monday, July 27, 2009 7:56 PM
Monday, July 27, 2009 6:54 PM
All replies
-
Hi Braden,
this looks like a DNS issue. Please check the dns resolution for the server and the domain.
You can also check the entries for the serverin the CRM-Databse.
Use the following SQL-Steatement on the CRM Server. There should be the same value in all three fields like "servername:port"
If not, update the fields with the right servername and port
SELECT Id, ColumnName, NvarCharColumn From DeploymentProperties
WHERE ColumnName IN ('ADSdkRootDomain','ADWebApplicationRootDomain','AsyncSdkRootDomain')
Viele Grüße
Michael Sulz
axcentro GmbH
MVP für Microsoft Dynamics CRMFriday, July 24, 2009 12:20 PM -
Thanks for that michael.
I have managed to resolve the issue of reporting not opening on the local server using the FQDN of the server ( Port incorrect). However this has not resolved the problem, I still receive the error when attempting to open the reports on any other client or server.
Any other ideas??Monday, July 27, 2009 2:57 AM -
Hi Braden,
have you check the dns resolution for the server?
The easiest way to do is to use the tool dnslint from microsoft:
http://support.microsoft.com/kb/321045/de
Viele Grüße
Michael Sulz
axcentro GmbH
MVP für Microsoft Dynamics CRMMonday, July 27, 2009 6:05 AM -
i have Checked DNS and there doesnt appear to be any issues.
The reports server opens without any issues using its DNS name, it seems the problem is just opening them within CRM.Monday, July 27, 2009 6:07 AM -
it looks like a SPN issue to me.
also start the report server configuration wizard and see under which account the services are running.
Tiaan van Niekerk http://crmdelacreme.blogspot.com Skype:tiaan.van.niekerk1Monday, July 27, 2009 4:49 PM -
Did you install the SRSS Data Connector? I have seen this help even when the Report Server and CRM are on the same server although it is not required.
Best Regards, Donna- Marked as answer by Jim Glass Jr Monday, July 27, 2009 7:56 PM
Monday, July 27, 2009 6:54 PM -
Hi braden,
have you got any solution to your issue, i am facing same issue with same server setup.
the error is inconsistent in my case.
SKDThursday, October 22, 2009 12:15 AM