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
Opher, I haven't enabled audit reports. How do you do it?
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
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.
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