Error occurred whiLe getting the data source contents for the report.

Monday, September 5, 2011

dynamics crm dynamics crm 2011

Hi,

I came up this issue when trying to run any report within my Dynamics CRM 2011 implementation:

Eventlog:

Web service request GetDataSourceContents to Report Server http://crm-vm/reportserver/ReportService2005.asmx failed with SoapException. Error: The item '/SharedReports/5.0.xxxx/MSCRM_FetchDataSource' cannot be found.

This was a deployment where Reporting Extensions were installed much more later than CRM installation and Reporting Services where reinstalled so do Reporting Extensions afterwards but reports happened to not work.

So, I am gonna share here how I sorted this out in case somebody else faces something similar:

Logged in the CRM Server with the administrator account that Dynamics CRM was previously installed with.

First off, I disabled UAC for the account. [Control Panel –> User Accounts –> Change User Account Control Settings].

Restarted server (yes, it’s needed )

After restarting, entered Report Manager (http://myserver/reports) and explicitly added setup account with all roles in Report Manager

Within Report Manager, I added the account as System administrator in Reporting Services [Site Settings –> Security]

Finally, using command prompt, I run publishreports.exe using the name of my organization (I had only one org on that deployment).

This command is located at \Program Files\Microsoft CRM folder\Tools folder and is used to synchronize the reports between CRM and SSRS.

So, the syntax was:

publishreports MyOrgName

After the above steps my reports started to work properly Smile .

Hope it saves somebody else’s time.

PP [twitter: @pabloperalta]

You should rewrite your instructions as follows:

1) Disable security to a point that makes your server no longer suitable for production deployment.

2) Run "publishreports MyOrgName" to publish the reports.

I skipped step 1 and just ran step 2. That fixed the problem for me. There is no need to disable UAC or add elevated permissions to your reporting server accounts.

Thanks for step 2.

Don

Don Pezet - Monday, December 5, 2011 3:53:43 PM

Thanks, it is working now

Hinh - Thursday, December 8, 2011 10:43:12 AM

thank u its working

lokesharora - Wednesday, December 21, 2011 5:22:08 AM

thank you for sharing

Sani - Sunday, February 19, 2012 8:51:05 PM

Thank you very much!
But i manually create MSCRM_FetchDataSource, in folder with reports (/orgname_MSCRM/CustomReports for me), and it works too)

Irakli - Tuesday, March 27, 2012 11:22:11 AM

5 Comments