Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Import CRM 4.0 database on CRM 2011 Deployment Errors and Warnings .. RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I was trying to import the CRM 4.0 Organization on the CRM 2011 deployment manager. It's giving error.

    Please help...

    The following are the key warnings during import:-


    i. The primary keys in the Microsoft Dynamics CRM database are not consistent with Microsoft Dynamics CRM primary keys.
    ii. The foreign key constraints in the Microsoft Dynamics CRM database are not consistent with Microsoft Dynamics CRM foreign key constraints.
    iii. The full-text indexes on the Microsoft Dynamics CRM database are not consistent with Microsoft Dynamics CRM full-text indexes.
    iv. The indexes on the Microsoft Dynamics CRM database are not consistent with Microsoft Dynamics CRM indexes.
    v. The stored procedures in the database are not consistent with Microsoft Dynamics CRM stored procedures.
    vi. Fragmented indexes were detected in the Microsoft Dynamics

    Steps / Action taken by us to resolve the above issue:- but result failed
    1. Removing custom triggers and indexes from the organization in database - Result Failed to import
    2. Manually mapping the users in the active directory  - Result Failed to import
    3. I Did that:
    select ObjectTypeCode, Name, BaseTableName, ExtensionTableName, IsCustomizable from EntityView where IsCustomizable = 1 and ( Name is null or BaseTableName is null or ExtensionTableName is null)
    I update it to "0" 
    Again Result Failed To Import



    Thursday, July 7, 2011 6:09 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I think you have tried all the steps which give us problem when upgrading the CRM 4.0 to CRM2011.

    Can you please upload the log file.

     

    Regards,

    Khaja Mohiddin|||||http://www.dynamicsexchange.com/
    Thursday, July 7, 2011 9:29 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    thanks for replying khaja

    Below my error log detials:-

    13:38:57|  Error| Installer Complete: OrganizationUpgrader - Error encountered
    13:38:57|  Error| Exception occured during Microsoft.Crm.Tools.Admin.OrganizationUpgrader: Action Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction failed.
    InnerException:
    System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.Crm.CrmArgumentException: There is already an attribute for entity with id 30b0cd7e-0081-42e1-9a48-688442277fae with columnnumber 91 - column numbers must be unique ---> System.ArgumentException: There is already an attribute for entity with id 30b0cd7e-0081-42e1-9a48-688442277fae with columnnumber 91 - column numbers must be unique
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Platform.MetadataBusinessEntities.AttributeService.ValidateForCreate(MetadataBusinessEntity metadataEntity, ISqlExecutionContext context)
       at Microsoft.Crm.Platform.MetadataBusinessEntities.MetadataProcessObject.Create(MetadataBusinessEntity metadataEntity, ISqlExecutionContext sqlContext)
       at Microsoft.Crm.Metadata.AttributeCreateAction.CreateAttributeMetadataHelper()
       at Microsoft.Crm.Metadata.AttributeCreateAction.MetabaseOperation()
       at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue_MetabaseActions(CounterList listCounters)
       at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue()
       at Microsoft.Crm.Setup.DiffBuilder.Pass1(String metadataLocation, String languageCode)
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
       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()
       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.Tools.Admin.InstallDatabaseAction.Do(IDictionary parameters)
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
    InnerException:
    Microsoft.Crm.CrmArgumentException: There is already an attribute for entity with id 30b0cd7e-0081-42e1-9a48-688442277fae with columnnumber 91 - column numbers must be unique ---> System.ArgumentException: There is already an attribute for entity with id 30b0cd7e-0081-42e1-9a48-688442277fae with columnnumber 91 - column numbers must be unique
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Platform.MetadataBusinessEntities.AttributeService.ValidateForCreate(MetadataBusinessEntity metadataEntity, ISqlExecutionContext context)
       at Microsoft.Crm.Platform.MetadataBusinessEntities.MetadataProcessObject.Create(MetadataBusinessEntity metadataEntity, ISqlExecutionContext sqlContext)
       at Microsoft.Crm.Metadata.AttributeCreateAction.CreateAttributeMetadataHelper()
       at Microsoft.Crm.Metadata.AttributeCreateAction.MetabaseOperation()
       at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue_MetabaseActions(CounterList listCounters)
       at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue()
       at Microsoft.Crm.Setup.DiffBuilder.Pass1(String metadataLocation, String languageCode)
    InnerException:
    System.ArgumentException: There is already an attribute for entity with id 30b0cd7e-0081-42e1-9a48-688442277fae with columnnumber 91 - column numbers must be unique

    13:38:57|   Info| Setting organization state.  New state = Failed
    13:38:57|  Error| Upgrade Organization with Id=8b6573d7-6c9e-e011-b984-0015176ca12d failed with Exception:
    System.Exception: Action Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction failed. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.Crm.CrmArgumentException: There is already an attribute for entity with id 30b0cd7e-0081-42e1-9a48-688442277fae with columnnumber 91 - column numbers must be unique ---> System.ArgumentException: There is already an attribute for entity with id 30b0cd7e-0081-42e1-9a48-688442277fae with columnnumber 91 - column numbers must be unique
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Platform.MetadataBusinessEntities.AttributeService.ValidateForCreate(MetadataBusinessEntity metadataEntity, ISqlExecutionContext context)
       at Microsoft.Crm.Platform.MetadataBusinessEntities.MetadataProcessObject.Create(MetadataBusinessEntity metadataEntity, ISqlExecutionContext sqlContext)
       at Microsoft.Crm.Metadata.AttributeCreateAction.CreateAttributeMetadataHelper()
       at Microsoft.Crm.Metadata.AttributeCreateAction.MetabaseOperation()
       at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue_MetabaseActions(CounterList listCounters)
       at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue()
       at Microsoft.Crm.Setup.DiffBuilder.Pass1(String metadataLocation, String languageCode)
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
       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()
       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.Tools.Admin.InstallDatabaseAction.Do(IDictionary parameters)
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       at Microsoft.Crm.Setup.Common.Installer.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationOperation.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationUpgrader.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationOperation.Execute()
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.ImportAndUpgrade(OrganizationInfo organizationInfo)
    13:38:57|  Error| An error occurred when trying import and upgrade organization database DE-S-0179213.PROSALESDUMMY1:
    Microsoft.Crm.CrmException: Upgrade Organization with Id=8b6573d7-6c9e-e011-b984-0015176ca12d failed with Exception:
    System.Exception: Action Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction failed. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.Crm.CrmArgumentException: There is already an attribute for entity with id 30b0cd7e-0081-42e1-9a48-688442277fae with columnnumber 91 - column numbers must be unique ---> System.ArgumentException: There is already an attribute for entity with id 30b0cd7e-0081-42e1-9a48-688442277fae with columnnumber 91 - column numbers must be unique
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Platform.MetadataBusinessEntities.AttributeService.ValidateForCreate(MetadataBusinessEntity metadataEntity, ISqlExecutionContext context)
       at Microsoft.Crm.Platform.MetadataBusinessEntities.MetadataProcessObject.Create(MetadataBusinessEntity metadataEntity, ISqlExecutionContext sqlContext)
       at Microsoft.Crm.Metadata.AttributeCreateAction.CreateAttributeMetadataHelper()
       at Microsoft.Crm.Metadata.AttributeCreateAction.MetabaseOperation()
       at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue_MetabaseActions(CounterList listCounters)
       at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue()
       at Microsoft.Crm.Setup.DiffBuilder.Pass1(String metadataLocation, String languageCode)
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
       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()
       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.Tools.Admin.InstallDatabaseAction.Do(IDictionary parameters)
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       at Microsoft.Crm.Setup.Common.Installer.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationOperation.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationUpgrader.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationOperation.Execute()
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.ImportAndUpgrade(OrganizationInfo organizationInfo) ---> System.Exception: Action Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction failed. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.Crm.CrmArgumentException: There is already an attribute for entity with id 30b0cd7e-0081-42e1-9a48-688442277fae with columnnumber 91 - column numbers must be unique ---> System.ArgumentException: There is already an attribute for entity with id 30b0cd7e-0081-42e1-9a48-688442277fae with columnnumber 91 - column numbers must be unique
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Platform.MetadataBusinessEntities.AttributeService.ValidateForCreate(MetadataBusinessEntity metadataEntity, ISqlExecutionContext context)
       at Microsoft.Crm.Platform.MetadataBusinessEntities.MetadataProcessObject.Create(MetadataBusinessEntity metadataEntity, ISqlExecutionContext sqlContext)
       at Microsoft.Crm.Metadata.AttributeCreateAction.CreateAttributeMetadataHelper()
       at Microsoft.Crm.Metadata.AttributeCreateAction.MetabaseOperation()
       at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue_MetabaseActions(CounterList listCounters)
       at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue()
       at Microsoft.Crm.Setup.DiffBuilder.Pass1(String metadataLocation, String languageCode)
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
       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()
       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.Tools.Admin.InstallDatabaseAction.Do(IDictionary parameters)
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       at Microsoft.Crm.Setup.Common.Installer.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationOperation.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationUpgrader.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationOperation.Execute()
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.ImportAndUpgrade(OrganizationInfo organizationInfo)
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.ImportAndUpgrade(OrganizationInfo organizationInfo)
    13:38:57|  Error| Import Organization (Name=PROSALESDUMMY, Id=8b6573d7-6c9e-e011-b984-0015176ca12d) failed with Exception:
    Microsoft.Crm.CrmException: Upgrade Organization with Id=8b6573d7-6c9e-e011-b984-0015176ca12d failed with Exception:
    System.Exception: Action Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction failed. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.Crm.CrmArgumentException: There is already an attribute for entity with id 30b0cd7e-0081-42e1-9a48-688442277fae with columnnumber 91 - column numbers must be unique ---> System.ArgumentException: There is already an attribute for entity with id 30b0cd7e-0081-42e1-9a48-688442277fae with columnnumber 91 - column numbers must be unique
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Platform.MetadataBusinessEntities.AttributeService.ValidateForCreate(MetadataBusinessEntity metadataEntity, ISqlExecutionContext context)
       at Microsoft.Crm.Platform.MetadataBusinessEntities.MetadataProcessObject.Create(MetadataBusinessEntity metadataEntity, ISqlExecutionContext sqlContext)
       at Microsoft.Crm.Metadata.AttributeCreateAction.CreateAttributeMetadataHelper()
       at Microsoft.Crm.Metadata.AttributeCreateAction.MetabaseOperation()
       at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue_MetabaseActions(CounterList listCounters)
       at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue()
       at Microsoft.Crm.Setup.DiffBuilder.Pass1(String metadataLocation, String languageCode)
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
       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()
       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.Tools.Admin.InstallDatabaseAction.Do(IDictionary parameters)
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       at Microsoft.Crm.Setup.Common.Installer.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationOperation.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationUpgrader.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationOperation.Execute()
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.ImportAndUpgrade(OrganizationInfo organizationInfo) ---> System.Exception: Action Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction failed. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> Microsoft.Crm.CrmArgumentException: There is already an attribute for entity with id 30b0cd7e-0081-42e1-9a48-688442277fae with columnnumber 91 - column numbers must be unique ---> System.ArgumentException: There is already an attribute for entity with id 30b0cd7e-0081-42e1-9a48-688442277fae with columnnumber 91 - column numbers must be unique
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Platform.MetadataBusinessEntities.AttributeService.ValidateForCreate(MetadataBusinessEntity metadataEntity, ISqlExecutionContext context)
       at Microsoft.Crm.Platform.MetadataBusinessEntities.MetadataProcessObject.Create(MetadataBusinessEntity metadataEntity, ISqlExecutionContext sqlContext)
       at Microsoft.Crm.Metadata.AttributeCreateAction.CreateAttributeMetadataHelper()
       at Microsoft.Crm.Metadata.AttributeCreateAction.MetabaseOperation()
       at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue_MetabaseActions(CounterList listCounters)
       at Microsoft.Crm.Metadata.MetadataHelper.ProcessQueue()
       at Microsoft.Crm.Setup.DiffBuilder.Pass1(String metadataLocation, String languageCode)
       --- End of inner exception stack trace ---
       at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
       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()
       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.Tools.Admin.InstallDatabaseAction.Do(IDictionary parameters)
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Setup.Common.CrmAction.ExecuteAction(CrmAction action, IDictionary parameters, Boolean undo)
       at Microsoft.Crm.Setup.Common.Installer.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationOperation.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationUpgrader.Install(IDictionary stateSaver)
       at Microsoft.Crm.Tools.Admin.OrganizationOperation.Execute()
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.ImportAndUpgrade(OrganizationInfo organizationInfo)
       --- End of inner exception stack trace ---
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.ImportAndUpgrade(OrganizationInfo organizationInfo)
       at Microsoft.Crm.Tools.Admin.ImportOrganizationInstaller.Execute(Object obj)
    13:38:57|   Info| GetDBUpdateRevisionThresholdForServer(): Threshold = 1157.

    Thursday, July 7, 2011 12:05 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Did you ever find a solution for this?  I'm running into a very similar error:

    There is already an attribute for entity with id [guid] with columnnumber 55 - column numbers must be unique

    Tuesday, November 15, 2011 7:28 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Jim,

    How are you performing the upgrade?

    • If in place, please select the option to get updates before setup proceeds
    • If Import Org, please apply latest UR before importing the org

    Also, please provide the exact version of both your CRM 4.0 organization database and the CRM 2011 Server and Config Databases.

    Thanks,

    Matios

     

    Tuesday, November 15, 2011 10:21 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    I'm importing the org to a fresh 2011 install.  CRM 4 is on UR15 - has there been anything in the last 5 that would affect this issue?  What do you mean by the exact version of the DBs?

     

    -Jim
    • Edited by Jim Halligan Tuesday, November 15, 2011 10:26 PM
    Tuesday, November 15, 2011 10:26 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    You can find out which entity and attribute is causing the problem with the following SQL query in the MSCRM database:

    select a.name as AttributeName, e.name as EntityName
from attribute a
join entity e on a.entityid = e.entityid
where 
e.entityid  = '<Guid>' and 
a.columnnumber = <columnnumber>


    Where <Guid> and <columnnumber> are the values from the log file

    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
    Wednesday, November 16, 2011 5:05 PM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    Yeah, I already grabbed that info - it's a custom attribute on the activitypointer entity.  Seems that the upgrade is trying to add an attribute of the same value, but I'm not sure what to do about it.
    -Jim
    Wednesday, November 16, 2011 5:09 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    To update, my issue was the result of some unsupported customizations on the activitypointer entity.  I had to export the activitypointer customizations, edit the xml to remove all references to 4 fields that were added, re-import and publish them, drop the columns from the activitypointerbase table, remove them from the activitypointer view, drop the columns from the metadataschema.attributes table, bring the database over to the upgrade environment, and re-run the org import.

     

    I'll definitely be implementing that in a more supported way when we get everything working correctly in 2011.

    -Jim
    Tuesday, November 22, 2011 1:24 AM