SAP Integration Suite - SQL Updata via JDBC Error

cp11 — Fri, 15 Nov 2024 07:54:18 GMT

Hello SAP Experts,

I am trying to trigger the following SQL in an I-Flow via the JDBC Adapter

UPDATE TelHdr SET STATUS=31 WHERE SND = xyz AND TELEID = 1

Unfortunately, I always get the following error:

"org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; Zeichenfolgen- oder Binärdaten würden abgeschnitten.; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: Zeichenfolgen- oder Binärdaten würden abgeschnitten., cause: com.microsoft.sqlserver.jdbc.SQLServerException: Zeichenfolgen- oder Binärdaten würden abgeschnitten."

Error translated into English: ‘String or binary data would be truncated.’

This error means that the written value is too large for the written field.

The same update query was also executed with the same user directly in MS SQL Studio where it worked without problems, which means that the update query with these values and the user with the assigned roles was also checked and should work.

Procedure:

Step 1. JDBC Data Source Creation:

JDBC Data Source in the Integration Suite is set up and it is also possible to read values via a select.

The JDBC driver for Microsoft SQL Server was also changed from version 8.2.2 to 8.4.1 for test purposes, which unfortunately did not change the update behaviour.

Step 2. I-Flow Creation

- Set SQL Statement in the Content Modifier Body

Info: Reading this View via a regular select also works without problems with the same procedure, only the update runs on error

JDBC Adapter with the JDBC Data Source Alias

Error Appears:

Has anyone already had this problem or has an idea of what to check?

Many thanks in advance.

Best regards

Chris P.

Re: SAP Integration Suite - SQL Updata via JDBC Error

Clas_Hortien — Fri, 15 Nov 2024 08:56:09 GMT

Hi,

you could create a SQL Server Profiler trace to see what is different in the statement from the system. See this note 929031 - Using SQL Server Profiler for JAVA (and ABAP) - SAP for Me for details on how to do it.

Best regards

Clas Hortien

Question Re: SAP Integration Suite - SQL Updata via JDBC Error in Technology Q&A

SAP Integration Suite - SQL Updata via JDBC Error

Re: SAP Integration Suite - SQL Updata via JDBC Error