Using CRM 2011 online. Created a fetch-based report in SQL Server 2008 BIDS.
The report searches for all accounts where a date field is between StartDate and EndDate (user-entered date parameters) and displays the total count. I can run the report in the BIDS environment, but it won't run when I upload it to CRM. It thinks for a while, then gives me an error that says:
====================
Webpage error details
User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; Trident/4.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; MDDC; Tablet PC 2.0; .NET4.0C; .NET4.0E)
Timestamp: Tue, 9 Aug 2011 22:46:50 UTC
Message: Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 12031
Line: 5
Char: 84093
Code: 0
URI: https://comcapgroup.crm.dynamics.com/ScriptResource.axd?d=yhDMQfKe7g-DWRW6rmxAx1rNDOXWZYElTrfz2PNmuyTnkzYV2vYAnEfWYRY9GTCOSp0A3b4hO_pQGnMg1bheSR9rhszZ1xR3iuMvemhoDnzMNThmjdHMKva5M_vO76diwgppR8VKjjt0FOk0mYRiqJzHy3DjmO4Qr_8LzA5vbB01&t=2610f696
=========================
Can anyone tell me what IS this error? Is it too large a query since it's searching every account? Is there anything I can do to fix it? I need the user to be able to search for accounts meeting any given date range.
*This post is locked for comments
I have the same question (0)
