Auditing ReportNet Activity

[Opher]

Has anyone enabled the Audit Reports in ReportNet (I am using 1.1 MR2, but this probably applies to any version).Ã,  The sample Framework for the Audit tables contains a calculation called "Package" which is in fact a parsed substring of the path.Ã,  When a report is run from the Package this column is correct, but when the report is inside a Folder the first letter is dropped (because 'Package' is one letter longer than 'Folder').

Has anyone corrected the expression behind this?Ã,  I've taken a look at it, and tried three times without success.Ã,  The nested string functions are pretty complex.

Thanks,
Opher

[bdybldr]

Opher, I haven't enabled audit reports.  How do you do it?

[Opher]

I wish it was easy as switching it on.  Chapter 15 of the Administration and Security Guide steps through it.  You need a database, configure CRN to use the database, then enable logging on each service at the level of detail you want, then publish the Audit package and the sample reports.  Sheesh!  And I still don't have everything working.

It is really much more complext than it needs to be.

Good luck,
Opher

[Skidly]

Description:

Error running reports against the Audit database when the [PACKAGE] column is included.

Error Message:

UDA-SQL-0114 The cursor supplied to the operation "APICursor::OpenResult" is inactive.

UDA-SQL-0115 Inappropriate SQL request.

UDA-SQL-0206 The OLEDB driver returned the following value: HRESULT= DB_E_ERRORSINCOMMAND ".

RSV-SRV-0025 Unable to execute this request.


Solution:

Open the Audit Model in Framework Manager.

There is a calculation in Audit model (under Run Report Query Subject) against the PACKAGE column -

If ([Audit].[COGIPF_RUNREPORT].[PACKAGE]  = (' '))  then (' ') else (substring ([Audit].[COGIPF_RUNREPORT].[PACKAGE]  , 25 ,character_length( [Audit].[COGIPF_RUNREPORT].[PACKAGE]  ) - 26 ))

If the [PACKAGE] column has the length of less than 26, it generates negative result in above substring().

Change the above to:

if ([Audit].[COGIPF_RUNREPORT].[PACKAGE]  = (' ')  or  character_length ( [Audit].[COGIPF_RUNREPORT].[PACKAGE] )<26) then (' ') else (substring ([Audit].[COGIPF_RUNREPORT].[PACKAGE]  , 25 ,character_length( [Audit].[COGIPF_RUNREPORT].[PACKAGE]  ) - 26 ))

Publish the Audit package again and the error will not be generated.

[sleepy]

bdybldr,

Check out the following knowledge base articles #1005106 and #1010813.

Theres also a very handy multimedia knowledgebase movie titled "Enabling Audit Logging in Cognos Reportnet" that takes you through the entire process.

sleepy  ;D