Symptom
- In DBA Cockpit, the SAP Configuration Check is not working, reporting these errors:
Exception CX_DBA_DBH_SETUP in class CL_SYB_DBH_SETUP method IF_DBA_DBH_SETUP~SET_VALUE line 85
Kernel Error ID:
WP ID: 17
WP PID: 65598
Application Server: lxcihrpwpla
SYSID:
SY-SUBRC: 0
SY-TABIX: 0
Meldung: Unable to insert key/value to configuration table.
Database:
caused by
Exception CX_DBA_ADBC in program SAPMHTTP line 0
Kernel Error ID:
WP ID: 17
WP PID: 65598
Application Server: lxcihrpwpla
SYSID: HRP
SY-SUBRC: 0
SQL statement: INSERT INTO saptools..DBH_CONFIG( "KEY", VALUE, DFT ) VALUES(?, ?, ?)
Database: +++SYBADM
caused by
Exception CX_SQL_EXCEPTION in class CL_SQL_STATEMENT
Kernel Error ID:
DB Error: Yes
SQL Code: 515
SQL Message: [ASE Error SQL515][SAP][ASE ODBC Driver][Adaptive Server Enterprise]Attempt to insert NULL value into column 'DFT', table 'saptools.dbo.DBH_CONFIG'; column does not allow nulls. Update fails.
- The Framework data collector is defective as well, we can also reported the error as Msg 233 from Logs:
Msg 233, Level 16, State 2
Server '<SID>, Procedure 'SP_DBH_FWK_CLEANUP', line 137:
The column SOURCE_HOSTNAME in table saptools..DBH_MSG_LOG does not allow null values.
Msg 233, Level 16, State 2
Server '<SID>, Procedure 'SP_DBH_FWK_CLEANUP', line 137:
The column STMT in table saptools..DBH_MSG_LOG does not allow null values.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP NetWeaver (NW) - All versions
Product
Keywords
SQL515, Msg 233, "allow nulls by default", dbacockpit, dba cockpit, framework, CL_SYB_DBH_SETUP , KBA , 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