Have you ever got below error message while you trying to upload new report???
Earlier I used to create SSRS report using SQL Server Data Tools 2012 and Visual Studio 2012.But when CRM application was updated to Dynamics 365 its stopped working.
So I installed following components.
- Visual Studio 2015 and Data Tools
- Report Authoring Extensions for Dynamics 365
I updated my reports. But when i tried to upload it to CRM solution every time I was getting same error message. Constantly same error message :(
Error Uploading Report
This report can’t upload. This issue can occur when the Report Definition Language (RDL) file is not valid. If you contact support, please provide the technical details.
So I looked in log file
Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: An error occurred while trying to add the report to Microsoft Dynamics 365. 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">
<ActivityId>bef8f11f-6f63-4f07-b831-96ab39317c1d</ActivityId>
<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 365. Try adding the report again. If this problem persists, contact your system administrator.</Message>
<Timestamp>2017-09-26T11:25:37.1478996Z</Timestamp>
<ExceptionRetriable>false</ExceptionRetriable>
<ExceptionSource i:nil="true" />
<InnerFault i:nil="true" />
<OriginalException i:nil="true" />
<TraceText i:nil="true" />
</OrganizationServiceFault>
But again it was not useful.
So I looked for another workaround as below:
Error Uploading Report
This report can’t upload. This issue can occur when the Report Definition Language (RDL) file is not valid. If you contact support, please provide the technical details.
So I looked in log file
Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: An error occurred while trying to add the report to Microsoft Dynamics 365. 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">
<ActivityId>bef8f11f-6f63-4f07-b831-96ab39317c1d</ActivityId>
<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 365. Try adding the report again. If this problem persists, contact your system administrator.</Message>
<Timestamp>2017-09-26T11:25:37.1478996Z</Timestamp>
<ExceptionRetriable>false</ExceptionRetriable>
<ExceptionSource i:nil="true" />
<InnerFault i:nil="true" />
<OriginalException i:nil="true" />
<TraceText i:nil="true" />
</OrganizationServiceFault>
But again it was not useful.
So I looked for another workaround as below:
- I downloaded a existing report rdl
- And tried to upload it back to CRM
Then :
- I loaded the downloaded rdl into the Visual Studio
- Did some minor changes
- And tried to upload it back into Dynamics
But again I was getting same error message, And I knew there is some version mismatch.
So I googled it and found a solution
- Go to Project property
- Change the Target ServerVersion to "SQL Server 2008 R2,2012 or 2014"
- Build the solution
Again I tried to upload rdl to Dynamics but got same error message.
Then I looked the rdl code and got strange issue. rdl was still targeting to 2016 version of BIDS.
So again I googled and found below solution:
- Change the target server version of your report project (make it 2008, …, 2014)
- Build/Rebuild the project!!
- Do not upload the original rdl file to Dynamics – instead, use the one you’ll find in the “bin/debug” or “bin/release” folder
And now it was successfully uploaded. :) :)
Superb....it really worked in my case
ReplyDelete