Error with out of the box audit reports

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



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: 



Error in formula Business Unit:

'stringvar temp ; 


Error in formula Account: 

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






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 



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

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.