Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. In Microsoft Dynamics CRM 2011 some Personal Views may not be displaying under entity view drop downs as expected

In Microsoft Dynamics CRM 2011 some Personal Views may not be displaying under entity view drop downs as expected

View products that this article applies to.

Symptom

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.

↑ Back to the top

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 which utilizes temp tables to compose security rights.

↑ Back to the top

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

↑ Back to the top

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.
 
EnableRetrieveMultipleOptimization Part 1
 

↑ Back to the top

Keywords: kb

↑ Back to the top

Article Info
Article ID : 2833517
Revision : 1
Created on : 1/7/2017
Published on : 6/7/2013
Exists online : False
Views : 216