Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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

  • Christie-Kit Profile Picture
    Christie-Kit 5 on at
    RE: Update 0.1 Error: No AttributePicklistValue was found in entity

    Hi Kashif,

    Were you able to resolve this?

  • Lukáš Koutný Profile Picture
    Lukáš Koutný on at
    RE: Update 0.1 Error: No AttributePicklistValue was found in entity

    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.

  • KZee Profile Picture
    KZee on at
    RE: Update 0.1 Error: No AttributePicklistValue was found in entity

    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'

  • mscrmba Profile Picture
    mscrmba on at
    RE: Update 0.1 Error: No AttributePicklistValue was found in entity

    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.

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

Congratulations 2024 Spotlight Honorees!

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December!

Congratulations to our December super stars! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,622 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,354 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans