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 ONE Support launchpad (Login required).

Search for additional results

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