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)


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

Process information:
Process name: w3wp.exe

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.


mkvFilms said...

Thanks! great site here www.mkvfilms.net

Omega software said...

Keep up the fantastic piece of work, I read few blog posts on this web site and I believe that your site is real interesting and has lots of great information. ERP Software in Mumbai || System Software || CRM Software in Mumbai || MLM Software

Omega software said...

I really appreciate spending some time to talk about that, I believe firmly regarding this and so really enjoy understanding more about this kind of subject.This is also a very good post which I really enjoyed reading. It is not everyday that I have the possibility to see something like this. CRM Software || MLM Software in Mumbai || ERP Software || System Software in Mumbai