28 September 2011

Fetch-based report, Sandbox and TCP 808

Just a reminder, if you deploy a Dynamics CRM 2011 on different servers, you need to allow the inbound TCP port 808 on the Windows Firewall Inbound Rules on the CRM application server, or change it to something meaningful to you.

The reason for that is because, by default the Sandbox service are using the default port 808 to call back CRM server. Furthermore, because the Fetch-based report are running inside a "Sandbox" (that's why you can have fetch-based report on CRM Online, but not SQL based report). So to make sure the Fetch-based report works (all reports created by the CRM report builder are Fetch-based report), you must consider it as well.

Some error message you may see when running a Fetch-based report (if not doing so):

Report render failure. Error: An error has occurred during report processing. (rsProcessingAborted)

and

Event code: 3005
Event message: An unhandled exception has occurred.


Process information:
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:
Exception type: CrmReportingException
Exception message: An error occurred during report rendering.
at Microsoft.Crm.Web.Reporting.SrsReportViewer.SetExecutionCredentials(ServerReport reportObj)
at Microsoft.Crm.Web.Reporting.RemoteSrsReportViewer.LoadReportAndSetParameters()
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)

An error has occurred during report processing. (rsProcessingAborted)
at Microsoft.Reporting.WebForms.ServerReportSoapProxy.OnSoapException(SoapException e)
at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.ProxyMethodInvocation.Execute[TReturn](RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod)
at Microsoft.Reporting.WebForms.ServerReport.SetDataSourceCredentials(IEnumerable`1 credentials)
at Microsoft.Crm.Web.Reporting.SrsReportViewer.SetExecutionCredentials(ServerReport reportObj)


You might also see this error when debugging it:
Could not connect to net.tcp://CRMServer/CrmSandboxSdkListener-w3wp.

1 comment:

mkvFilms said...

Thanks! great site here www.mkvfilms.net