Answered by:
Importing an organization on CRM 2011.- Error

Question
-
* 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
-
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- Marked as answer by Donna EdwardsMVP Wednesday, November 2, 2011 8:32 PM
Monday, April 18, 2011 10:21 AM
All replies
-
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 AMModerator -
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 -
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- Marked as answer by Donna EdwardsMVP Wednesday, November 2, 2011 8:32 PM
Monday, April 18, 2011 10:21 AM -
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- Proposed as answer by Vaibhav Tiwari Tuesday, May 31, 2011 3:55 PM
Tuesday, May 31, 2011 3:55 PM -
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
-
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