web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Error while changing SQL Server\Instance for CRM organization

(0) ShareShare
ReportReport
Posted on by 2,930

Hi,

I have disabled org for which I want to change SQL Server instance, then I went to edit organization wizard. I putted up the new Server report services URL, and mentioned new SQL Server in the wizard. System check wizard passed successfully. But in the progress of update organization it gives an error keeping the wizard unsuccessful. Below is the error log:

18:17:03| Info| Check SysAdminValidator: Success
18:17:03| Info| Check SqlCollationValidator: Success
18:17:03| Info| Check WordBreakerValidator: Success
18:17:03| Info| Check FullTextInstalledValidator: Success
18:17:03| Info| Check FullTextRunningValidator: Success
18:17:03| Info| Check OrganizationDatabaseExistsValidator: Success
18:17:03| Info| Group Microsoft SQL Server Reporting Services
18:17:03| Info| Check ReportingUrlValidator: Success
18:17:04| Info| Check ExistingRSValidator: Success
18:17:04| Info| Check SrsExtensionsValidator: Success
18:17:04|Verbose| Validation ran.
18:17:04|Verbose| Validation completed.
18:17:04|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.Run
18:17:04|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWTool.RunAll
18:17:04|Verbose| Method entry: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
18:17:04|Verbose| Method exit: Microsoft.Crm.Tools.EDW.Framework.EDWToolCallbacks.Clear
18:17:15| Info| Updating Organization with Id=(06339f03-eb07-4b4e-9ac6-4d2f869b6dbb)
18:17:15| Info| Update Organization and Users in ConfigDB...
18:17:24| Error| Update Organization with Id=06339f03-eb07-4b4e-9ac6-4d2f869b6dbb failed with Exception:
System.NullReferenceException: Object reference not set to an instance of an object.
at Microsoft.Crm.Metadata.OrganizationBaseLanguageLoader.GetBaseLanguage(Guid key, SqlExecutionContext context)
at Microsoft.Crm.Metadata.OrganizationBaseLanguageLoader.LoadCacheData(Guid key, IOrganizationContext context)
at Microsoft.Crm.Caching.BasicCrmCache`2.LookupEntry(TKey key, IOrganizationContext context)
at Microsoft.Crm.Metadata.LabelCacheLabelCollection.HasLabels(IOrganizationContext context)
at Microsoft.Crm.Metadata.PreloadedOptionSetMetadataDataProvider.CreateEntityNameReferenceOptions(SortedList`2& optionsSorted, IOrganizationContext organizationContext)
at Microsoft.Crm.Metadata.PreloadedOptionSetMetadataDataProvider.LoadEntityNameReferenceOptionsIfNecessary(IOrganizationContext context, LoadMasks masks)
at Microsoft.Crm.Metadata.PreloadedOptionSetMetadataDataProvider.InitializeOptions(IPreloadedMetadataInitializationContext context, LoadMasks masks, IOrganizationContext organizationContext)
at Microsoft.Crm.Metadata.PreloadedMetadataCacheDataProvider.InitializeOptionSets(IPreloadedMetadataInitializationContext context, LoadMasks masks, IOrganizationContext organizationContext)
at Microsoft.Crm.Metadata.PreloadedMetadataCacheDataProvider.Initialize(IOrganizationContext organizationContext, MetadataContainer container, LoadMasks masks)
at Microsoft.Crm.Metadata.MultiOrgSharableMetadataCacheLoader.CreateMetadataCacheDataProvider(MetadataContainer container, IOrganizationContext context, LoadMasks masks, CounterList counter)
at Microsoft.Crm.Metadata.DynamicMetadataCacheLoader.BuildMetadataCacheFromMetadataContainer(MetadataContainer container, LoadMasks masks, IOrganizationContext context, CounterList counter)
at Microsoft.Crm.Metadata.DynamicMetadataCacheLoader.LoadCacheFromDatabaseInternal(LoadMasks masks, CrmDbConnection connection, CrmTransaction transaction, IOrganizationContext context, CounterList counter)
at Microsoft.Crm.Metadata.DynamicMetadataCacheLoader.LoadCacheFromDatabase(LoadMasks masks, IOrganizationContext context, CounterList counter)
at Microsoft.Crm.Metadata.DynamicMetadataCacheFactory.LoadMetadataCache(LoadMethod method, CacheType type, IOrganizationContext context)
at Microsoft.Crm.Metadata.MetadataCache.LoadCache(IOrganizationContext context, Boolean fileOnlyIfExists)
at Microsoft.Crm.Metadata.MetadataCache.GetInstance(IOrganizationContext context)
at Microsoft.Crm.Query.EntityExpression.Init(String entityPlatformName)
at Microsoft.Crm.Tools.Admin.UpdateOrganizationInstaller.GetAllUsersFromOrgDB(Guid organizationId)
at Microsoft.Crm.Tools.Admin.UpdateOrganizationInstaller.UpdateUsersInConfigDB(Guid organizationId)
at Microsoft.Crm.Tools.Admin.UpdateOrganizationInstaller.UpdateOrganizationAndUsersInConfigDB(Guid organizationId, OrganizationData organizationData, String friendlyName, String sqlServerName, Uri reportingUrl)
at Microsoft.Crm.Tools.Admin.UpdateOrganizationInstaller.Update(Guid organizationId, String friendlyName, String sqlServerName, Uri reportingUrl)
18:17:24| Info| GetDBUpdateRevisionThresholdForServer(): Threshold = 2730.

Please guide on this.

*This post is locked for comments

I have the same question (0)
  • AaronRic Profile Picture
    10,035 on at

    Were you able to get past this?

  • Pradeep Pawar Profile Picture
    2,930 on at

    No, I did reinstallation later.

    Please let me know if you have any workaround for that case.

    Thanks,

    Pradeep P

  • AaronRic Profile Picture
    10,035 on at

    Thanks Pradeep. I would be hard without additional logging. The reinstall got you beyond this though I am assuming?

  • Pradeep Pawar Profile Picture
    2,930 on at

    Yes, In the steps of reinstalling CRM I pointed the another SQL Instance and it took place without any difficulties.

    Thanks,

    Pradeep P

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Varsha deshpande Profile Picture

Varsha deshpande 5

#2
JS-09031509-0 Profile Picture

JS-09031509-0 3

#3
Ciprian  P Profile Picture

Ciprian P 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans