2384501 - Audit record does not display actual value - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2384501 - Audit record does not display actual value - SAP ASE

Symptom

  • 'Full-Text Auditing' is a new feature started from ASE 16.0.  Full text with parameter values (local variables / dynamic prepare statements) of DML with option select/insert/update/delete will be printed in column ‘extrainfo’ on sysaudits table.
       
  • When having BOTH configuration parameter 'statement cache size' and 'enable literal autoparam' on, audit record does not show actual value but @@@V0_VCHAR1 / @@@V1_INT etc.
             
    For example: on column ‘extrainfo’ of sysaudits table, it shows full text but no actual parameter values.
            
    event  eventmod spid   eventtime                       sequence suid
             dbid   objid       xactid
             loginname
             dbname
    objname                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 objowner
     extrainfo                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               nodeid
    ==========================================================  
       
         70        1     20             Oct  26 2016 10:31AM        1           1
                  4  1328004731 NULL
             sa
             pubs2
     test                                                                                                                                                                                                                                                                                                                                                                                                                                               dbo
             sa_role sso_role oper_role sybase_ts_role mon_role; update test set a=@@@V0_INT where b=@@@V1_VCHAR1; ; ; ; ; sa/ase;   
               NULL

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 and higher

Product

SAP Adaptive Server Enterprise 16.0

Keywords

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.