2945940 - Error: "[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]String or binary data would be truncated"- SAP Data Services

Symptom

Job terminates with the following error :

SQL submitted to ODBC data source <> resulted in error <[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]String or binary data would be truncated.

[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The statement has been terminated. The SQL submitted is <INSERT INTO AL_STAGING_INFO (OBJECT_KEY, JOB_KEY, DATAFLOW_KEY, SUBDATAFLOW_NAME, TYPE, DATASTORE, OWNER, NAME, NAME_OVERFLOW_FLAG, CREATION_TIME) VALUES (1, 12275, '265_1', '265_1', 1, NULL, NULL, 'C:/ProgramData/SAP BusinessObjects/DataServices/log/pCache/', 0, CONVERT(DATETIME2, '2020-07-06 15:35:57.000', 121))>.

Environment

SAP Data Services 4.2 SP11

Product

SAP Data Services 4.2

Keywords

DS, BODS, BODI, Cache, memory, SQL, DB, server, MSSQL, driver, JS, job server, ODBC, datatype , KBA , EIM-DS-EXE , Job Execution , EIM-DS , Data Services , 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.