IWR Audit Data not written to the database

[yenfen]

Hi All,
I followed the step by step instrution writting in the Administrator Guide for IWR Auditing. The database is created in SQL Server, data sources are added to IWR server and IWR report. The audit logs are created in the appropiate path. I tried using the IWR audit file processor to populate the database but it gave me a version error. Please help.

 

[cindyw]

For IWR auditing, you do not use the audit file processor. In "Report Administration", click on the top level in report projects (reportproject1) and put a check in the enable auditing box. In "Reports" set a schedule for auditing. The only problem I encountered was that there is no place to reference a schema. If the tables are in a schema that is not the account's schema, nothing will get written. You'll need to create a synonym to get it to work.

 

[DoubleD]

yenfen,
We had problems storing the data initially too. It had to do with the format of the password when manually running the Audit File Processor.

cindyw,
The audit file processor is the command line option to store auditing data. You are correct that you can also schedule the audit processing in Report Administrator.

I am what I am based on the decisions I have made.

DoubleD