SAP Knowledge Base Article - Preview

2544712 - SQL18124 - No matching configuration options - SAP ASE

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

SAP Adaptive Server Enterprise 16.0 ; SAP Customer Relationship Management 7.0 ; SAP ERP 6.0 ; SAP NetWeaver all versions ; SAP Solution Manager 7.1 ; SAP Supplier Relationship Management 7.0 ; SAP Supply Chain Management 7.0

Keywords

CR809999, 809999, SQL18124, sp_configure, Configuration checker , KBA , sp_configure , isql , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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 ONE Support launchpad (Login required).

Search for additional results

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