ascentium | Problems with GROUP AND and the Advanced Find in CRM 4.0

Today’s post comes from our very own Scott Jung. Enjoy…

After some discussion with Microsoft, there is a known issue that is essentially created in Rollup1, partially fixed in 2 hotfixes (http://support.microsoft.com/kb/954433/) (http://support.microsoft.com/kb/949564/) that are part of Rollup 2, but still occurs when the following conditions are true:

Advanced Find is started
More than one condition is set
One of the Conditions is a Date field
That Date condition is used in a GROUP AND or GROUP OR with another condition
My research is that I can run the query once, but if I “Go Back” to the query and make changes it will fail with a message to send Error to Microsoft, the details are below.

Microsoft Dynamics CRM Error Report Contents

<CrmScriptErrorReport>

<ReportVersion>1.0</ReportVersion>

<ScriptErrorDetails>

<Message>Out of stack space</Message>

<Line>165</Line>

<URL>/_static/_forms/controls/table.dtm.htc</URL>

<PageURL>/Organization/AdvancedFind/AdvFind.aspx?
EntityCode=1&QueryId={00000000-0000-0000-00AA-000010001001}&ViewType=1039</PageURL>

<Function>)</Function>

<CallStack>

<Function>)</Function> ( x 20 lines)

</CallStack>

</ScriptErrorDetails>

<ClientInformation>

<BrowserUserAgent>Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.2; .NET CLR 1.1.4322; .NET CLR 2.0.50727; .NET CLR 3.0.04506.30; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; InfoPath.2)</BrowserUserAgent>

<BrowserLanguage>en-us</BrowserLanguage>

<SystemLanguage>en-us</SystemLanguage>

<UserLanguage>en-us</UserLanguage>

<ScreenResolution>1440x900</ScreenResolution>

<ClientName>Web</ClientName>

</ClientInformation>

<ServerInformation>

<OrgLanguage>1033</OrgLanguage>

<OrgCulture>1033</OrgCulture>

<UserLanguage>1033</UserLanguage>

<UserCulture>1033</UserCulture>

<OrgID>{02E54D05-D16B-4576-AF50-E2F09E184DD9}</OrgID>

<UserID>{EBC69FC2-64B2-DC11-B25E-0003FFB8057D}</UserID>

<CRMVersion>4.0.7333.3</CRMVersion>

</ServerInformation>

</CrmScriptErrorReport>

There is a planned fix for Rollup 3, which by all calculations should come available mid March (according the way that Microsoft intends to release them).

A workaround that has been tested that may help until that time is to SAVE the Query before running it.

Open Advanced Find and create a GROUP AND query with two fields.
Save it as a view and close it.
Then open it and run it.
You should be able to edit this query repeatedly without an error, provided you don’t UNGROUP the objects.

In testing, this query has been run multiple times with minor changes as well as with major changes in the fields or conditions. The ONLY time the error was replicated the problem is if it was UNGROUPed. The Group was changed from AND to OR with some field changes and no problems. When UNGROUP is clicked was when the Stack error showed up.

This posting is provided "AS IS" with no warranties, and confers no rights.