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
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.