SAP Knowledge Base Article - Preview

2922628 - DBACockpit reports Error SQL515 "Attempt to insert NULL value into column..." - SAP ASE for Business Suite

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

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions

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.