Fixed: Could not create instance of type: Sitecore.Data.SqlServer.SqlServerIDTable. No matching constructor was found.

Posted on Updated on

I’m playing around with the Sitecore configurations today, while setting up the content management & content delivery environments. Then suddenly, this error showed up.

Server Error in ‘/’ Application.


Could not create instance of type: Sitecore.Data.SqlServer.SqlServerIDTable. No matching constructor was found.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: Sitecore.Exceptions.ConfigurationException: Could not create instance of type: Sitecore.Data.SqlServer.SqlServerIDTable. No matching constructor was found.
Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[ConfigurationException: Could not create instance of type: Sitecore.Data.SqlServer.SqlServerIDTable. No matching constructor was found.]
   Sitecore.Configuration.Factory.CreateFromTypeName(XmlNode configNode, String[] parameters, Boolean assert) +272
   Sitecore.Configuration.Factory.CreateObject(XmlNode configNode, String[] parameters, Boolean assert, IFactoryHelper helper) +131
   Sitecore.Configuration.Factory.CreateObject(String configPath, String[] parameters, Boolean assert) +579
   Sitecore.Configuration.Factory.GetIDTable() +27
   Sitecore.Data.IDTables.IDTable.GetProvider() +11
   Sitecore.Data.IDTables.IDTable.GetKeys(String prefix, ID id) +46
   Sitecore.Strategy.Contacts.DataProviders.IDTableHelper.IsItem(String prefix, ID itemId) +73
   Sitecore.Strategy.Contacts.DataProviders.IDTableHelper.IsFacetItem(ID itemId) +65
   Sitecore.Strategy.Contacts.Pipelines.DataProviders.IsHandled.DefaultProcessor.Process(IsHandledArgs args) +327
   (Object , Object[] ) +177
   Sitecore.Pipelines.CorePipeline.Run(PipelineArgs args) +484
   Sitecore.Pipelines.CorePipeline.Run(String pipelineName, PipelineArgs args) +28
   Sitecore.Strategy.Contacts.Pipelines.DataProviders.GetItemDefinition.CheckIfHandled.Process(GetItemDefinitionArgs args) +217
   (Object , Object[] ) +177
   Sitecore.Pipelines.CorePipeline.Run(PipelineArgs args) +484
   Sitecore.Pipelines.CorePipeline.Run(String pipelineName, PipelineArgs args) +28
   Sitecore.Strategy.Contacts.DataProviders.ContactFacetDataProvider.GetItemDefinition(ID itemId, CallContext context) +130
   Sitecore.Data.DataProviders.DataProvider.GetItemDefinition(ID itemID, CallContext context, DataProviderCollection providers) +148
   Sitecore.Data.DataSource.GetItemInformation(ID itemID) +88
   Sitecore.Data.DataSource.GetItemData(ID itemID, Language language, Version version) +31
   Sitecore.Nexus.Data.DataCommands.GetItemCommand.GetItem(ID ƒ, Language „, Version , Database ) +92
   Sitecore.Nexus.Data.DataCommands.GetItemCommand.Execute(ID ƒ, Language „, Version , Database ) +496
   Sitecore.Data.Engines.DataCommands.GetItemCommand.DoExecute() +139
   Sitecore.Data.Engines.EngineCommand`2.Execute() +96
   Sitecore.Data.Managers.ItemProvider.GetItem(ID itemId, Language language, Version version, Database database) +292
   Sitecore.Data.Managers.ItemProvider.GetItem(ID itemId, Language language, Version version, Database database, SecurityCheck securityCheck) +141
   Sitecore.ContentTesting.Pipelines.ItemProvider.GetItem.GetItemUnderTestProcessor.Process(GetItemArgs args) +145
   (Object , Object[] ) +74
   Sitecore.Pipelines.CorePipeline.Run(PipelineArgs args) +484
   Sitecore.Data.Managers.PipelineBasedItemProvider.ExecuteAndReturnResult(String pipelineName, String pipelineDomain, Func`1 pipelineArgsCreator, Func`1 fallbackResult) +64
   Sitecore.Data.Managers.ItemManager.GetItem(String itemPath, Language language, Version version, Database database) +142
   Sitecore.FXM.Matchers.DomainMatcherRepository.GetAllDomainMatchers(IDatabase database) +81
   Sitecore.FXM.Sites.FxmSiteProvider.GetFxmSites() +182
   Sitecore.FXM.Sites.FxmSiteProvider.get_FxmSites() +103
   Sitecore.FXM.Sites.FxmSiteProvider.GetSites() +88
   System.Linq.<SelectManyIterator>d__16`2.MoveNext() +244
   Sitecore.Sites.SiteCollection.AddRange(IEnumerable`1 sites) +138
   Sitecore.Sites.SitecoreSiteProvider.GetSites() +225
   Sitecore.Sites.SiteContextFactory.GetSites() +256
   Sitecore.Sites.SiteContextFactory.GetSiteContext(String hostName, String fullPath, Int32 portNumber) +121
   Sitecore.Pipelines.HttpRequest.SiteResolver.ResolveSiteContext(HttpRequestArgs args) +430
   Sitecore.Pipelines.HttpRequest.SiteResolver.Process(HttpRequestArgs args) +50
   (Object , Object[] ) +74
   Sitecore.Pipelines.CorePipeline.Run(PipelineArgs args) +484
   Sitecore.Nexus.Web.HttpModule.(Object , EventArgs ) +529
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +142
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +92

My first impression was “huh?!, I’m just changing some configurations, so why it’s throwing no matching constructor“. I asked myself.

huh john depp

So I reverted back my changes one by one, and found out that the issue is because of the changes in the Sitecore.Strategy.Contacts.config. Because I replaced the word ‘master‘ to ‘web’ and that’s the reason I encountered the yellow page. Gotcha!

Sitecore.Strategy.Contacts config

If I proceed a little more further, it would be much harder for me to trace the issue, as it seems that the change in the configuration has no direct connection with the stack traces on the first look. So good thing, I am consistently refreshing the SC instance, every time I change something in the configuration.  😉

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s