SAP Knowledge Base Article - Preview

1544419 - SQL Error 8152：String or binary data would be truncated

Symptom

You frequently find SQL Error 8152 in:

  • Syslog (transaction SM21)

Database error 8152 at OPC
[Microsoft][SQL Server Native Client 10.0][SQL Server] String or binary data would be truncated.
Database error 8152

  • Developer Traces (transaction ST11)

C  ERROR: -1 in function StartSelect (execute) [line <number>]
C  (8152) [22001] [Microsoft][SQL Native Client][SQL Server]String or binary data would be truncated.
C  [Microsoft][SQL Native Client][SQL Server]String or binary data would be truncated.
B  ***LOG BY2=> sql error 8152 performing OPC
B  ***LOG BY0=> [Microsoft][SQL Native Client][SQL Server]String or binary data would be truncated.
B  ***LOG BY1=> sql error 8152  

  • Transaction DB02 fails with:

 SQL error 8.152: [SQL Server]String or binary data would be truncated.


Read more...

Environment

ABAP-based SAP Application Server 7.00 and higher
running on MS SQL Server

Product

SAP NetWeaver Application Server for ABAP all versions

Keywords

SQL Error 8152, DB02, Syslog, Developer Trace, Work Process, sap_mon_sqldbfiles , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , 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.