Stack Overflow Error at Line 165 : Advanced Find and Custom Views

Recently, I received an interesting problem from a customer. My customer told me that whenever he creates a new custom view for an entity and uses the AND/OR group clause, he receives a stack overflow error. For a few horrified minutes, I thought this might have to do with the SQL server but after some mooching around, I managed to find an appropriate Microsoft Knowledgebase Article describing the problem. Further testing confirmed that the error (shown below) was also present in the Advanced Find which is not terribly suprising since considering that the Advanced Find is utilised by the View engine.

Error :

Microsoft Dynamics CRM Error Report Contents

<CrmScriptErrorReport>

  <ReportVersion>1.0</ReportVersion>

  <ScriptErrorDetails>

    <Message>Out of stack space</Message>

    <Line>165</Line>

    <URL>/RuleFinancial&#47;AdvancedFind&#47;AdvFind.aspx</URL>

    <PageURL>/RuleFinancial&#47;AdvancedFind&#47;AdvFind.aspx</PageURL>

    <Function>&#41;</Function>

    <CallStack>

      <Function>&#41;</Function>

      <Function>&#41;</Function>

      <Function>&#41;</Function>

      <Function>&#41;</Function>

      <Function>&#41;</Function>

      <Function>&#41;</Function>

      <Function>&#41;</Function>

      <Function>&#41;</Function>

      <Function>&#41;</Function>

      <Function>&#41;</Function>

      <Function>&#41;</Function>

      <Function>&#41;</Function>

      <Function>&#41;</Function>

      <Function>&#41;</Function>

      <Function>&#41;</Function>

      <Function>&#41;</Function>

      <Function>&#41;</Function>

      <Function>&#41;</Function>

      <Function>&#41;</Function>

      <Function>&#41;</Function>

    </CallStack>

  </ScriptErrorDetails>

  <ClientInformation>

    <BrowserUserAgent>Mozilla&#47;4.0 &#40;compatible&#59; MSIE 7.0&#59; Windows NT 5.2&#59; .NET CLR 1.1.4322&#59; .NET CLR 2.0.50727&#59; .NET CLR 3.0.04506.30&#41;</BrowserUserAgent>

    <BrowserLanguage>en-us</BrowserLanguage>

    <SystemLanguage>en-gb</SystemLanguage>

    <UserLanguage>en-gb</UserLanguage>

    <ScreenResolution>1280x800</ScreenResolution>

    <ClientName>Web</ClientName>

  </ClientInformation>

  <ServerInformation>

    <OrgLanguage>1033</OrgLanguage>

    <OrgCulture>2057</OrgCulture>

    <UserLanguage>1033</UserLanguage>

    <UserCulture>2057</UserCulture>

    <OrgID>&#123;A0476863-44E0-440B-98C5-9041A4B40DE8&#125;</OrgID>

    <UserID>&#123;B742828E-60F7-DD11-BA51-001E0BDBDAD8&#125;</UserID>

    <CRMVersion>4.0.7333.3</CRMVersion>

  </ServerInformation>

</CrmScriptErrorReport>

 I downloaded the HotFix from the KB Article (You receive an error message or you cannot select the lookup value in the Advanced Find page in Microsoft Dynamics CRM 4.0 ) and applied it to the server.

You can also request the Hotfix from HERE if it has been removed from the KB article in favour of Rollup 4

Warning : This file is 256mb!

Result : No Stack Overflow problems any longer. This fix is also included in Update Rollup 4 for those who are interested, but I have never advised applying a whole Rollup when a single Hotfix will do.