Monthly Archives: February 2014

CRM 2011 report wizard bug

Error:

Reports generated by the CRM Report Wizard fails to run after being modified a couple of times.

The SQL Server Reporting Services log reads:

An exception has occurred in data set ‘DSMain’.

Cannot read the next data row for the dataset DSMain.

Number of link entities in query exceeded maximum limit.

Cause:

Duplicate link-entity lines have been inserted in the query of the RDL file by the Wizard.

Solution:

This is a bug in Microsoft Dynamics CRM 2011 Rollup 16. MS Support is on the case, hoping for a hot-fix soon. -UPDATE- This issue will be fixed in Rollup 17 due to be released by late April. – UPDATE-

Workaround:

You can temporarily extend the number of link entities in query exceeded maximum limit by using this unsupported method:

INSERT INTO DeploymentProperties(Id,ColumnName,IntColumn,Encrypted)
VALUES(’98C49E91-545E-E211-85CE-000C29DF81DE’,’QueryLinkEntityLimit’,20,0)

select * from DeploymentProperties where ColumnName=’QueryLinkEntityLimit’

Thanks to: http://www.comunidadcrm.com/2012/09/28/fetchxml-error-crm-2011-number-of-link-entities-in-query-exceeded-maximum-limit/

Advertisements