SAP Knowledge Base Article - Preview

3260957 - Msg 249, Level 16, State 1 - Syntax error when redirecting audit records to the operating system (OS) syslog file - SAP ASE

Symptom

  • Want to redirect the ASE audit records to the operation system(OS) syslog file.

  • Try to set it by changing the configuration information in "audit trail type"(Linux Only)

  • The documented syntax in, Enable or Disable Auditing, is:
    sp_configure "audit trail type" [{"table" | "syslog"}]

  • When trying to set this parameter and it reports error:
    sp_configure 'audit trail type', "syslog"
    go
    Msg 249, Level 16, State 1:
    Server 'XXX', Procedure 'sp_configure':
    Syntax error during implicit conversion of VARCHAR value 'syslog' to a INT field.
    (return status = -6)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

Audit, redirect, ASE audit records, OS logs(Unix), event logs(Windows), audit trail type, syslog , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.