2349300 - DBACockpit Single Table Analysis error: SQL8152 String or binary data would be truncated | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2349300 - DBACockpit Single Table Analysis error: SQL8152 String or binary data would be truncated

Symptom

While running Single Table Analysis of a table in DBACockpit transaction, you get the following error:

SQL 8.152 : String or binary data would be truncated. [WP2 ] [sap_get_index_data:BUILD_N_EXEC]

The developer trace shows additional details:

dbdsmss: DBSL27 SQL8152
String or binary data would be truncated.
***LOG BY2=> sql error 8152 performing OPC [dbds         437]
***LOG BY0=> String or binary data would be truncated. [dbds         437]

C  ERROR: -1 in function StartSelect (execute) [line 16183]

C  (8152) [22001] [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]String or binary data would be truncated.
C  ERROR: -1 in function StartSelect (execute) [line 16183]
C  (3621) [01000] [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]The statement has been terminated.
C  Error 27 (dbcode 8152) in StartSelect
C  StartSelect: stmt of NULL_STMTID
C  /* sap_get_index_data: Get index data for Single Table Analysis */#

As well the system log (SM21):

BY  2 Database error 8152 at OPC
BY  0 > String or binary data would be truncated.


Read more...

Environment

  • SAP NetWeaver based systems with ABAP Stack;
  • SAP_BASIS 702, 730, 731, 740, 750;
  • MS SQL Server 2012 and higher;

Product

SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

SQL11, SQL12, SQL13, mssql, msql, ms_sql, Microsoft SQL Server, sqlsrv, sqlserver, ms sql srv, ms sql server, script, proc, function, replace, SQL8152, sql 8152, string or binary data would be truncated, truncated, red alert, red error, dba cockpit, DB02, ST04, database, BW table, column store, indexes, single table analysis, sap_get_index_data, The statement has been terminated, StartSelect, NULL_STMTID, ERROR -1, DBSL27, OPC, System Log, ST11, SM21, , KBA , BC-DB-MSS-CCM , CCMS/Database Monitors for SQL Server , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BW-SYS-DB-MSS , BW Microsoft SQL Server , 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.