web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Update 0.1 Error: No A...
Microsoft Dynamics CRM (Archived)

Update 0.1 Error: No AttributePicklistValue was found in entity

(0) ShareShare
ReportReport
Posted on by KZee

Hi,

I have imported a CRM 2013 (6.1.2.112) organization into CRM 2015 (with update 0.1 installed) successfully but it is showing me version 7.0.0.3027 instead of 7.0.1.129 so i tried updating it from the deployment manager which is failing with the following error. Have anyone seen this error before and is there a solution?

Exception occured during Microsoft.Crm.Tools.Admin.OrganizationDatabaseHotFixer: Error.ActionFailed Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction
InnerException:
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.Crm.CrmException: No AttributePicklistValue was found in entity new_productrequest matching the given condition
at Microsoft.Crm.Platform.MetadataBusinessEntities.ExistingMappingEntityMetadataDefinitionInheritanceMapper.GetComponentFromDefinitionWithCondition(EntityMetadataDefinition entityDefinition, String metadataEntityName, Func`2 conditionFunc)
at Microsoft.Crm.Platform.MetadataBusinessEntities.ExistingMappingEntityMetadataDefinitionInheritanceMapper.CreateAttributePicklistValueMonikerMapping(EntityMetadataDefinition existingEntityDefinition, MetadataMonikerMapDictionary metadataMonikerMap, Guid[] ancestorEntityOptionSetIds, ISqlExecutionContext context)
at Microsoft.Crm.Platform.MetadataBusinessEntities.ExistingMappingEntityMetadataDefinitionInheritanceMapper.CreateInitialMetadataMonikerMapping(Guid ancestorEntityId, EntityMetadataDefinition existingEntityDefinition, ISqlExecutionContext context)
at Microsoft.Crm.Metadata.ActivityEntityService.GetMissingComponentsForCustomActivitiesFromActivityPointer(EntityMetadataDefinition existingCustomActivity, EntityCreateInfo entityInfo, Guid entityId, AttributeFilteringMethod shouldFilterOutAttributeFunc, ExecutionContext context)
at Microsoft.Crm.SE.DllMethodActions.AddMissingCustomActivityAttributes.GetMissingComponents(IEntityDescription entityDescription, Guid baseSolutionId, ExecutionContext context)
at Microsoft.Crm.SE.DllMethodActions.AddMissingCustomActivityAttributes.Execute()
--- End of inner exception stack trace ---
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at Microsoft.Crm.Setup.Database.DllMethodAction.Execute(Guid organizationId)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.ExecuteReleases(ReleaseInfo releaseInfo, Boolean isInstall)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.Install(Int32 languageCode, String configurationFilePath, Boolean upgradeDatabase, Boolean isInstall)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.InstallUpdate(String configurationFilePath, Boolean upgradeDatabase)
at Microsoft.Crm.Setup.Common.Update.DBUpdateDatabaseInstaller.ApplyDBUpdates(Guid orgId)
at Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction.ApplyDBUpdatesInternal(Guid orgId, String orgUniqueName, String releaseFilePath, Boolean ignoreErrors)
at Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction.ApplyDBUpdates(Guid orgId, String orgUniqueName, OrganizationOperationType operationType)
at Microsoft.Crm.Tools.Admin.InstallDatabaseUpdatesAction.Do(IDictionary parameters)
at Microsoft.Crm.Setup.Shared.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
InnerException:
Microsoft.Crm.CrmException: No AttributePicklistValue was found in entity new_productrequest matching the given condition
at Microsoft.Crm.Platform.MetadataBusinessEntities.ExistingMappingEntityMetadataDefinitionInheritanceMapper.GetComponentFromDefinitionWithCondition(EntityMetadataDefinition entityDefinition, String metadataEntityName, Func`2 conditionFunc)
at Microsoft.Crm.Platform.MetadataBusinessEntities.ExistingMappingEntityMetadataDefinitionInheritanceMapper.CreateAttributePicklistValueMonikerMapping(EntityMetadataDefinition existingEntityDefinition, MetadataMonikerMapDictionary metadataMonikerMap, Guid[] ancestorEntityOptionSetIds, ISqlExecutionContext context)
at Microsoft.Crm.Platform.MetadataBusinessEntities.ExistingMappingEntityMetadataDefinitionInheritanceMapper.CreateInitialMetadataMonikerMapping(Guid ancestorEntityId, EntityMetadataDefinition existingEntityDefinition, ISqlExecutionContext context)
at Microsoft.Crm.Metadata.ActivityEntityService.GetMissingComponentsForCustomActivitiesFromActivityPointer(EntityMetadataDefinition existingCustomActivity, EntityCreateInfo entityInfo, Guid entityId, AttributeFilteringMethod shouldFilterOutAttributeFunc, ExecutionContext context)
at Microsoft.Crm.SE.DllMethodActions.AddMissingCustomActivityAttributes.GetMissingComponents(IEntityDescription entityDescription, Guid baseSolutionId, ExecutionContext context)
at Microsoft.Crm.SE.DllMethodActions.AddMissingCustomActivityAttributes.Execute()

*This post is locked for comments

I have the same question (0)
  • mscrmba Profile Picture
    mscrmba on at

    Hi KZee,

    A fairly common issue with Update 0.1.

    Here is what Johnny was provided to correct this issue.  Keep in mind that this solution was built specifically for his environment and may not match exactly to what you are experiencing.  So use with caution.

    community.dynamics.com/.../158085 for a couple of other options also.

    Here are the steps Microsoft provided to Johnny:

    1. Make a backup of the file MetadataDiffs.xml from “C:\Program Files\Microsoft Dynamics CRM\Setup\Serviceability\Latest\Actions_Org\Install”

    2. Open the file MetadataDiffs.xml from “C:\Program Files\Microsoft Dynamics CRM\Setup\Serviceability\Latest\Actions_Org\Install”

    3. Remove the entry about the index “cndx_BusinessDataLocalizedLabel”. This is found at the very end of the file:

      <index Name="cndx_BusinessDataLocalizedLabel">

        <EntityId>4ba1569e-3c9c-4d9f-99ea-b61fb08d7f97</EntityId>

        <IsClustered>1</IsClustered>

        <IsUnique>1</IsUnique>

        <IndexType>6</IndexType>

       <IsPrimaryKey>0</IsPrimaryKey>

        <attributes>

          <attribute AttributeId="d88e1df3-b5b3-42f3-9ffa-007f22951dd4" IsSystemManaged="1" order="0" />

          <attribute AttributeId="bb23d3c8-8d18-40d3-9519-66101a8cae34" IsSystemManaged="1" order="1" />

          <attribute AttributeId="976e1053-5faa-4c3f-be6e-669acfec9d5a" IsSystemManaged="1" order="2" />

          <attribute AttributeId="e81341c4-4d4a-4977-98eb-6597fcde2cc4" IsSystemManaged="1" order="3" />

        </attributes>

      </index>

    4.Close Deployment Manager

    5. Start Deployment Manager

    6. Start the organization update from Deployment manager.

    7. Run the following query on the organization DB to manually recreate the index.

    IF EXISTS (SELECT * FROM sys.indexes WHERE name = 'cndx_BusinessDataLocalizedLabel' AND OBJECT_NAME(object_id) = 'BusinessDataLocalizedLabelBase') DROP INDEX [cndx_BusinessDataLocalizedLabel] ON [BusinessDataLocalizedLabelBase];

    IF NOT EXISTS (SELECT * FROM sys.indexes WHERE NAME = 'cndx_BusinessDataLocalizedLabel' AND OBJECT_NAME(object_id) = 'BusinessDataLocalizedLabelBase')

    BEGIN TRY

    CREATE UNIQUE CLUSTERED INDEX [cndx_BusinessDataLocalizedLabel] ON [BusinessDataLocalizedLabelBase]([ObjectId] ASC, [ObjectIdTypeCode] ASC, [ObjectColumnNumber] ASC, [LanguageId] ASC) WITH (FILLFACTOR = 80, MAXDOP = 4, SORT_IN_TEMPDB = ON, ONLINE = ON)

    END TRY

    BEGIN CATCH

    CREATE UNIQUE CLUSTERED INDEX [cndx_BusinessDataLocalizedLabel] ON [BusinessDataLocalizedLabelBase]([ObjectId] ASC, [ObjectIdTypeCode] ASC, [ObjectColumnNumber] ASC, [LanguageId] ASC) WITH (FILLFACTOR = 80, MAXDOP = 4, SORT_IN_TEMPDB = ON)

    END CATCH

    8. Restore the file MetadataDiffs.xml to its original state using the backup taken at step 1.

  • KZee Profile Picture
    KZee on at

    Thanks mscrmba,.

    The error i am getting is different but i tried this solution anyway and it did not work for me.

    I can see that the following SQL is executed before i get the Picklist error.

    I tried running this SQL manually and it returns at least one record for each OptionSetId passed in as parameter.

    exec sp_executesql N'SELECT [AttributePicklistValueId] AS [attributepicklistvalueid],
    [AttributePicklistValueRowId] AS [attributepicklistvaluerowid],
    [SolutionId] AS [solutionid],
    [OverwriteTime] AS [overwritetime],
    [SupportingSolutionId] AS [supportingsolutionid],
    [OptionSetId] AS [optionsetid],
    [Value] AS [value],
    [State_Status_Value] AS [state_status_value],
    [InvariantName] AS [invariantname],
    [DisplayOrder] AS [displayorder],
    [IsManaged] AS [ismanaged],
    [TransitionData] AS [transitiondata] FROM [AttributePicklistValueView] WHERE OptionSetId IN(@OptionSetIdwhere0
    , @OptionSetIdwhere1
    , @OptionSetIdwhere2
    , @OptionSetIdwhere3
    , @OptionSetIdwhere4
    , @OptionSetIdwhere5
    , @OptionSetIdwhere6
    , @OptionSetIdwhere7)',N'@OptionSetIdwhere0 uniqueidentifier,@OptionSetIdwhere1 uniqueidentifier,@OptionSetIdwhere2 uniqueidentifier,@OptionSetIdwhere3 uniqueidentifier,@OptionSetIdwhere4 uniqueidentifier,@OptionSetIdwhere5 uniqueidentifier,@OptionSetIdwhere6 uniqueidentifier,@OptionSetIdwhere7 uniqueidentifier',@OptionSetIdwhere0='611677D9-BDA0-498D-94FA-35012EAA30EA',@OptionSetIdwhere1='8BBFDF72-9553-4ADD-857C-1115C41959F9',@OptionSetIdwhere2='2D71B8B8-D53A-4871-B6C3-F8FC7E2593E3',@OptionSetIdwhere3='888AD442-8DB4-492F-8E1D-BD7FBF971191',@OptionSetIdwhere4='CCCFABDF-5A8B-4C5F-8F34-9FA2F2CC3990',@OptionSetIdwhere5='16B5C229-38EF-475A-A5DA-197B4E66F5B9',@OptionSetIdwhere6='AEA41AF2-FDA6-4AD6-B2B9-F98D574A6807',@OptionSetIdwhere7='CA870D51-6CEE-4ABC-B1C4-5519A0579554'

  • Lukáš Koutný Profile Picture
    Lukáš Koutný on at

    Hi All,

    We had same issues in our environment. We rised a ticket to Microsoft and they give use hotfix for CRM 2015 Server. The hotfix has number KB3063363. It is specific based on base language. We used hotfix for English and it works.

  • Christie-Kit Profile Picture
    Christie-Kit 5 on at

    Hi Kashif,

    Were you able to resolve this?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Varsha deshpande Profile Picture

Varsha deshpande 5

#2
JS-09031509-0 Profile Picture

JS-09031509-0 3

#3
Ciprian P Profile Picture

Ciprian P 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans