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

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...

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

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

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 on Microsoft SQL Server , Problem