0

I'm attempting to debug Sitecore 8.2 personalization on a dev machine, and when I click on the personalization icon, I'm receiving the following exception:

Invalid object name 'dbo.Fact_Personalization'.
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: System.Data.SqlClient.SqlException: Invalid object name 'dbo.Fact_Personalization'.

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: 


[SqlException (0x80131904): Invalid object name 'dbo.Fact_Personalization'.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +3306108
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +736
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4061
   System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() +90
   System.Data.SqlClient.SqlDataReader.get_MetaData() +99
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +604
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3303
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +667
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +83
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +301
   Sitecore.Data.DataProviders.Sql.DataProviderCommand.ExecuteReader() +121

[DataException: Error executing SQL command: SELECT TOP(1) [TestSetId]
FROM 
  dbo.[Fact_Personalization]
WHERE 
  [RuleSetId] = @RuleSetId
  AND [RuleId] = @RuleId
ORDER BY [Date] DESC]

[Exception: Invalid object name 'dbo.Fact_Personalization'.]
   Sitecore.Data.DataProviders.Sql.DataProviderCommand.ExecuteReader() +304
   Sitecore.Data.DataProviders.Sql.DataProviderReader..ctor(DataProviderCommand command) +58
   Sitecore.Data.DataProviders.Sql.c__DisplayClass12.b__10() +72
   Sitecore.Data.DataProviders.NullRetryer.Execute(Func`1 action, Action recover) +290
   Sitecore.Data.DataProviders.Sql.SqlDataApi.CreateReader(String sql, Object[] parameters) +281
   Sitecore.Analytics.Reporting.SqlReportDataSource.GetData(ReportDataQuery query) +686
   Sitecore.Analytics.Reporting.ReportDataProvider.ExecuteQueryWithCache(ReportDataQuery query, ReportDataSource dataSource, CachingPolicy cachingPolicy) +335
   Sitecore.Analytics.Reporting.ReportDataProvider.GetData(String dataSourceName, ReportDataQuery query, CachingPolicy cachingPolicy) +317
   Sitecore.Analytics.Reporting.Datasources.ItemReportDataSource.GetData(ReportDataQuery query) +406
   Sitecore.Analytics.Reporting.c__DisplayClass6.b__4() +28
   Sitecore.Analytics.Reporting.ReportDataProvider.GetCachedDataForQuery(ReportDataQuery query, Func`1 ifNotAvailableInCache, Nullable`1 ifModifiedSince) +511
   Sitecore.Analytics.Reporting.ReportDataProvider.ExecuteQueryWithCache(ReportDataQuery query, ReportDataSource dataSource, CachingPolicy cachingPolicy) +728
   Sitecore.Analytics.Reporting.ReportDataProvider.GetData(String dataSourceName, ReportDataQuery query, CachingPolicy cachingPolicy) +317
   Sitecore.Analytics.Reporting.ReportingQueryBase.ExecuteQuery(Dictionary`2 parameters) +98
   Sitecore.ContentTesting.Analytics.Reporting.LastTestForPersonalizationRuleQuery.Execute() +187
   Sitecore.ContentTesting.Data.SitecorePersonalizationTestStore.GetLastTestForPersonalizationRule(Guid ruleSetId, Guid ruleId) +172
   Sitecore.ContentTesting.Services.PersonalizationService.GetPersonalizationPerformance(ItemUri itemUri, ID deviceId, Guid ruleSetId, Guid ruleId, Boolean ignoreTests, Boolean& setData) +262
   Sitecore.ContentTesting.Services.PersonalizationService.GetRulePerformanceData(ItemUri itemUri, ID deviceId, Guid ruleSetId, Guid ruleId, Boolean ignoreTests) +341
   Sitecore.ContentTesting.Pipelines.RenderRulePlaceholder.AfterAction.Reach.CalculateValue(ItemUri hostItemUri, ID deviceId, ID ruleSetId, ID ruleId) +117
   Sitecore.ContentTesting.Pipelines.RenderRulePlaceholder.AfterAction.Reach.Process(RenderRulePlaceholderArgs args) +228
   (Object , Object[] ) +71
   Sitecore.Pipelines.CorePipeline.Run(PipelineArgs args) +469
   Sitecore.Pipelines.RenderRulePlaceholder.RenderRulePlaceholderPipeline.Run(String placeholderName, ItemUri uri, ID deviceId, ID ruleSetId, XElement rule) +261
   Sitecore.Shell.Applications.WebEdit.Dialogs.Personalization.PersonalizationForm.RenderRulePlaceholder(String placeholderName, XElement rule) +147
   Sitecore.Shell.Applications.WebEdit.Dialogs.Personalization.PersonalizationForm.GetRuleSectionHtml(XElement rule) +367
   Sitecore.Shell.Applications.WebEdit.Dialogs.Personalization.PersonalizationForm.RenderRules() +287

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) +0
   System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) +128
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +142
   Sitecore.Reflection.ReflectionUtil.InvokeMethod(MethodInfo method, Object[] parameters, Object obj) +89
   Sitecore.Web.UI.Sheer.ClientPage.OnLoad(EventArgs e) +597
   System.Web.UI.Control.LoadRecursive() +68
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3785

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.3282.0

I'm sure I'm missing a configuration on my dev environment. Can anyone point to what configuration would be missing to cause that error?

Thanks.

  • 3
    Pure guess: The reporting database is missing tables. Maybe its the wrong verson of the reporting DB? If this is an upgraded instance, did the SQL upgrades occur? Pure speculation. – Pete Navarra Mar 21 at 2:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.