web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :

MS CRM 2013: Issues uploading report to CRM Online

a33ik Profile Picture a33ik 84,331 Most Valuable Professional
Today I faced with really weird issue with Report developed for CRM Online. Report worked fine both at BIDS and my test On-Premise instance but once I’ve tried to upload it to productive instance I have got following error:


I’ve downloaded description file but error log didn’t contain any helpful information:

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: 
An error occurred while trying to add the report to Microsoft Dynamics CRM. Try adding the report again. If this problem persists, contact your system administrator.Detail:
<OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
<ErrorCode>-2147188072</ErrorCode>
<ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
<Message>An error occurred while trying to add the report to Microsoft Dynamics CRM. Try adding the report again.
If this problem persists, contact your system administrator.</Message>
<Timestamp>2014-01-19T20:15:50.4036673Z</Timestamp>
<InnerFault i:nil="true" />
<TraceText i:nil="true" />
</OrganizationServiceFault>

After that I’ve opened SDK for CRM and found this article that describes limitations of reports in CRM Online. I went through all used formulas and replaced parts that used Equals and Decimal.Zero.

So my suggestion in case you have problems uploading report to CRM Online:

1. Recheck that your report uses Fetch Xml DataSource.
2. Recheck all formulas that you have in your report and remove (or replace) all denied types and denied members.
3. Ensure that your report doesn’t use references to any assemblies.

This was originally posted here.

Comments

*This post is locked for comments