System.ArgumentException: Empty strings are not allowed. Parameter name: connectionString at Sitecore.Analytics.Data.DataAccess.DataAdapters.Sql.SqlServer.SqlServerDataAdapterProvider..ctor()

Recently one of my developers ran in to the following error when previewing a field of the type "Mutlilist with Search"  in content editor in Sitecore 7.2:

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation.---> System.ArgumentException: Empty strings are not allowed. Parameter name: connectionString at Sitecore.Data.SqlServer.SqlServerDataApi..ctor(String connectionString) at Sitecore.Analytics.Data.DataAccess.DataAdapters.Sql.SqlServer.SqlServerDataAdapterProvider..ctor() --- End of inner exception stack trace-- at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeConstructorInfo.Invoke(BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at Sitecore.Reflection.ReflectionUtil.CreateObject(Type type, Object[] parameters) at Sitecore.Configuration.Factory.CreateFromTypeName(XmlNode configNode, String[] parameters, Boolean assert) at Sitecore.Configuration.Factory.CreateObject(XmlNode configNode, String[] parameters, Boolean assert, IFactoryHelper helper) at Sitecore.Configuration.Factory.GetProviders[TProvider,TCollection](List`1 nodes) at Sitecore.Configuration.Factory.GetProviders[TProvider,TCollection](String rootPath, TProvider& defaultProvider) at Sitecore.Configuration.ProviderHelper`2.ReadProviders() at Sitecore.Configuration.ProviderHelper`2.get_Provider() at Sitecore.Analytics.Data.DataAccess.DataAdapters.DataAdapterManager.LoadVisitor(VisitorDataSet dataSet, VisitorLoadOptions visitorLoadOptions) at (Object , Object[] ) at Sitecore.Pipelines.CorePipeline.Run(PipelineArgs args) at Sitecore.Analytics.Data.DataAccess.DataSets.VisitorDataSet.Load(VisitorLoadOptions visitorLoadOptions) at Sitecore.Analytics.Data.DataAccess.Visitor.Load() at Sitecore.Analytics.Data.DataAccess.Visitor.GetCurrentVisit() at Sitecore.Analytics.Data.DataAccess.Visitor.GetOrCreateCurrentVisit() at Sitecore.ContentSearch.Pipelines.TranslateQuery.AnalyticsContextResolver.Search(TranslateQueryArgs args) at Sitecore.ContentSearch.Pipelines.TranslateQuery.AnalyticsContextResolver.Process(TranslateQueryArgs args) at (Object , Object[] ) at Sitecore.Pipelines.CorePipeline.Run(PipelineArgs args) at Sitecore.ContentSearch.Pipelines.TranslateQuery.TranslateQueryPipeline.Run(ICorePipeline pipeline, TranslateQueryArgs args) at Sitecore.ContentSearch.Utilities.LinqHelper.CreateQuery[T](IProviderSearchContext context, IEnumerable`1 searchStringModel, Item startLocationItem, IEnumerable`1 additionalContexts) at Sitecore.ContentSearch.Utilities.LinqHelper.CreateQuery[T](IProviderSearchContext context, IEnumerable`1 searchStringModel) at Sitecore.Buckets.FieldTypes.SearchList.GetItems(Item current) at Sitecore.Buckets.FieldTypes.SearchList.DoRender(HtmlTextWriter output) at Sitecore.Web.UI.WebControl.Render(HtmlTextWriter output) at System.Web.UI.Control.RenderControlInternal(HtmlTextWriter writer, ControlAdapter adapter) at System.Web.UI.Control.RenderChildrenInternal(HtmlTextWriter writer, ICollection children) 
The issue was caused by an empty connection string for Analytics DB. So we simpy removed the connection string and ran into the following error:
Exception: System.InvalidOperationException
Message: 'analytics' connection string is not defined
Source: Sitecore.Kernel
   at Sitecore.Diagnostics.Assert.IsNotNull(Object value, String message)
   at Sitecore.Diagnostics.Assert.ResultNotNull[T](T result, String message)
   at Sitecore.Analytics.Data.DataAccess.DataAdapters.DataAdapterManager.ConnectionStrings. get_AnalyticsSettings()
   at Sitecore.Analytics.Data.DataAccess.DataAdapters.DataAdapterManager.ConnectionStrings. get_Analytics()
   at Sitecore.Analytics.Data.DataAccess.DataAdapters.Sql.SqlServer.SqlServerDataAdapterProvider. .ctor()

So what happened here was that Analytics for Sitecore had been enabled on the DEV environment and the changes to the Sitecore.Anaytlics.config were checked into source control. The local developer sandboxes were never configured with Analytics. The two settings that trigger Sitecore to look for Analytics DB are:

<!--  ANALYTICS DISABLE DATABASE
            Disables the database so that no reading or writing to the database occurs.
            Default: false
      -->
      <setting name="Analytics.DisableDatabase" value="false" />
<!--  ANALYTICS ENABLED
            Determines whether analytics is enabled or not.
            Default: true
      -->
      <setting name="Analytics.Enabled" value="true" />

 Simply disabling the Analytics DB by setting the Analytics.DisableDatabase to "true" solved the problem.

Now, what I am yet to figure out is what did that "Multilist with Search" field check for Analytics DB when none of the other field types did. Please feel free to post any comments or suggestions.

Comments

Post a Comment

Popular posts from this blog

RESOLVED: Solr Exceptions - Document contains at least one immense term in field

If you implemented Solr with Sitecore using Solr 5.x, you may run into the following error when indexing extremely large content in string fields: org.apache.solr.common.SolrException: Exception writing document id <xxxuniqueid> to the index; possible analysis error. Caused by: java.lang.IllegalArgumentException: Document contains at least one immense term in field="<xxxfieldname>" (whose UTF8 encoding is longer than the max length 32766), all of which were skipped. Please correct the analyzer to not produce such terms. The prefix of the first immense term is: '[10, 9, 9, 10, 32, 32, 32, 32, 32, 32, 82, 84, 82, 83, 32, 70, 97, 99, 105, 108, 105, 116, 121, 32, 10, 32, 32, 32, 32, 84]...', original message: bytes can be at most 32766 in length; got <intgreaterthan32766> Caused by: org.apache.lucene.util.BytesRefHash$MaxBytesLengthExceededException: bytes can be at most 32766 in length; got <intgreaterthan32766> This is due to the fa
Read more

Is Rendered Item Valid XHtml Document Could not find schema information warnings during publish item Sitecore 7.2

Image
Note: Since we now live in the HTML5 world, the simple resolution to any XHtml validation errors is to remove the XHtml validation rules on  System->Settings->Validation Rules->Global Rules item. Sitecore should update it's validation rules to be relevant to HTML5. This make the rest of this post obsolete :). I created a simple approval workflow in Sitecore 7.5 and tried to approve an item for publishing and found a bunch of validation errors in the Validation Results. Most of them were related to the "Is Rendered Item Valid XHtml Document" section which looked like this: The problems were related to violations of the W3C HTML5 recommendation An important note here is: The element containing the character encoding declaration must be serialized completely within the first 1024 bytes of the document. Adding the following xmlns attribute to the Html tag fixed most of the errors: <html lang="en" xmlns="http://www.w3.org/1999/
Read more

First look at Sitecore XM Cloud: Part 4 - Creating a new Site

Image
 Once you have successfully create an environment, you can go ahead and create your first site. In order to create a new Site, you need to launch the Sitecore Launchpad by clicking on the "XM Cloud Launchpad": Click on "Sites" menu to create a new Site: Click on "Add your first website" button to start the wizard. I chose the "Basic Site" template: Enter a Site name and pick a language and click on "Create website" button. You will see the following screen while your Site is being created: Once the Site is created, you can edit it in Pages or Explorer using the context menu: Explorer view of the Site: 1. "Details" view of page. 2. "Content" view of page: Unfortunately, trying to load the new Site in pages gives "Unable to connect to remote server"
Read more