EXM 3 Sitecore 8: Invalid object name 'dbo.Fact_AutomationStatesStatisticsByMessage' after Setup

793 Views Asked by At

After installing a clean sitecore 8 and the EXM module, I get the following exception when trying to create a new one-time-message:

Invalid object name 'dbo.Fact_AutomationStatesStatisticsByMessage'.

What's wrong?

2

There are 2 best solutions below

0
Martin English On BEST ANSWER

Make sure that you run Sitecore.EmailExperienceManager.sql to create the necessary tables in the reporting database of your instance. The file is available in the Data folder.

1
Jan Bühler On

During the installation process of the EXM module important-post-installation-steps are shown, also there is a site from sitecore explaining the steps:

https://doc.sitecore.net/email_experience_manager/setting_up_exm/configuration/configure_the_exm_for_the_first_time