Audit database (no enties are added)

[ciber]

Hi All,

We have set-up the Cognos Audit functionality.
We can't see any errors (Cognos Services).
Have set the logging to basic.
We have stop and start alle Services and logged out / in again.
(We are using Cognos 8.2)


There are no entries in the Audit database tables.

What can we do wrong?

Please help.

Thanks!

[ciber]

Nobody

[cognos_guru]

Check your configuration..

Did you set up logging to an audit database?
Verify the connection settings are correct.
Make sure the DB user has the ability to read, write, etc etc...

There is a really great document on the support site for setting up audit logging and the installation/configuration guide is helpful as well.

[Plantje]

I have a somewhat similar issue.

If I look at my Cognos Configuration I see in the "logging" area two entries: both file and database are there. May this be causing a problem?

I have compared the machine that is creating the log files correctly. All settings are the same. Only downside is that I cannot check the Cognos Configuration of the machine that is logging correctly.

I have no clue of what is going wrong!

[ciber]

Hi cognos_guru,

I know all the install documents have read them.
Done all the steps.

I created a logging database;
Tested the connection (no errors)
Have set the logging level to basis.
The DB user has all the rights.
Everything works fine and I can't see any error, but there are no entries in the Audit entities.

What can more do to check beside the install documents ?

[ciber]

Hi Plantje,

You should have two entries in the logging area.
One for the file logging (default)
One for the database logging.

I have done many Cognos installations including the Audit functionality.
Until now I knew all undocumented issues how to install the Audit functionality.
What can I check / do next?

Until now, Cognos / IBM only mails me the 'default' installation documentation, but that's what I done and know 

There must be a way to check something I hope?

[Plantje]

I thought one needed EITHER a file logging entry OR a database logging entry in the logging area.

Yesterday I talked to somebody from Cognos and he stressed that it's very important to have sufficient rights for the user that accesses the logging database.

I'm using an Oracle database. What are you using?

[twlarsen]

Are you doing any tracing with Cognos support for other problems?  Some of the tracing that cognos support does actually disables audit logging.  I've ran into that before.

[Plantje]

No tracing here.

Yesterday I found an additional statement in the documentation stating the logging database may not be the same as the content store database. (So I had that wrong)

Therefore I created a new schema in the same instance and created a new entry in the Cognos configuration (and deleted the old one of course) to have Cognos write it's logging to this new database.
Again (after stopping/starting the services) I saw the tables being created again.

But still: no logging!

The strange thing is: if I import a package or something (like the sample databases etc) I DO get some logging. But just running a report doesn't create log entries!

[ciber]

Hi Plantje,

We are using SQL Server.
The user have the right rights for the database and the tables are created.
We also have deleted the Audit database and create it again.
No luck so far.

[ciber]

Hi twlarsen,

Also no Cognos tracing here....

(where are you disabling the logging functionality in Cognos?)

[Plantje]

I've also added a new topic, because I think there is more wrong on our system.

Could you check if it is possible on your system to create IQD's for example? Or publish a Transformer Powercube to a shared directory? I can imagine specifically the latter one is not something you test in a few seconds.

[ciber]

Plantje,

Sorry, I can't test that.
It's our production Cognos Server.

IQD and PowerPlay cubes are created at the Development Cognos Server and connected to our Framework Project.
Then we can publish the packages to Production.
So whe don't are not developing at our production.
And .... I am not able to install software on our production Server.

[Plantje]

Okay, that is understandable

[ciber]

Yeah thanks!

But i still have no sollution 

Sometimes I just uninstall Cognos and reinstall Cognos again and it solves the problem.
But now I am not in controle of the Cognos server..........
And I think there must be an other way to fixe this.
What can I controle more to fixe or check.....

No errors in the log files,
No errors in the Windows Events,
No errors in SQL server,

But also no logging in the audit entities.....