Error with out of the box audit reports

Document ID : KB000046110
Last Modified Date : 14/02/2018
Show Technical Document Details

Issue:

 

Audit reports failing with any of the following errors:

  

Error in File ~tmp16c08fbfc000080.rpt:

Error in formula Section_Visibility:

'not isnull({Command.task_name}) 

This field name is not known. 

Details: errorKind 

 

Error in formula Section_Visibility: 

'isnull({Command.ims_transactionid}) 

 

Error in formula Business Unit:

'stringvar temp ; 

 

Error in formula Account: 

'local numberVar position1 := instr({Command_1.ims_eventdescription},"""")

  

Environment 

12.6

 

Cause: 

There can be several causes; 

- Auditing has not been properly configured

- The DB user accessing the DB does not have suffcient privledges 

- Verify the amount of data that is being audited is not an excessive amount 

  

Resolution:

1. Verify using the Techdoc below that Auditing has been properly enabled on your system: 

     http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec541585.aspx

2. The user reporting against the Audit DB needs ‘DBowner’ rights – or at least ‘select, insert, update and delete’ permissions.

3. Run an Audit for a small selection of data and verify if it is still working or not. If it is then the data being parsed is too high of a number.