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
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.
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.
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
EnableRetrieveMultipleOptimization key changes the SQL query design based on different values set. Any newly created organizations will default to a value of 1.