SAP Knowledge Base Article - Preview

2907253 - Run sp_audit gets error "Number (11021) Function AUDIT_OPTION invoked with wrong number" after upgrading to ASE16 from ASE15.7

Symptom

  • After upgrading ASE version to 16.x from 15.7, execute the sp_audit and gets error 11021:

sp_audit 'restart'
go

Number (11021) Severity (16) State (2) Server (ASE) Procedure (sp_audit:480) Function AUDIT_OPTION invoked with wrong number or type of argument(s).
Number (11021) Severity (16) State (2) Server (ASE) Procedure (sp_audit:614) Function AUDIT_OPTION invoked with wrong number or type of argument(s).

sp_audit 'all','loginame','all','on'
go

Number (11021) Severity (16) State (2) Server (ASE) Procedure (sp_audit:480) Function AUDIT_OPTION invoked with wrong number or type of argument(s).
Number (11021) Severity (16) State (2) Server (ASE) Procedure (sp_audit:614) Function AUDIT_OPTION in invoked with wrong number or type of argument(s).

  •   Check the output of sp_version, the version of script installsecurity is ASE15.x

1> sp_version
2> go
 Script          Version          Status

-------------------------------------------------------------------
 ...
 installmaster 16.0 SP02 PL03/EBF 25704 SMP/P/x86_64/Enterprise Linux/ase160sp02pl03/2561/64-bit/OPT/Mon Mar 14 20:15:43 2016   Complete
 ....
 installsecurity 15.7/EBF 24647 SMP SP134 /P/x86_64/Enterprise Linux/ase157sp133x/3925/64-bit/OPT/Sat May  2 00:36:20 2015          Complete


Read more...

Environment

      Adaptive Server Enterprise (ASE) 16.x

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

sp_audit, upgrade, Number (11021), Function AUDIT_OPTION, wrong number or type of argument , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

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.