Sitecore DMS uses master database per default

This one was identified by my colleague Thomas Stern. The Sitecore Digital Marketing System (formerly known as Sitecore OMS, affectionally known as Sitecore Analytics) uses the master database per default as its lookup database. This is great for people who doesn’t like to publish their contents, bad for people who uses staged environments where the front-end server have no access to the master database.

If you have DMS enabled on a front end server with no access to the master database, you will get the following errors in your log:

Exception: System.InvalidOperationException Message: Could not find configuration node: databases/database[@id='master']
Source: Sitecore.Kernel 

The problem is easily resolved using the hidden feature “Analytics.DefaultDefinitionDatabase”. Create a .include file (or add the setting directly to the web.config) and set the Default Definition Database to “web”:

<configuration>
   <sitecore>
     <settings>
       <setting name=“Analytics.DefaultDefinitionDatabase“ value=“web“ />
     </settings>
   </sitecore>
</configuration>

Remember to instruct your Analytics people to publish their changes.

Advertisements

About briancaos

Developer at Pentia A/S since 2003. Have developed Web Applications using Sitecore Since Sitecore 4.1.
This entry was posted in Sitecore 6 and tagged , , , , . Bookmark the permalink.

3 Responses to Sitecore DMS uses master database per default

  1. Mark Ursino says:

    This is a troubling one indeed. It turns out this setting is listed right in the Scaling guide. I found the solution here.

  2. Pingback: Sitecore DMS uses master database as default | Sitecore stuff

  3. Nat says:

    Glad you found this

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