Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Import Organization failed...Why does it fail?? Logs available – running out of options. Please help! RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Background

    CRM 2011 Server and SQL server 2008 R2 (running separately from one another)...Installed CRM 2011 with Reporting extensions. When I try to import the CRM 4.0 database it fails. I map all users and validation screen passes without errors or warnings...Why is it failing can someone point me into a right direction looking at the logs.

    SQL server has plenty of memory 16GB and has plenty of storage (hundreds of gigs). It doesn't take long before it fails...|I copied most frequent lines of the log before it failed...

    Your help is much appreciated...

    LOG

    17:38:52|Verbose| Updated 0 rows for null CreatedOn attribute for entity 'solution' with
    17:38:52|Verbose| Correcting null CreatedBy attribute for entity 'template' with ObjectTypeCode=2010.
    17:38:52|Verbose| Updated 0 rows for null CreatedBy attribute for entity 'template' with ObjectTypeCode=2010.
    17:38:52|Verbose| Correcting null CreatedOn attribute for entity 'template' with ObjectTypeCode=2010.
    17:38:52|Verbose| Updated 0 rows for null CreatedOn attribute for entity 'template' with ObjectTypeCode=2010.
    17:38:52|Verbose| Correcting null ModifiedBy attribute for entity 'template' with ObjectTypeCode=2010.
    17:38:52|Verbose| Updated 0 rows for null ModifiedBy attribute for entity 'template' with ObjectTypeCode=2010.
    17:38:52|Verbose| Correcting null ModifiedOn attribute for entity 'template' with ObjectTypeCode=2010.
    17:38:52|Verbose| Updated 0 rows for null ModifiedOn attribute for entity 'template' with ObjectTypeCode=2010.
    17:38:52|Verbose| Correcting incorrect CreatedBy attribute for entity 'template' with ObjectTypeCode=2010.
    17:38:52|Verbose| Updated 0 rows for incorrect CreatedBy attribute for entity 'template' with ObjectTypeCode=2010.
    17:38:52|Verbose| Correcting incorrect ModifiedBy attribute for entity 'template' with ObjectTypeCode=2010.
    17:38:52|Verbose| Updated 0 rows for incorrect ModifiedBy attribute for entity 'template' with ObjectTypeCode=2010.
    17:38:52|Verbose| Correcting null CreatedBy attribute for entity 'territory' with ObjectTypeCode=2013.
    17:38:52|Verbose| Updated 0 rows for null CreatedBy attribute for entity 'territory' with ObjectTypeCode=2013.
    17:38:52|Verbose| Correcting null CreatedOn attribute for entity 'territory' with ObjectTypeCode=2013.
    17:38:52|Verbose| Updated 0 rows for null CreatedOn attribute for entity 'territory' with ObjectTypeCode=2013.
    17:38:52|Verbose| Correcting null ModifiedBy attribute for entity 'territory' with ObjectTypeCode=2013.
    17:38:52|Verbose| Updated 0 rows for null ModifiedBy attribute for entity 'territory' with ObjectTypeCode=2013.
    17:38:52|Verbose| Correcting null ModifiedOn attribute for entity 'territory' with ObjectTypeCode=2013.
    17:38:52|Verbose| Updated 0 rows for null ModifiedOn attribute for entity 'territory' with ObjectTypeCode=2013.
    17:38:52|Verbose| Correcting incorrect CreatedBy attribute for entity 'territory' with ObjectTypeCode=2013.
    17:38:52|Verbose| Updated 0 rows for incorrect CreatedBy attribute for entity 'territory' with ObjectTypeCode=2013.
    17:38:52|Verbose| Correcting incorrect ModifiedBy attribute for entity 'territory' with ObjectTypeCode=2013.
    17:38:52|Verbose| Updated 0 rows for incorrect ModifiedBy attribute for entity 'territory' with ObjectTypeCode=2013.
    17:38:52|Verbose| Correcting null CreatedBy attribute for entity 'timezonedefinition' with ObjectTypeCode=4810.
    17:38:52|Verbose| Updated 102 rows for null CreatedBy attribute for entity 'timezonedefinition' with ObjectTypeCode=4810.
    17:38:52|Verbose| Correcting null CreatedOn attribute for entity 'timezonedefinition' with ObjectTypeCode=4810.
    17:38:52|Verbose| Updated 0 rows for null CreatedOn attribute for entity 'timezonedefinition' with ObjectTypeCode=4810.
    17:38:52|Verbose| Correcting null ModifiedBy attribute for entity 'timezonedefinition' with ObjectTypeCode=4810.
    17:38:52|Verbose| Updated 0 rows for null ModifiedBy attribute for entity 'timezonedefinition' with ObjectTypeCode=4810.
    17:38:52|Verbose| Correcting null ModifiedOn attribute for entity 'timezonedefinition' with ObjectTypeCode=4810.
    17:38:52|Verbose| Updated 0 rows for null ModifiedOn attribute for entity 'timezonedefinition' with ObjectTypeCode=4810.
    17:38:52|Verbose| Correcting incorrect CreatedBy attribute for entity 'timezonedefinition' with ObjectTypeCode=4810.
    17:38:52|Verbose| Updated 0 rows for incorrect CreatedBy attribute for entity 'timezonedefinition' with ObjectTypeCode=4810.
    17:38:52|Verbose| Correcting incorrect ModifiedBy attribute for entity 'timezonedefinition' with ObjectTypeCode=4810.
    17:38:52|Verbose| Updated 0 rows for incorrect ModifiedBy attribute for entity 'timezonedefinition' with ObjectTypeCode=4810.
    17:38:52|Verbose| Correcting null CreatedBy attribute for entity 'timezonelocalizedname' with ObjectTypeCode=4812.
    17:38:52|Verbose| Updated 2651 rows for null CreatedBy attribute for entity 'timezonelocalizedname' with ObjectTypeCode=4812.
    17:38:52|Verbose| Correcting null CreatedOn attribute for entity 'timezonelocalizedname' with ObjectTypeCode=4812.
    17:38:52|Verbose| Updated 0 rows for null CreatedOn attribute for entity 'timezonelocalizedname' with ObjectTypeCode=4812.
    17:38:52|Verbose| Correcting null ModifiedBy attribute for entity 'timezonelocalizedname' with ObjectTypeCode=4812.
    17:38:52|Verbose| Updated 0 rows for null ModifiedBy attribute for entity 'timezonelocalizedname' with ObjectTypeCode=4812.
    17:38:52|Verbose| Correcting null ModifiedOn attribute for entity 'timezonelocalizedname' with ObjectTypeCode=4812.
    17:38:52|Verbose| Updated 0 rows for null ModifiedOn attribute for entity 'timezonelocalizedname' with ObjectTypeCode=4812.
    17:38:52|Verbose| Correcting incorrect CreatedBy attribute for entity 'timezonelocalizedname' with ObjectTypeCode=4812.
    17:38:52|Verbose| Updated 0 rows for incorrect CreatedBy attribute for entity 'timezonelocalizedname' with ObjectTypeCode=4812.
    17:38:52|Verbose| Correcting incorrect ModifiedBy attribute for entity 'timezonelocalizedname' with ObjectTypeCode=4812.
    17:38:52|Verbose| Updated 0 rows for incorrect ModifiedBy attribute for entity 'timezonelocalizedname' with ObjectTypeCode=4812.
    17:38:52|Verbose| Correcting null CreatedBy attribute for entity 'timezonerule' with ObjectTypeCode=4811.
    17:38:52|Verbose| Updated 315 rows for null CreatedBy attribute for entity 'timezonerule' with ObjectTypeCode=4811.
    17:38:52|Verbose| Correcting null CreatedOn attribute for entity 'timezonerule' with ObjectTypeCode=4811.
    17:38:52|Verbose| Updated 0 rows for null CreatedOn attribute for entity 'timezonerule' with ObjectTypeCode=4811.
    17:38:52|Verbose| Correcting null ModifiedBy attribute for entity 'timezonerule' with ObjectTypeCode=4811.
    17:38:52|Verbose| Updated 0 rows for null ModifiedBy attribute for entity 'timezonerule' with ObjectTypeCode=4811.
    17:38:52|Verbose| Correcting null ModifiedOn attribute for entity 'timezonerule' with ObjectTypeCode=4811.
    17:38:52|Verbose| Updated 0 rows for null ModifiedOn attribute for entity 'timezonerule' with ObjectTypeCode=4811.
    17:38:52|Verbose| Correcting incorrect CreatedBy attribute for entity 'timezonerule' with ObjectTypeCode=4811.
    17:38:52|Verbose| Updated 0 rows for incorrect CreatedBy attribute for entity 'timezonerule' with ObjectTypeCode=4811.
    17:38:52|Verbose| Correcting incorrect ModifiedBy attribute for entity 'timezonerule' with ObjectTypeCode=4811.
    17:38:52|Verbose| Updated 0 rows for incorrect ModifiedBy attribute for entity 'timezonerule' with ObjectTypeCode=4811.
    17:38:52|Verbose| Correcting null CreatedBy attribute for entity 'transactioncurrency' with ObjectTypeCode=9105.
    17:38:52|Verbose| Exception in CorrectCreatedByEmptyData method. Message= Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'DeletionStateCode'.
    Invalid column name 'AccountId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'OwningTeam'.
    17:38:52| Info| CrmAction execution time; UpgradeDatabaseAction; 00:26:36.5332154
    17:38:52| Error| Installer Complete: OrganizationUpgrader - Error encountered
    17:38:53| 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. ---> System.Data.SqlClient.SqlException: Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'DeletionStateCode'.
    Invalid column name 'AccountId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'OwningTeam'.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.CorrectCreatedByEmptyData(MetadataBusinessEntity entity)
    at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.UpgradeData()
    at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.UpgradeAuditData()
    --- End of inner exception stack trace ---
    at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
    at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature 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:
    System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'DeletionStateCode'.
    Invalid column name 'AccountId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'OwningTeam'.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.CorrectCreatedByEmptyData(MetadataBusinessEntity entity)
    at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.UpgradeData()
    at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.UpgradeAuditData()
     

    17:38:53| Info| Setting organization state. New state = Failed
    17:38:53| Error| Upgrade Organization with Id=f3a33705-ce34-4aa9-99b3-050c38e531ab 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. ---> System.Data.SqlClient.SqlException: Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'DeletionStateCode'.
    Invalid column name 'AccountId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'OwningTeam'.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.CorrectCreatedByEmptyData(MetadataBusinessEntity entity)
    at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.UpgradeData()
    at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.UpgradeAuditData()
    --- End of inner exception stack trace ---
    at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
    at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature 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)
    17:38:53| Error| An error occurred when trying import and upgrade organization database NONAMESERVER.NoName:
    Microsoft.Crm.CrmException: Upgrade Organization with Id=f3a33705-ce34-4aa9-99b3-050c38e531ab 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. ---> System.Data.SqlClient.SqlException: Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'DeletionStateCode'.
    Invalid column name 'AccountId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'OwningTeam'.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.CorrectCreatedByEmptyData(MetadataBusinessEntity entity)
    at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.UpgradeData()
    at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.UpgradeAuditData()
    --- End of inner exception stack trace ---
    at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
    at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature 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. ---> System.Data.SqlClient.SqlException: Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'DeletionStateCode'.
    Invalid column name 'AccountId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'OwningTeam'.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.CorrectCreatedByEmptyData(MetadataBusinessEntity entity)
    at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.UpgradeData()
    at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.UpgradeAuditData()
    --- End of inner exception stack trace ---
    at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
    at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature 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)
    17:38:53| Error| Import Organization (Name=NoName, Id=f3a33705-ce34-4aa9-99b3-050c38e531ab) failed with Exception:
    Microsoft.Crm.CrmException: Upgrade Organization with Id=f3a33705-ce34-4aa9-99b3-050c38e531ab 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. ---> System.Data.SqlClient.SqlException: Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'DeletionStateCode'.
    Invalid column name 'AccountId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'OwningTeam'.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.CorrectCreatedByEmptyData(MetadataBusinessEntity entity)
    at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.UpgradeData()
    at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.UpgradeAuditData()
    --- End of inner exception stack trace ---
    at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
    at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature 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. ---> System.Data.SqlClient.SqlException: Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'DeletionStateCode'.
    Invalid column name 'AccountId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'ContactId'.
    Invalid column name 'ContactId'.
    Invalid column name 'AccountId'.
    Invalid column name 'OwningTeam'.
    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.CorrectCreatedByEmptyData(MetadataBusinessEntity entity)
    at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.UpgradeData()
    at Microsoft.Crm.DataUpgrade.AuditUpgradeDriver.UpgradeAuditData()
    --- End of inner exception stack trace ---
    at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)
    at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature 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)
    17:38:53| Info| GetDBUpdateRevisionThresholdForServer(): Threshold = 583.

     

     


    • Edited by aditadmins Tuesday, November 15, 2011 12:52 PM content edit
    Tuesday, November 15, 2011 12:35 AM

All replies