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