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 11201:

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 (ASE16.x)

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 ONE Support launchpad (Login required).

Search for additional results

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