Symptom
You have recently upgraded to ASE 160 SP02 PL06 or ASE 160 SP2 PL06 HF1
NOTE: For SQL18124 on ASE 160 SP02 PL07 please see SAP KBA 2604896
- sp_configure check for the group "Non-Volatile Caches" fails when executed in isql:
Group: Non-Volatile Caches
Msg 18124, Level 16, State 1:
Server 'SID', Procedure 'sp_configure', Line 1732:
No matching configuration options. Here is a listing of groups:
- On systems running SAP applications on SAP ASE you find:
1. DBACockpit -> Configuration -> SAP Configuration Checker to fail with the error:
Detailed Error Description from DBA Cockpit -> Server Configuration:
Exception CX_DBA_ADBC in class CL_DBA_RDI_QUERY method EXECUTE line 157
Kernel Error ID:
WP ID: 20
WP PID: 4954
Application Server: xxxxxxx
SYSID: SID
SY-SUBRC: 1208
Message: ADBC error
SQL statement: EXEC sybsystemprocs..sp_configure ?
Database: +++SYBADM
caused by
Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT
Kernel Error ID:
DB Error: Yes
SQL Code: 18124
SQL Message: [ASE Error SQL18124][SAP][ASE ODBC Driver][Adaptive Server Enterprise]No matching configuration options. Here is a listing of groups:
2. SM21 log also reports SQL18124 errors
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL06 HF1 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL06
Product
Keywords
CR809999, 809999, SQL18124, sp_configure, Configuration checker , KBA , sp_configure , isql , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.