Answered by:
Import CRM 4.0 Organization on CRM 2011 Deployment Error

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 databaseThe 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
-
Hi Nag,
I have got the same issue and i have resolved the issue. Please find the URL
regards,
Khaja Mohiddin- Marked as answer by crmpnk1 Sunday, April 17, 2011 6:39 AM
Thursday, April 14, 2011 11:11 AM
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
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 NULLSo 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 MohiddinFriday, April 15, 2011 12:06 PM -
Then you should mark my post as an answer
Khaja MohiddinFriday, 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 MohiddinMonday, April 18, 2011 9:27 AM