locked
Import CRM 4.0 Organization on CRM 2011 Deployment Error RRS feed

  • Question

  • 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

Answers

All replies

  • I too got a similiar warning, however I continued through the install. Were you prevented from moving forward through the upgrade?
    Wednesday, April 13, 2011 9:04 PM
  • Hi Nag,

    I have got the same issue and i have resolved the issue. Please find the URL

    http://social.msdn.microsoft.com/Forums/en-US/crmdeployment/thread/0d43e7fe-571c-41ec-bc1e-e2964469af88

    regards,


    Khaja Mohiddin
    • Marked as answer by crmpnk1 Sunday, April 17, 2011 6:39 AM
    Thursday, April 14, 2011 11:11 AM
  • As i see from the logs the warning message says "The indexes on the Microsoft Dynamics CRM database are not consistent with Microsoft Dynamics CRM indexes". This looks like a known issue happens during version upgrades b'cos of any custom index added to CRM database or full-text indexing is not working properly.

    Microsoft already has KB article for this,

    http://support.microsoft.com/kb/927226

    Hope this will give some insights!


    Cheers, Edwin 

    Follow me on: https://twitter.com/astutecrm

    My Blog: http://astutecrm.wordpress.com/

     

    Thursday, April 14, 2011 11:54 AM
  • Hi mohiddin,

    Thanks for the reply.

    you gave the query in the forum as below.

    Resolution 1 . select ObjectTypeCode, Name, BaseTableName, ExtensionTableName, iscustomisable from EntityView where IsCustomizable = 1 and ( Name is null or BaseTableName is null or ExtensionTableName is null)

    With your query i got the result:

    ObjectTypeCode      Name                     BaseTableName                      ExtensionTableName
    1026                    ProductPriceLevel       ProductPriceLevelBase              NULL
    1022                    PriceLevel                  PriceLevelBase                        NULL

    So what should i do now?

    Thanks,

    Nag.

     

    Thursday, April 14, 2011 5:03 PM
  • Hi Edwin,

    As i read in on the forums, they got the same problem and they said rebuild the indexes. I am going to do this. I hope it will work aftrer doing this.

    BR,

    Nag.

    Thursday, April 14, 2011 5:05 PM
  • Hi Mohiddin,

    I got you after thinking about your query. After that it was upgraded successfully. Tooks 14 hours for importing the organization. Server having 4 GB RAM.

    Thanks,

    Nag.

    Friday, April 15, 2011 11:08 AM
  • Hi nag,

    Most of the time is taken for deleting the asynchronous records. If you delete manually from database it will take max of 2 hours to upgrade the database.

    We run query to delete the asynchronous records. Its the easy way to upgrade the CRM.

    In our database there are 5Lakh asynchronous records, we have deleted it manually and started upgrading. It took one hour to upgrade for us.


    Khaja Mohiddin
    Friday, April 15, 2011 12:06 PM
  • Then you should mark my post as an answer
    Khaja Mohiddin
    Friday, April 15, 2011 12:53 PM
  • Hi Mohiddin,

    Thanks for the reply. i makred. I deleted but still it took time. anyways i have a question. Rest 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:37 AM
  • Hi Nag,

     

    Can you please upload the log file?

    I recommend you to take backup of database, delete from the database.

    Install CRM2011 with Test Organization and redeploy your database. This is the best idea.


    Khaja Mohiddin
    Monday, April 18, 2011 9:27 AM