Creating an Audit/Logging Database - Cognos Config not creating tables

[BigD]

Has anybody had an issue when creating the logging/audit database where Cognos Configuration does not create the audit tables in the database.

I have installed Cognos 10, everything working pretty good so far.  My Backend is SQL Server 2008 R2.  When I add a logging resource for the audit database and test it, it succeeds.  According to the implementation guide, once you save and then restart the Cognos service, Cognos should have created a number of tables in the database. 

This does not seem to be happening. My database is still empty with no audit tables at all.  Any ideas?

Thanks in advance.

[sir_jeroen]

Follow the following steps to find out what's causing this:

Logon to the sql server using the provided credentials (if using windows authentication logon to the server with that account)
Go to the directory: <c10 install>\configuration\schemas\content\sqlserver
Run the script: dbInitTest_mssqlserver.sql

You could also do the following (but you might have to do a rollback):
Run the script <c10 install>\configuration\schemas\logging\sqlserver\LS_dbInit_mssql.sql and see if any errors occur...
This is the script that is used by Cognos for creating the DB tables.

[RL_Boston]

Hi - I am also on C10.1 and looking to install Audit/Logging DB and Process. How different are the steps for C10 vs C8?  Which implementation guide did you use for your C10 environment? The only difference is that my current SQL Server is 2005 but we're looking to upgrade to 2008 anyways. Your help will be much appreciated, thanks!

[sir_jeroen]

AFAIK nothing changed. Besides enabling it in Cognos Configuration you'll have to set the level of recording in Cognos Administration.

[BIinNJ]

Did you check the startup log?  If there is an error trying to create the tables it will be in there.