In Microsoft Dynamics CRM 2011 some Personal Views may not be displaying under entity view drop downs as expected
This article helps you resolve the problem where some personal views may not be visible in the view drop-down lists as expected.
Applies to: Microsoft Dynamics CRM 2011
Original KB number: 2833517
Symptoms
Some personal views may not be visible in the view drop-down lists as expected. The views create, save, and display the first time they are used as expected but then do not show up in the lists.
Cause
The temp tables being utilized by the Microsoft Dynamics CRM security checks are not composing the lists as expected and some personal views are not showing in expected areas. This is due to a setting called EnableRetrieveMultipleOptimization (ERMO) being set to a value of 1 that utilizes temp tables to compose security rights.
Resolution
Change the EnableRetrieveMultipleOptimization key to a value of 0 or 2 for the CRM organization that this is occurring on. Use the KB below for more information on changing this setting:
OrgDBOrgSettings Tool for Microsoft Dynamics CRM 2011
More information
EnableRetrieveMultipleOptimization key changes the SQL query design based on different values set. Any newly created organizations will default to a value of 1.