Import CRM 4.0 Organization on CRM 2011 Deployment Error

• Question

• 

  

  0

  Sign in to vote

  Dear All,

  I was trying to import the CRM 4.0 Organization on the CRM 2011 deployment manager. It's giving error. I am pasting here. Kindly help.

  On the Deployment Manager Warnings shown as:

  1) The indexes on the Microsoft Dynamics CRM database are not consistent with Microsoft Dynamics CRM indexes.
  2)Fragmented indexes were detected in the Microsoft Dynamics CRM database

  The Log file shows:

  11:09:43|   Info| Deployment Manager Start
  11:09:44|Verbose| Retrieving config database version Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
  11:09:44|   Info| Config database version: 5.0.9688.583.
  11:09:49|Verbose| Retrieving config database version Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
  11:09:49|   Info| Config database version: 5.0.9688.583.
  11:09:50|Verbose| Retrieving config database version Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
  11:09:50|   Info| Config database version: 5.0.9688.583.
  11:09:50|Verbose| Retrieving config database version Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
  11:09:50|   Info| Config database version: 5.0.9688.583.
  11:09:50|   Info| GetDBUpdateRevisionThresholdForServer(): Threshold = 583.
  11:09:50|Verbose| Getting number of organizations Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
  11:09:50|Verbose| Getting number of Servers Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
  11:09:50|Verbose| Getting number of organizations Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
  11:09:50|Verbose| Getting number of Servers Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
  11:09:50|Verbose| Retrieving config database version Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
  11:09:50|   Info| Config database version: 5.0.9688.583.
  11:09:50|Verbose| Retrieving config database version Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
  11:09:50|   Info| Config database version: 5.0.9688.583.
  11:09:50|   Info| GetDBUpdateRevisionThresholdForServer(): Threshold = 583.
  11:09:52|   Info| GetDBUpdateRevisionThresholdForServer(): Threshold = 583.
  11:10:38|Verbose| Getting number of organizations Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
  11:10:38|Verbose| Getting number of Servers Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
  11:10:38|Verbose| Getting number of organizations Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
  11:10:38|Verbose| Getting number of Servers Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
  Security=SSPI ...
  Security=SSPI ...
  11:10:52|   Info| Database version: 4.0.7333.2741.
  11:10:52|Verbose| Retrieving database version Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=GN_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
  11:10:52|   Info| Database version: 4.0.7333.2741.
  11:10:52|Verbose| Retrieving database version Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=GN_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
  11:10:52|   Info| Database version: 4.0.7333.2741.
  11:10:57|Verbose| Retrieving database base language code Data Source=CRM2011;Initial Catalog=GN_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
  11:10:57|   Info| Database base language code: 1033.
  11:10:58|Verbose| Retrieving database version Data Source=CRM2011;Initial Catalog=GN_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
  11:10:58|   Info| Database version: 4.0.7333.2741.
  11:10:58|   Info| Retrieved organization ID 316abdc0-9b72-41cd-b8bd-69e0d740334c.
  11:12:19|   Info| CompleteUserMapping for ManualUserMapper running
  11:12:20|Verbose| Mapping was successful
  11:12:20|   Info| CompleteUserMapping for ManualUserMapper completed
  11:12:40|   Info| EdwModeProperty: DMSnapIn.Organization.Import
  11:12:40|   Info| ImportOperationTypeProperty: ImportOrganization
  11:12:40|   Info| InstallInfo.InstallType: None
  11:12:40|   Info| OrganizationInfo.BaseCurrencyCode: KWD
  11:12:40|   Info| OrganizationInfo.BaseCurrencyName: دينار كويتي
  11:12:40|   Info| OrganizationInfo.BaseCurrencyPrecision: 2
  11:12:40|   Info| OrganizationInfo.BaseCurrencySymbol: د.ك.‏
  11:12:40|   Info| OrganizationInfo.BaseLanguageCode: 1033
  11:12:40|   Info| OrganizationInfo.DatabaseName: GN_MSCRM
  11:12:40|   Info| OrganizationInfo.ExistingDatabaseVersion: 4.0.7333.2741
  11:12:40|   Info| OrganizationInfo.FullTextSearchLocaleId: 1033
  11:12:40|   Info| OrganizationInfo.ImportUserMapper: Microsoft.Crm.Tools.Admin.ManualUserMapper
  11:12:40|   Info| OrganizationInfo.OperationTypeProperty: Import
  11:12:40|   Info| OrganizationInfo.OrganizationCollation: Latin1_General_CI_AI
  11:12:40|   Info| OrganizationInfo.OrganizationFriendlyName: GN
  11:12:40|   Info| OrganizationInfo.OrganizationUniqueName: GN
  11:12:40|   Info| OrganizationInfo.ReportingUrl: http://crm/reportserver
  11:12:40|   Info| OrganizationInfo.SkipSelectMappingPage: False
  11:12:40|   Info| OrganizationInfo.SqlServerInstanceName: MSSQLSERVER
  11:12:40|   Info| OrganizationInfo.SqlServerMachineName: CRM2011
  11:12:40|   Info| OrganizationInfo.SqlServerName: CRM2011
  11:12:40|   Info| OrganizationInfo.SqlServerNameObject: Microsoft.Crm.Setup.Server.Utility.SqlServerNames
  11:12:40|   Info| ServerInstallInfo.UpgradeType: FromV4
  11:12:40|   Info| Users: System.Collections.ObjectModel.Collection`1[Microsoft.Crm.UserManagement.User]
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Constructor
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Constructor
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Constructor
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNG.Constructor
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GathererCollection.Constructor()
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GathererCollection.Constructor()
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNG.Constructor
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Constructor
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Constructor
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Constructor
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Clear
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.ClearConfig
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.ClearConfig
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Clear
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.BuildFromConfigData
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildFromConfigData
  11:12:40|Verbose| Found 10 config items
  11:12:40|Verbose| Processing item 0
  11:12:40|Verbose| Processing Sniffer
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
  11:12:40|Verbose| Processing arg RunModes=DMSnapIn.Organization.Create
  11:12:40|Verbose| Found key = RunModes, value = DMSnapIn.Organization.Create
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env var substitutions RunModes
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env var substitutions DMSnapIn.Organization.Create
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env substitutions key = RunModes, value = DMSnapIn.Organization.Create
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
  11:12:40|Verbose| Processing item 1
  11:12:40|Verbose| Processing Sniffer
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
  11:12:40|Verbose| Processing arg RunModes=DMSnapIn.Organization.Import
  11:12:40|Verbose| Found key = RunModes, value = DMSnapIn.Organization.Import
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env var substitutions RunModes
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env var substitutions DMSnapIn.Organization.Import
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env substitutions key = RunModes, value = DMSnapIn.Organization.Import
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
  11:12:40|Verbose| Processing item 2
  11:12:40|Verbose| Processing Sniffer
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
  11:12:40|Verbose| Processing arg RunModes=DMSnapIn.Organization.Update
  11:12:40|Verbose| Found key = RunModes, value = DMSnapIn.Organization.Update
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env var substitutions RunModes
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env var substitutions DMSnapIn.Organization.Update
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env substitutions key = RunModes, value = DMSnapIn.Organization.Update
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
  11:12:40|Verbose| Processing item 3
  11:12:40|Verbose| Processing Sniffer
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
  11:12:40|Verbose| Processing arg RunModes=DMSnapIn.Organization.Upgrade
  11:12:40|Verbose| Found key = RunModes, value = DMSnapIn.Organization.Upgrade
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env var substitutions RunModes
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env var substitutions DMSnapIn.Organization.Upgrade
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env substitutions key = RunModes, value = DMSnapIn.Organization.Upgrade
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
  11:12:40|Verbose| Processing item 4
  11:12:40|Verbose| Processing Sniffer
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
  11:12:40|Verbose| Processing arg RunModes=DMSnapIn.Organization.ApplyDatabaseHotFix
  11:12:40|Verbose| Found key = RunModes, value = DMSnapIn.Organization.ApplyDatabaseHotFix
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env var substitutions RunModes
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env var substitutions DMSnapIn.Organization.ApplyDatabaseHotFix
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env substitutions key = RunModes, value = DMSnapIn.Organization.ApplyDatabaseHotFix
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
  11:12:40|Verbose| Processing item 5
  11:12:40|Verbose| Processing Sniffer
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
  11:12:40|Verbose| Processing arg RunModes=DMSnapIn.Organization.Create
  11:12:40|Verbose| Found key = RunModes, value = DMSnapIn.Organization.Create
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env var substitutions RunModes
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env var substitutions DMSnapIn.Organization.Create
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env substitutions key = RunModes, value = DMSnapIn.Organization.Create
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
  11:12:40|Verbose| Processing item 6
  11:12:40|Verbose| Processing Sniffer
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
  11:12:40|Verbose| Processing arg RunModes=DMSnapIn.Organization.Import
  11:12:40|Verbose| Found key = RunModes, value = DMSnapIn.Organization.Import
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env var substitutions RunModes
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env var substitutions DMSnapIn.Organization.Import
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env substitutions key = RunModes, value = DMSnapIn.Organization.Import
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
  11:12:40|Verbose| Processing item 7
  11:12:40|Verbose| Processing Sniffer
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
  11:12:40|Verbose| Processing arg RunModes=DMSnapIn.Organization.Update;DMSnapIn.Organization.ProvisionSharepoint
  11:12:40|Verbose| Found key = RunModes, value = DMSnapIn.Organization.Update;DMSnapIn.Organization.ProvisionSharepoint
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env var substitutions RunModes
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env var substitutions DMSnapIn.Organization.Update;DMSnapIn.Organization.ProvisionSharepoint
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env substitutions key = RunModes, value = DMSnapIn.Organization.Update;DMSnapIn.Organization.ProvisionSharepoint
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
  11:12:40|Verbose| Processing item 8
  11:12:40|Verbose| Processing Sniffer
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
  11:12:40|Verbose| Processing arg RunModes=DMSnapIn.Organization.Upgrade
  11:12:40|Verbose| Found key = RunModes, value = DMSnapIn.Organization.Upgrade
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env var substitutions RunModes
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env var substitutions DMSnapIn.Organization.Upgrade
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env substitutions key = RunModes, value = DMSnapIn.Organization.Upgrade
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
  11:12:40|Verbose| Processing item 9
  11:12:40|Verbose| Processing Sniffer
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
  11:12:40|Verbose| Processing arg RunModes=DMSnapIn.Organization.Create;DMSnapIn.Organization.Import;DMSnapIn.Organization.Update;DMSnapIn.Organization.Upgrade
  11:12:40|Verbose| Found key = RunModes, value = DMSnapIn.Organization.Create;DMSnapIn.Organization.Import;DMSnapIn.Organization.Update;DMSnapIn.Organization.Upgrade
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env var substitutions RunModes
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env var substitutions DMSnapIn.Organization.Create;DMSnapIn.Organization.Import;DMSnapIn.Organization.Update;DMSnapIn.Organization.Upgrade
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.ProcessEnvSubstitutions
  11:12:40|Verbose| After env substitutions key = RunModes, value = DMSnapIn.Organization.Create;DMSnapIn.Organization.Import;DMSnapIn.Organization.Update;DMSnapIn.Organization.Upgrade
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildDictionaryFromArgs
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.SNGBuilder.BuildFromConfigData
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.BuildFromConfigData
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunAll(False)
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolResults.Clear
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Run(False, (null))
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.PropagateContext
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GroupCollection.Constructor()
  11:12:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.GathererCollection.Constructor()
  11:12:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.GathererCollection.Constructor()
  11:12:40|Verbose| Built gatherer and sniffer collections.
  11:12:40|Verbose| Cleanup completed.
  11:12:40|Verbose| Calling sniffer collect.
  11:12:40|Verbose| Calling sniffer collect.
  11:12:40|Verbose| Calling sniffer collect.
  11:12:40|Verbose| Collection ran.
  11:12:40|Verbose| Collection completed.
  11:12:40|Verbose| Gatherers ran.
  11:12:40|Verbose| Gathering completed.
  11:12:40|Verbose| Calling sniffer process.
  11:12:40|Verbose| Calling sniffer process.
  11:12:40|Verbose| Calling sniffer process.
  11:12:40|Verbose| Processing ran.
  11:12:40|Verbose| Processing completed.
  11:12:40|   Info| Group Microsoft CRM Organization
  11:12:40|   Info| Check OrgUniqueNameValidator: Success
  11:12:40|   Info| Check OrgFriendlyNameValidator: Success
  11:12:40|   Info| Check ImportCurrentUserMappingValidator: Success
  11:12:40|   Info| Check ImportUserMappingValidator: Success
  11:12:40|Verbose| Retrieving information from database Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
  11:12:40|   Info| PrivilegeUserGroup: CN=PrivUserGroup {1db331fc-2f87-4e9b-98e1-b5a72dcd4e6b},OU=CRM,DC=contoso,DC=com
  11:12:40|   Info| SqlAccessGroup: CN=SQLAccessGroup {1db331fc-2f87-4e9b-98e1-b5a72dcd4e6b},OU=CRM,DC=contoso,DC=com
  11:12:40|   Info| ReportingGroup: CN=ReportingGroup {1db331fc-2f87-4e9b-98e1-b5a72dcd4e6b},OU=CRM,DC=contoso,DC=com
  11:12:40|   Info| PrivReportingGroup: CN=PrivReportingGroup {1db331fc-2f87-4e9b-98e1-b5a72dcd4e6b},OU=CRM,DC=contoso,DC=com
  11:12:41|   Info| Check ActiveDirectoryRightsValidator: Success
  11:12:41|   Info| Check OrganizationBaseLanguageValidator: Success
  11:12:41|   Info| Retrieved organization ID 316abdc0-9b72-41cd-b8bd-69e0d740334c.
  11:12:41|Verbose| Checking Organization Id Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
  11:12:41|   Info| Organization Id is unique
  11:12:41|   Info| Check OrganizationIdValidator: Success
  11:12:41|Verbose| Retrieving provisioned languages Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=GN_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
  11:12:41|   Info| Check LanguageProvisioningRequiredValidator: Success
  11:12:41|   Info| Check OrganizationIsInUpgradeableStateValidator: Success
  11:12:41|   Info| Check OrganizationVersionIsUpgradeableValidator: Success
  11:12:41|Verbose| Detected Sql server collation of Latin1_General_CI_AI on database GN_MSCRM.
  11:12:41|Verbose| The supported collation 'Latin1_General_CI_AI' matches the language of the database's collation 'Latin1_General_CI_AI'
  11:12:41|   Info| The case sensitivity of the database collation is correct.
  11:12:41|   Info| The database collation is correct.
  11:12:41|   Info| Check SqlCollationValidator: Success
  11:12:41|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
  11:13:02|   Info| Check SqlColumnValidator: Success
  11:13:02|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=master;Integrated Security=SSPI.
  11:13:02|   Info| Check SqlConnectionValidator: Success
  11:13:02|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
  11:13:03|   Info| Check SqlPrimaryKeyConstraintValidator: Success
  11:13:03|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
  11:13:05|   Info| Check SqlForeignKeyConstraintValidator: Success
  11:13:05|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
  11:13:07|   Info| Check SqlDefaultValueConstraintValidator: Success
  11:13:07|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
  11:13:07|   Info| Check SqlFullTextIndexValidator: Success
  11:13:07|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
  11:13:08|   Info| The following indexes are not consistent with Microsoft Dynamics CRM indexes:
  11:13:08|   Info| tablename:                              asyncoperationbase
  11:13:08|   Info| indexname:                              ndx_temp_asyncoperationupgrade
  11:13:08|Warning| remark:                                 added index
  11:13:08|Warning| 
  11:13:08|Warning| The indexes on the Microsoft Dynamics CRM database are not consistent with Microsoft Dynamics CRM indexes.
  11:13:08|Warning| The indexes on the Microsoft Dynamics CRM database are not consistent with Microsoft Dynamics CRM indexes.
  11:13:08|Warning| Check SqlIndexValidator : Warning: The indexes on the Microsoft Dynamics CRM database are not consistent with Microsoft Dynamics CRM indexes.
  11:13:08|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
  11:13:09|   Info| Check SqlTableValidator: Success
  11:13:09|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
  11:13:09|   Info| Check SqlViewValidator: Success
  11:13:09|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
  11:13:09|   Info| Check SqlStoredProcedureValidator: Success
  11:13:09|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
  11:13:09|   Info| Check SqlStatisticValidator: Success
  11:13:09|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
  11:13:09|   Info| Check SqlTriggerValidator: Success
  11:13:09|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
  11:18:26|   Info| The following indexes in the Microsoft Dynamics CRM database should be either defragmented or rebuilt:
  11:18:26|   Info| tablename:                              asyncoperationbase
  11:18:26|   Info| indexname:                              cndx_primarykey_asyncoperation
  11:18:26|   Info| fragmentationpercentage:                32.9124376719735
  11:18:26|   Info| pagecount:                              1389022
  11:18:26|Warning| remark:                                 rebuild index
  11:18:26|Warning| 
  11:18:26|Warning| Fragmented indexes were detected in the Microsoft Dynamics CRM database
  11:18:26|Warning| Fragmented indexes were detected in the Microsoft Dynamics CRM database
  11:18:26|Warning| Check FragmentedIndexesValidator : Warning: Fragmented indexes were detected in the Microsoft Dynamics CRM database
  11:18:26|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
  11:18:26|   Info| Check SqlMergeReplicationValidator: Success
  11:18:26|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
  11:18:26|   Info| Check SqlSnapshotAndTransactionReplicationValidator: Success
  11:18:26|Verbose| Connecting to database Data Source=CRM2011;Initial Catalog=GN_MSCRM;Integrated Security=SSPI.
  11:18:26|   Info| Check SqlPlanGuideValidator: Success
  11:18:26|Verbose| Retrieving provisioned languages Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=GN_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
  11:18:26|   Info| Check LanguageProvisioningRequiredValidator: Success
  11:18:27|   Info| Check WorkflowDotNetAssembliesValidator: Success
  11:18:27|   Info| Check PendingBulkOperationsValidator: Success
  11:18:27|   Info| Group Microsoft SQL Server™
  11:18:27|   Info| Check CrmSqlDomainValidator: Success
  11:18:27|   Info| Check SqlServerAgentValidator: Success
  11:18:27|   Info| Check SqlInstanceNameValidator: Success
  11:18:27|   Info| SQL Server Version: 10.50.1600.1
  11:18:27|   Info| SQL Server Edition: 3
  11:18:27|   Info| Check SqlServerValidator: Success
  11:18:27|   Info| Check SysAdminValidator: Success
  11:18:27|Verbose| Detected Sql server collation of Latin1_General_CI_AI on database GN_MSCRM.
  11:18:27|Verbose| The supported collation 'Latin1_General_CI_AI' matches the language of the database's collation 'Latin1_General_CI_AI'
  11:18:27|   Info| The case sensitivity of the database collation is correct.
  11:18:27|   Info| The database collation is correct.
  11:18:27|   Info| Check SqlCollationValidator: Success
  11:18:27|   Info| Check WordBreakerValidator: Success
  11:18:27|   Info| Check FullTextInstalledValidator: Success
  11:18:27|   Info| Check FullTextRunningValidator: Success
  11:18:27|   Info| Check OrganizationDatabaseExistsValidator: Success
  11:18:27|   Info| Check OrganizationDatabaseNotDeployedValidator: Success
  11:18:27|Verbose| Retrieving database version Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=GN_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
  11:18:27|   Info| Database version: 4.0.7333.2741.
  11:18:27|   Info| Check OrganizationDatabaseVersionValidator: Success
  11:18:27|   Info| Group Microsoft SQL Server Reporting Services
  11:18:27|   Info| Check ReportingUrlValidator: Success
  11:18:39|   Info| Check ExistingRSValidator: Success
  11:18:40|   Info| Check SrsExtensionsValidator: Success
  11:18:40|Verbose| Validation ran.
  11:18:40|Verbose| Validation completed.
  11:18:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Run
  11:18:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunAll
  11:18:40|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
  11:18:40|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
  11:19:38|   Info| Import Organization Wizard completed
  11:19:38|   Info| Starting organization import
  11:19:38|   Info| Setting IsOnline = False
  11:19:38|Verbose| Retrieving database version Provider=SQLOLEDB;Data Source=CRM2011;Initial Catalog=GN_MSCRM;Connection Timeout=60;Integrated Security=SSPI ...
  11:19:38|   Info| Database version: 4.0.7333.2741.
  11:19:38|   Info| Organization must be upgraded and imported
  11:19:38|   Info| Retrieved organization ID 316abdc0-9b72-41cd-b8bd-69e0d740334c.
  11:19:38|   Info| multipleTenancy for the deployment is True
  11:19:38|   Info| Retrieved organization ID 316abdc0-9b72-41cd-b8bd-69e0d740334c.
  11:19:38|Verbose| Checking Organization Id Data Source=CRM2011;Initial Catalog=MSCRM_CONFIG;Connection Timeout=60;Integrated Security=SSPI ...
  11:19:38|   Info| Organization Id is unique
  11:19:39|   Info| UpdateOUGroupsInDatabase started
  11:19:39|   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>
  11:19:39|   Info| Granting access to CRM security groups for the deployment
  11:19:40|   Info| UpdateOUGroupsInDatabase finished
  11:19:40|   Info| Adding users to the config database
  11:19:40|   Info| System Administrator "Nagendra Peruru" with account CONTOSO\crm_admin was added to the configDB successfully
  11:19:40|   Info| Update Organization...
  11:19:40|   Info| Setting organization state.  New state = Pending
  11:19:40|   Info| Installer Start: OrganizationUpgrader.Install: operation Upgrade
  11:19:40|   Info| Executing Install action: Microsoft.Crm.Tools.Admin.UpdateConnectionStringAction
  11:19:40|   Info| CrmAction execution time; UpdateConnectionStringAction; 00:00:00.0156264
  11:19:40|   Info| Executing Install action: Microsoft.Crm.Tools.Admin.BackupRolePrivilegesAction
  11:19:59|   Info| CrmAction execution time; BackupRolePrivilegesAction; 00:00:18.0946218
  11:19:59|   Info| Executing Install action: Microsoft.Crm.Tools.Admin.UpgradeDatabaseAction
  11:19:59|   Info| Clean up extension tables
  11:19:59|   Info| CrmAction execution time; UpgradeDatabaseAction; 00:00:00.7343703
  11:19:59|  Error| Installer Complete: OrganizationUpgrader - Error encountered
  11:19:59|  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()

  Kindly Help.

  BR,

  NAG.

  Wednesday, March 30, 2011 6:37 PM