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.
SAP Knowledge Base Article - Preview