Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 general forum

Run a FetchXML Report on a local SSRS server - cannot load MSCRMFETCH extension

Posted on by 20

Hi! 

I need to deploy some SSRS reports that use my CRM Online data (Dynamics 365) to my local Reports Server. Everything works fine on BIDS and also if I deploy them to CRM. But I can't seem to be able to configure the MSCRMFETCH extension properly on my server for them to work locally too. I've read many things online but nothing really pointed in the right direction (other than maybe not being possible due to incompatibility). 

I have added the extension to the server in the same way I have it configured on BIDS:

<Extension Name="MSCRMFETCH" Type="Microsoft.Crm.Reporting.DataExtensionShim.Client.Fetch.FetchExtConnection,Microsoft.Crm.Reporting.DataExtensionShim.Client.Fetch.Clr4" />

I have installed BIDS and the CRM Extension on my SSRS server. But when I try to run a report I just get a message saying:

  • An error has occurred during report processing. (rsProcessingAborted)
    • An attempt has been made to use a data extension 'MSCRMFETCH' that is either not registered for this report server or is not supported in this edition of Reporting Services. (rsDataExtensionNotFound)

On the report server (I'm running SQL 12.0.5000.0 on the server) I can see the error below. I tried with different versions of the DLLs but I'm wondering if this is indeed a lost cause or if this is completely doable. Any ideas?

extensionfactory!ReportServer_0-2!1b7c!04/27/2019-08:54:52:: e ERROR: Exception caught instantiating MSCRMFETCH report server extension: System.BadImageFormatException: Could not load file or assembly 'Microsoft.Crm.Reporting.DataExtensionShim.Client.Fetch.Clr4' or one of its dependencies. This assembly is built by a runtime newer than the currently loaded runtime and cannot be loaded.

File name: 'Microsoft.Crm.Reporting.DataExtensionShim.Client.Fetch.Clr4

Thanks!

Categories:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans