Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Importing an organization on CRM 2011.- Error RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    * Business Goal: Import CRM 4.0 Organization on CRM 2011. (Upgrade CRM 4 to CRM 2011)

    * Repro Steps: During the import got warnings on the deployment manager and final step created a log file. After reading the several forums, I dropped Triggers, Rebuilded  Indexes, Finally dropped one Index "ndx_temp_asyncoperationupgrade" under the table "asyncoperationbase".

    * Expected Results: No Warnings during the import. But in the final step created a log file. And on the deployment manager Organization status shown as "Failed".

    * Actual Results: Please find the Logs

    01:24:55|   Info| Deployment Manager Start
    01:24:57|Verbose| Retrieving config database version Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
    01:24:57|   Info| Config database version: 5.0.9688.583.
    01:25:04|Verbose| Retrieving config database version Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
    01:25:04|   Info| Config database version: 5.0.9688.583.
    01:25:05|Verbose| Retrieving config database version Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
    01:25:05|   Info| Config database version: 5.0.9688.583.
    01:25:05|Verbose| Retrieving config database version Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
    01:25:05|   Info| Config database version: 5.0.9688.583.
    01:25:05|   Info| GetDBUpdateRevisionThresholdForServer(): Threshold = 583.
    01:25:05|Verbose| Getting number of organizations Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
    01:25:05|Verbose| Getting number of Servers Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
    01:25:05|Verbose| Getting number of organizations Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
    01:25:05|Verbose| Getting number of Servers Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
    01:25:05|Verbose| Retrieving config database version Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
    01:25:05|   Info| Config database version: 5.0.9688.583.
    01:25:05|Verbose| Retrieving config database version Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
    01:25:05|   Info| Config database version: 5.0.9688.583.
    01:25:05|   Info| GetDBUpdateRevisionThresholdForServer(): Threshold = 583.
    01:25:05|   Info| GetDBUpdateRevisionThresholdForServer(): Threshold = 583.
    01:25:09|   Info| Import Organization Wizard launched from Organization action pane
    01:25:10|Verbose| Retrieving database version Data Source=CRM2011;Initial Catalog=Gulfnet_Lab_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
    01:25:10|   Info| Database version: 5.0.9688.583.
    01:25:10|Verbose| Retrieving database version Data Source=CRM2011;Initial Catalog=Dasman_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
    01:25:10|   Info| Database version: 5.0.9688.583.
    01:25:10|Verbose| Retrieving database version Data Source=CRM2011;Initial Catalog=CrownePlaza_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
    01:25:10|   Info| Database version: 5.0.9688.583.
    01:25:11|Verbose| Retrieving database version Data Source=CRM2011;Initial Catalog=GN_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
    01:25:11|   Info| Database version: 4.0.7333.2741.
    01:25:11|Verbose| Retrieving database version Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=GN_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
    01:25:11|   Info| Database version: 4.0.7333.2741.
    01:25:11|Verbose| Retrieving database version Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=GN_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
    01:25:11|   Info| Database version: 4.0.7333.2741.
    01:25:15|Verbose| Retrieving database base language code Data Source=CRM2011;Initial Catalog=GN_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
    01:25:15|   Info| Database base language code: 1033.
    01:25:16|Verbose| Retrieving database version Data Source=CRM2011;Initial Catalog=GN_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
    01:25:16|   Info| Database version: 4.0.7333.2741.
    01:25:16|   Info| Retrieved organization ID 316abdc0-9b72-41cd-b8bd-69e0d740334c.

    01:25:25|   Info| Attempting to map user "Nagendra Peruru" with account UN\nagendra.peruru

    01:25:25|   Info| CompleteUserMapping for ManualUserMapper running
    01:25:25|Verbose| Mapping was successful
    01:25:25|   Info| CompleteUserMapping for ManualUserMapper completed
    01:25:38|   Info| EdwModeProperty: DMSnapIn.Organization.Import
    01:25:38|   Info| ImportOperationTypeProperty: ImportOrganization
    01:25:38|   Info| InstallInfo.InstallType: None
    01:25:38|   Info| OrganizationInfo.BaseCurrencyCode: KWD
    01:25:38|   Info| OrganizationInfo.BaseCurrencyName: دينار كويتي
    01:25:38|   Info| OrganizationInfo.BaseCurrencyPrecision: 2
    01:25:38|   Info| OrganizationInfo.BaseCurrencySymbol: د.ك.‏
    01:25:38|   Info| OrganizationInfo.BaseLanguageCode: 1033
    01:25:38|   Info| OrganizationInfo.DatabaseName: GN_MSCRM
    01:25:38|   Info| OrganizationInfo.ExistingDatabaseVersion: 4.0.7333.2741
    01:25:38|   Info| OrganizationInfo.FullTextSearchLocaleId: 1033
    01:25:38|   Info| OrganizationInfo.ImportUserMapper: Microsoft.Crm.Tools.Admin.ManualUserMapper
    01:25:38|   Info| OrganizationInfo.OperationTypeProperty: Import
    01:25:38|   Info| OrganizationInfo.OrganizationCollation: Latin1_General_CI_AI
    01:25:38|   Info| OrganizationInfo.OrganizationFriendlyName: GN
    01:25:38|   Info| OrganizationInfo.OrganizationUniqueName: GN
    01:25:38|   Info| OrganizationInfo.ReportingUrl: http://crm2011/reportserver
    01:25:38|   Info| OrganizationInfo.SkipSelectMappingPage: False
    01:25:38|   Info| OrganizationInfo.SqlServerInstanceName: MSSQLSERVER
    01:25:38|   Info| OrganizationInfo.SqlServerMachineName: CRM2011
    01:25:38|   Info| OrganizationInfo.SqlServerName: CRM2011
    01:25:38|   Info| OrganizationInfo.SqlServerNameObject: Microsoft.Crm.Setup.Server.Utility.SqlServerNames
    01:25:38|   Info| ServerInstallInfo.UpgradeType: FromV4
    01:25:38|   Info| Users: System.Collections.ObjectModel.Collection`1[Microsoft.Crm.UserManagement.User]
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Constructor
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Constructor
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Constructor
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNG.Constructor
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GathererCollection.Constructor()
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GathererCollection.Constructor()
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNG.Constructor
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Constructor
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Constructor
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Constructor
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Clear
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.ClearConfig
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.ClearConfig
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Clear
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.BuildFromConfigData
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildFromConfigData
    01:25:38|Verbose| Found 10 config items
    01:25:38|Verbose| Processing item 0
    01:25:38|Verbose| Processing Sniffer
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
    01:25:38|Verbose| Processing arg RunModes=DMSnapIn.Organization.Create
    01:25:38|Verbose| Found key = RunModes, value = DMSnapIn.Organization.Create
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env var substitutions RunModes
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env var substitutions DMSnapIn.Organization.Create
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env substitutions key = RunModes, value = DMSnapIn.Organization.Create
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
    01:25:38|Verbose| Processing item 1
    01:25:38|Verbose| Processing Sniffer
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
    01:25:38|Verbose| Processing arg RunModes=DMSnapIn.Organization.Import
    01:25:38|Verbose| Found key = RunModes, value = DMSnapIn.Organization.Import
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env var substitutions RunModes
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env var substitutions DMSnapIn.Organization.Import
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env substitutions key = RunModes, value = DMSnapIn.Organization.Import
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
    01:25:38|Verbose| Processing item 2
    01:25:38|Verbose| Processing Sniffer
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
    01:25:38|Verbose| Processing arg RunModes=DMSnapIn.Organization.Update
    01:25:38|Verbose| Found key = RunModes, value = DMSnapIn.Organization.Update
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env var substitutions RunModes
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env var substitutions DMSnapIn.Organization.Update
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env substitutions key = RunModes, value = DMSnapIn.Organization.Update
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
    01:25:38|Verbose| Processing item 3
    01:25:38|Verbose| Processing Sniffer
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
    01:25:38|Verbose| Processing arg RunModes=DMSnapIn.Organization.Upgrade
    01:25:38|Verbose| Found key = RunModes, value = DMSnapIn.Organization.Upgrade
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env var substitutions RunModes
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env var substitutions DMSnapIn.Organization.Upgrade
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env substitutions key = RunModes, value = DMSnapIn.Organization.Upgrade
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
    01:25:38|Verbose| Processing item 4
    01:25:38|Verbose| Processing Sniffer
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
    01:25:38|Verbose| Processing arg RunModes=DMSnapIn.Organization.ApplyDatabaseHotFix
    01:25:38|Verbose| Found key = RunModes, value = DMSnapIn.Organization.ApplyDatabaseHotFix
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env var substitutions RunModes
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env var substitutions DMSnapIn.Organization.ApplyDatabaseHotFix
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env substitutions key = RunModes, value = DMSnapIn.Organization.ApplyDatabaseHotFix
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
    01:25:38|Verbose| Processing item 5
    01:25:38|Verbose| Processing Sniffer
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
    01:25:38|Verbose| Processing arg RunModes=DMSnapIn.Organization.Create
    01:25:38|Verbose| Found key = RunModes, value = DMSnapIn.Organization.Create
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env var substitutions RunModes
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env var substitutions DMSnapIn.Organization.Create
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env substitutions key = RunModes, value = DMSnapIn.Organization.Create
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
    01:25:38|Verbose| Processing item 6
    01:25:38|Verbose| Processing Sniffer
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
    01:25:38|Verbose| Processing arg RunModes=DMSnapIn.Organization.Import
    01:25:38|Verbose| Found key = RunModes, value = DMSnapIn.Organization.Import
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env var substitutions RunModes
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env var substitutions DMSnapIn.Organization.Import
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env substitutions key = RunModes, value = DMSnapIn.Organization.Import
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
    01:25:38|Verbose| Processing item 7
    01:25:38|Verbose| Processing Sniffer
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
    01:25:38|Verbose| Processing arg RunModes=DMSnapIn.Organization.Update;DMSnapIn.Organization.ProvisionSharepoint
    01:25:38|Verbose| Found key = RunModes, value = DMSnapIn.Organization.Update;DMSnapIn.Organization.ProvisionSharepoint
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env var substitutions RunModes
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env var substitutions DMSnapIn.Organization.Update;DMSnapIn.Organization.ProvisionSharepoint
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env substitutions key = RunModes, value = DMSnapIn.Organization.Update;DMSnapIn.Organization.ProvisionSharepoint
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
    01:25:38|Verbose| Processing item 8
    01:25:38|Verbose| Processing Sniffer
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
    01:25:38|Verbose| Processing arg RunModes=DMSnapIn.Organization.Upgrade
    01:25:38|Verbose| Found key = RunModes, value = DMSnapIn.Organization.Upgrade
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env var substitutions RunModes
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env var substitutions DMSnapIn.Organization.Upgrade
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env substitutions key = RunModes, value = DMSnapIn.Organization.Upgrade
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
    01:25:38|Verbose| Processing item 9
    01:25:38|Verbose| Processing Sniffer
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
    01:25:38|Verbose| Processing arg RunModes=DMSnapIn.Organization.Create;DMSnapIn.Organization.Import;DMSnapIn.Organization.Update;DMSnapIn.Organization.Upgrade
    01:25:38|Verbose| Found key = RunModes, value = DMSnapIn.Organization.Create;DMSnapIn.Organization.Import;DMSnapIn.Organization.Update;DMSnapIn.Organization.Upgrade
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env var substitutions RunModes
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env var substitutions DMSnapIn.Organization.Create;DMSnapIn.Organization.Import;DMSnapIn.Organization.Update;DMSnapIn.Organization.Upgrade
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
    01:25:38|Verbose| After env substitutions key = RunModes, value = DMSnapIn.Organization.Create;DMSnapIn.Organization.Import;DMSnapIn.Organization.Update;DMSnapIn.Organization.Upgrade
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildFromConfigData
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.BuildFromConfigData
    01:25:38|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
    01:25:38|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
    01:25:39|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunAll(False)
    01:25:39|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
    01:25:39|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
    01:25:39|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Run(False, (null))
    01:25:39|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
    01:25:39|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
    01:25:39|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
    01:25:39|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
    01:25:39|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GathererCollection.Constructor()
    01:25:39|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GathererCollection.Constructor()
    01:25:39|Verbose| Built gatherer and sniffer collections.
    01:25:39|Verbose| Cleanup completed.
    01:25:39|Verbose| Calling sniffer collect.
    01:25:39|Verbose| Calling sniffer collect.
    01:25:39|Verbose| Calling sniffer collect.
    01:25:39|Verbose| Collection ran.
    01:25:39|Verbose| Collection completed.
    01:25:39|Verbose| Gatherers ran.
    01:25:39|Verbose| Gathering completed.
    01:25:39|Verbose| Calling sniffer process.
    01:25:39|Verbose| Calling sniffer process.
    01:25:39|Verbose| Calling sniffer process.
    01:25:39|Verbose| Processing ran.
    01:25:39|Verbose| Processing completed.
    01:25:39|   Info| Group Microsoft CRM Organization
    01:25:39|   Info| Check OrgUniqueNameValidator: Success
    01:25:39|   Info| Check OrgFriendlyNameValidator: Success
    01:25:39|   Info| Check ImportCurrentUserMappingValidator: Success
    01:25:39|   Info| Check ImportUserMappingValidator: Success
    01:25:39|Verbose| Retrieving information from database Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
    01:25:39|   Info| PrivilegeUserGroup: CN=PrivUserGroup {1db331fc-2f87-4e9b-98e1-b5a72dcd4e6b},OU=CRM,DC=contoso,DC=com
    01:25:39|   Info| SqlAccessGroup: CN=SQLAccessGroup {1db331fc-2f87-4e9b-98e1-b5a72dcd4e6b},OU=CRM,DC=contoso,DC=com
    01:25:39|   Info| ReportingGroup: CN=ReportingGroup {1db331fc-2f87-4e9b-98e1-b5a72dcd4e6b},OU=CRM,DC=contoso,DC=com
    01:25:39|   Info| PrivReportingGroup: CN=PrivReportingGroup {1db331fc-2f87-4e9b-98e1-b5a72dcd4e6b},OU=CRM,DC=contoso,DC=com
    01:25:39|   Info| Check ActiveDirectoryRightsValidator: Success
    01:25:39|   Info| Check OrganizationBaseLanguageValidator: Success
    01:25:39|   Info| Retrieved organization ID 316abdc0-9b72-41cd-b8bd-69e0d740334c.
    01:25:39|Verbose| Checking Organization Id Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
    01:25:39|   Info| Organization Id is unique
    01:25:39|   Info| Check OrganizationIdValidator: Success
    01:25:39|Verbose| Retrieving provisioned languages Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=GN_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
    01:25:39|   Info| Check LanguageProvisioningRequiredValidator: Success
    01:25:39|   Info| Check OrganizationIsInUpgradeableStateValidator: Success
    01:25:39|   Info| Check OrganizationVersionIsUpgradeableValidator: Success
    01:25:39|Verbose| Detected Sql server collation of Latin1_General_CI_AI on database GN_MSCRM.
    01:25:39|Verbose| The supported collation 'Latin1_General_CI_AI' matches the language of the database's collation 'Latin1_General_CI_AI'
    01:25:39|   Info| The case sensitivity of the database collation is correct.
    01:25:39|   Info| The database collation is correct.
    01:25:39|   Info| Check SqlCollationValidator: Success
    01:25:39|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
    01:26:02|   Info| Check SqlColumnValidator: Success
    01:26:02|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=master;Integrated Security=SSPI.
    01:26:02|   Info| Check SqlConnectionValidator: Success
    01:26:02|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
    01:26:04|   Info| Check SqlPrimaryKeyConstraintValidator: Success
    01:26:04|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
    01:26:05|   Info| Check SqlForeignKeyConstraintValidator: Success
    01:26:05|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
    01:26:07|   Info| Check SqlDefaultValueConstraintValidator: Success
    01:26:07|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
    01:26:07|   Info| Check SqlFullTextIndexValidator: Success
    01:26:07|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
    01:26:08|   Info| Check SqlIndexValidator: Success
    01:26:08|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
    01:26:09|   Info| Check SqlTableValidator: Success
    01:26:09|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
    01:26:09|   Info| Check SqlViewValidator: Success
    01:26:09|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
    01:26:09|   Info| Check SqlStoredProcedureValidator: Success
    01:26:09|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
    01:26:09|   Info| Check SqlStatisticValidator: Success
    01:26:09|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
    01:26:09|   Info| Check SqlTriggerValidator: Success
    01:26:09|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
    01:27:01|   Info| Check FragmentedIndexesValidator: Success
    01:27:01|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
    01:27:01|   Info| Check SqlMergeReplicationValidator: Success
    01:27:01|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
    01:27:01|   Info| Check SqlSnapshotAndTransactionReplicationValidator: Success
    01:27:01|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
    01:27:01|   Info| Check SqlPlanGuideValidator: Success
    01:27:01|Verbose| Retrieving provisioned languages Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=GN_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
    01:27:01|   Info| Check LanguageProvisioningRequiredValidator: Success
    01:27:02|   Info| Check WorkflowDotNetAssembliesValidator: Success
    01:27:02|   Info| Check PendingBulkOperationsValidator: Success
    01:27:02|   Info| Group Microsoft SQL Server™
    01:27:02|   Info| Check CrmSqlDomainValidator: Success
    01:27:02|   Info| Check SqlServerAgentValidator: Success
    01:27:02|   Info| Check SqlInstanceNameValidator: Success
    01:27:02|   Info| SQL Server Version: 10.50.1600.1
    01:27:02|   Info| SQL Server Edition: 3
    01:27:02|   Info| Check SqlServerValidator: Success
    01:27:02|   Info| Check SysAdminValidator: Success
    01:27:02|Verbose| Detected Sql server collation of Latin1_General_CI_AI on database GN_MSCRM.
    01:27:02|Verbose| The supported collation 'Latin1_General_CI_AI' matches the language of the database's collation 'Latin1_General_CI_AI'
    01:27:02|   Info| The case sensitivity of the database collation is correct.
    01:27:02|   Info| The database collation is correct.
    01:27:02|   Info| Check SqlCollationValidator: Success
    01:27:02|   Info| Check WordBreakerValidator: Success
    01:27:02|   Info| Check FullTextInstalledValidator: Success
    01:27:02|   Info| Check FullTextRunningValidator: Success
    01:27:02|   Info| Check OrganizationDatabaseExistsValidator: Success
    01:27:02|   Info| Check OrganizationDatabaseNotDeployedValidator: Success
    01:27:02|Verbose| Retrieving database version Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=GN_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
    01:27:02|   Info| Database version: 4.0.7333.2741.
    01:27:02|   Info| Check OrganizationDatabaseVersionValidator: Success
    01:27:02|   Info| Group Microsoft SQL Server Reporting Services
    01:27:02|   Info| Check ReportingUrlValidator: Success
    01:28:06|   Info| Check ExistingRSValidator: Success
    01:28:08|   Info| Check SrsExtensionsValidator: Success
    01:28:08|Verbose| Validation ran.
    01:28:08|Verbose| Validation completed.
    01:28:08|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Run
    01:28:08|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunAll
    01:28:08|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
    01:28:08|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
    01:28:18|   Info| Import Organization Wizard completed
    01:28:18|   Info| Starting organization import
    01:28:18|   Info| Setting IsOnline = False
    01:28:18|Verbose| Retrieving database version Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=GN_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
    01:28:18|   Info| Database version: 4.0.7333.2741.
    01:28:18|   Info| Organization must be upgraded and imported
    01:28:18|   Info| Retrieved organization ID 316abdc0-9b72-41cd-b8bd-69e0d740334c.
    01:28:18|   Info| multipleTenancy for the deployment is True
    01:28:18|   Info| Retrieved organization ID 316abdc0-9b72-41cd-b8bd-69e0d740334c.
    01:28:18|Verbose| Checking Organization Id Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
    01:28:18|   Info| Organization Id is unique
    01:28:18|   Info| UpdateOUGroupsInDatabase started
    01:28:18|   Info| PrivilegedUserGroupName = <GUID=55b1f4b6-0ac6-4e45-8c3d-0882d9cc0666>, SqlAccessGroupName = <GUID=82daf6b1-df38-46ae-9c49-11bac2162a47>, ReportingGroupName = <GUID=a8734e3a-4a83-43a3-90b4-de09d8aa66fa>, PrivilegedReportingGroupName = <GUID=c45c6502-d77f-4b19-99e6-a5727fd5a5cd>
    01:28:18|   Info| Granting access to CRM security groups for the deployment
    01:28:20|   Info| UpdateOUGroupsInDatabase finished
    01:28:20|   Info| Adding users to the config database
    01:28:20|   Info| System Administrator "Nagendra Peruru" with account CONTOSO\crm_admin was added to the configDB successfully
    01:28:20|   Info| Update Organization...
    01:28:20|   Info| Setting organization state.  New state = Pending
    01:28:20|   Info| Installer Start: OrganizationUpgrader.Install: operation Upgrade
    01:28:20|   Info| Executing Install action: Microsoft.Crm.Tools.Admin.UpdateConnectionStringAction
    01:28:20|   Info| CrmAction execution time; UpdateConnectionStringAction; 00:00:00.0156110
    01:28:20|   Info| Executing Install action: Microsoft.Crm.Tools.Admin.BackupRolePrivilegesAction
    01:28:30|   Info| CrmAction execution time; BackupRolePrivilegesAction; 00:00:09.0856020
    01:28:30|   Info| Executing Install action: Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction
    01:28:30|   Info| Clean up extension tables
    01:28:30|   Info| CrmAction execution time; UpgradeDatabaseAction; 00:00:00.8429896
    01:28:30|  Error| Installer Complete: OrganizationUpgrader - Error encountered
    01:28:31|  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.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.
       at System.Data.SqlClient.SqlBuffer.get_String()
       at Microsoft.Crm.DataUpgrade.CleanUpExtensionTables.RetrieveAndCleanUpTables()
       --- 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.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.
       at System.Data.SqlClient.SqlBuffer.get_String()
       at Microsoft.Crm.DataUpgrade.CleanUpExtensionTables.RetrieveAndCleanUpTables()

    01:28:31|   Info| Setting organization state.  New state = Failed
    01:28:31|  Error| Upgrade Organization with Id=316abdc0-9b72-41cd-b8bd-69e0d740334c 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.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.
       at System.Data.SqlClient.SqlBuffer.get_String()
       at Microsoft.Crm.DataUpgrade.CleanUpExtensionTables.RetrieveAndCleanUpTables()
       --- 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)
    01:28:31|  Error| An error occurred when trying import and upgrade organization database CRM2011.GN_MSCRM:
    Microsoft.Crm.CrmException: Upgrade Organization with Id=316abdc0-9b72-41cd-b8bd-69e0d740334c 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.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.
       at System.Data.SqlClient.SqlBuffer.get_String()
       at Microsoft.Crm.DataUpgrade.CleanUpExtensionTables.RetrieveAndCleanUpTables()
       --- 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.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.
       at System.Data.SqlClient.SqlBuffer.get_String()
       at Microsoft.Crm.DataUpgrade.CleanUpExtensionTables.RetrieveAndCleanUpTables()
       --- 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)
    01:28:31|  Error| Import Organization (Name=GN, Id=316abdc0-9b72-41cd-b8bd-69e0d740334c) failed with Exception:
    Microsoft.Crm.CrmException: Upgrade Organization with Id=316abdc0-9b72-41cd-b8bd-69e0d740334c 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.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.
       at System.Data.SqlClient.SqlBuffer.get_String()
       at Microsoft.Crm.DataUpgrade.CleanUpExtensionTables.RetrieveAndCleanUpTables()
       --- 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.SqlTypes.SqlNullValueException: Data is Null. This method or property cannot be called on Null values.
       at System.Data.SqlClient.SqlBuffer.get_String()
       at Microsoft.Crm.DataUpgrade.CleanUpExtensionTables.RetrieveAndCleanUpTables()
       --- 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)
    01:28:31|   Info| GetDBUpdateRevisionThresholdForServer(): Threshold = 583.

    * Environment: Windows Server 2008 Server. SQL 2008 R2. CRM 2011 installed on the same Server. Not installed Email-Router. SQL Reporting Services installed.  CRM 4.0 Organization (Live DB backup) having installed rollups upto rollup 11.

    • Edited by crmpnk1 Thursday, March 31, 2011 6:03 PM Updated according to Jim
    Thursday, March 31, 2011 8:40 AM

Answers

  • Question
    Sign in to vote
    1
    Sign in to vote

    Did you restart the CRM Server after upgrade?

    Once restart the CRM Services or CRM Server including SQL.

    If you got the same error again Please upload the Log file.

    Khaja Mohiddin
    Monday, April 18, 2011 10:21 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote

    The log shows a cleansing problem. You could try running the script from this kb article to clean out your asyncoperationbase table http://support.microsoft.com/kb/968520

    Make sure you run the index creation script from this article first before you run the cleaup script otherwise it will run for ages.

    I clean my asyncoperationbase using this script before all of my crm 4 upgrades.

    MS CRM Bing'd - http://bingsoft.wordpress.com
    Useful Tools  CRM 4 to CRM 2011 JavaScript Converter Tool
    CRM 2011 OData Query Designer
    		CRM Forum Guidance on how to Help Us Help You
    Sunday, April 3, 2011 1:34 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    I upgraded to CRM2011. Eveything i am able to open including custom entities. When i click on the Cases , it's showing the error as below instead of showing the cases on the grid.

    Error: SQL Server Error. A SQL Server error occurred. Try this action again.

    But, If i open from account or contact i am able to see the cases as well as i am able to open the cases. Any idea?

    BR,

    NAG.

    Sunday, April 17, 2011 6:42 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Did you restart the CRM Server after upgrade?

    Once restart the CRM Services or CRM Server including SQL.

    If you got the same error again Please upload the Log file.

    Khaja Mohiddin
    Monday, April 18, 2011 10:21 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Hi nagcrm,

     

    Go into your MSCRM database's Organisation table and change the state of your organisation from 3 to 1, restart your Asycn Service and I guess you will be done.

    Thanks Vaibhav
    Tuesday, May 31, 2011 3:55 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    i am trying to migrate crm 4.0 org into crm 2011 on-premise using deployment manager. I also have taken backup of production crm 4.0 database and restored it into new SQL server. Then importing by using deployment manager. Import failed. Huge log file got craeted and not able to even upload here. Kindly let me know the preparation needed before the import. Considering CRM 4.0 and 2011 database mismatch.
    Friday, December 23, 2011 12:58 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Did you ever get to the bottom of this I have the same fault.

    I have tried the "clean out your asyncoperationbase table" but it has made no difference.

    Friday, October 31, 2014 9:43 AM