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.