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 for Me (Login required).

Search for additional results

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