Error Launching Import Organization Wizard

(0) Share

Report

Posted on by Chris.P

I am unable to get the import organization wizard to function. Whenever I try to launch the wizard, MMC immediately crashes. I was able to pull the below error out of the "crmdmsnapin" log. I have tried reinstalling CRM 3 separate times, but still the same result.

Things I have verified:

Service account permissions of Deployment web service to CRM server including registry/NFTS directories, local admin, sysadmin, etc.
TCP 1433, 443 is open from CRM server to SQL/SSRS server (CRM wouldn't have installed otherwise)
All required SQL services are started (SQL, SSRS, Agent, Full-Text)
Database versions of target organizational databases match the mscrm_config database and default organization database
AD connectivity

Error during the retrieve of CRM organization databases from the SQL Server (xxxx) System.InvalidOperationException: Invalid attempt to read when no data is present.

at System.Data.SqlClient.SqlDataReader.CheckDataIsReady(Int32 columnIndex, Boolean allowPartiallyReadColumn, Boolean permitAsync, String methodName)
at System.Data.SqlClient.SqlDataReader.TryReadColumn(Int32 i, Boolean setTimeout, Boolean allowPartiallyReadColumn)
at System.Data.SqlClient.SqlDataReader.ReadColumn(Int32 i, Boolean setTimeout, Boolean allowPartiallyReadColumn)
at System.Data.SqlClient.SqlDataReader.GetInt32(Int32 i)
at Microsoft.Crm.Setup.Database.CrmVersion.Initialize(CrmDbConnection connection)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.ValidateUpgrade(CrmDbConnection connection, ReleaseInfo releaseInfo, Boolean throwIfNotUpgradeable)
at Microsoft.Crm.Setup.Database.DatabaseInstaller.IsValidForUpgrade(String installXmlFile, CrmDbConnection connection)
at Microsoft.Crm.Tools.Admin.OrganizationUpgrader.IsOrganizationVersionSupportedForUpgradeFromConnectionString(String connectionString, String installXmlPath)
at Microsoft.Crm.Tools.Admin.SqlServerPage.OrgChanged()
at Microsoft.Crm.Tools.Admin.SqlServerPage.crmDbComboBox_TextChanged(Object sender, EventArgs e)
at System.Windows.Forms.ComboBox.set_SelectedIndex(Int32 value)
at Microsoft.Crm.Tools.Admin.SqlServerPage.FillInDbComboBox()

*This post is locked for comments

All responses (4)

Answers (1)

jdalske 536 on at

Like (0)

Report

RE: Error Launching Import Organization Wizard

Can you outline how your dropped the database to resolve your issue? Was this the MSCRM db?
Verified answer

Chris.P on at

Like (1)

Report

RE: Error Launching Import Organization Wizard

We discovered that a CRM database had been accidentally restored over the master database. Once we dropped the CRM database objects from master, the Import Organization wizard launched successfully.
Chris.P on at

Like (0)

Report

RE: Error Launching Import Organization Wizard

Registry looks fine. I had reinstalled 3 times already (once with a re-imaged VM), but same result every time.

Event log only shows a.NET error from MMC crashing, which was due to the SQL error reported in the log I posted above.

The server names haven't changed at all either, so no mismatches there either.
Suggested answer

Emre GULCAN 2,379 on at

Like (0)

Report

RE: Error Launching Import Organization Wizard

Hi,

I experienced an exception (MMC crash) when I open Deployment Manager, few weeks ago.

Maybe you should check your registry settings from "HKEY_LOCAL_MACHINE>SOFTWARE>Microsoft>MSCRM", in this settings check your all information like "configdb", "server url".

And also you should check "Servers" section and confirm correct values exists (if you can open Deployment Manager).

My problem occured due to database server's name changed from system admin (I don't know why :)) and after some painful hours I decided to reinstall / repair Dynamics CRM onprem installation and it found new database server and my problem solved.

And also please check "Event Viewer > Windows Logs > Application", maybe you can find something useful