Error message when you run a report that uses the "StoredProcedure" command type in the Microsoft Dynamics CRM Connector for SQL Server Reporting Services: "Query execution failed for data set 'Test_MSCRM'"

Article translations Article translations
Article ID: 956852 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

You create a Microsoft SQL Server Reporting Services (SSRS) report that uses a stored procedure. You reference the stored procedure in a dataset in the report by using the "StoredProcedure" command type in the dataset. When you try to run the report in the Microsoft Dynamics CRM Data Connector for SQL Server Reporting Services, you receive an error message that resembles the following:
An error has occurred during report processing.
Query execution failed for data set 'Test_MSCRM'.
Could not find stored procedure ''.

CAUSE

This problem occurs because the Microsoft Dynamics CRM 4.0 logic incorrectly changes the command text of the SqlCommand object that is used to retrieve the data when the SSRS report tries to retrieve the dataset. The underlying Microsoft Dynamics CRM 4.0 logic does not consider that the command type may be "StoredProcedure." Therefore, the command text is changed automatically. However, when the command text is executed, an SqlException exception is raised.

RESOLUTION

This problem is fixed in the latest cumulative update rollup for Microsoft Dynamics CRM 4.0. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
949256 Microsoft Dynamics CRM 4.0 updates and hotfixes

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:
824684 Description of the standard terminology that is used to describe Microsoft software updates
For more information about Microsoft Business Solutions CRM software hotfix and update package terminology, click the following article number to view the article in the Microsoft Knowledge Base:
887283 Microsoft Business Solutions CRM software hotfix and update package naming standards

Properties

Article ID: 956852 - Last Review: January 20, 2012 - Revision: 2.3
APPLIES TO
  • Microsoft Dynamics CRM 4.0
Keywords: 
kbexpertiseinter kbmbsreports kbautohotfix kbfix kbsurveynew kbmbsmigrate kbqfe kbhotfixserver KB956852

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com