SQL Stored Procedure Error ON Prem (SET ANSI_WARNINGS OFF)

(0) Share

Report

Posted on by KUNGFUPANDA559

I'm receiving the following error:

"Microsoft SQL: String or binary data would be truncated.\r\nThe statement has been terminated.\r\n

When I execute the stored procedure locally, it works perfectly (using SET ANSI_WARNINGS OFF). Not having the same luck executing from flow. Any ideas?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

manuelstgomes 6,625 on at

Like (0)

Report
Copy link

Link copied!

Hi @KUNGFUPANDA559

This is probably due to the size defined in the database. You're probably trying to insert a 15 character string in a varchar(14) for example.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No
KUNGFUPANDA559 69 on at

Like (0)

Report
Copy link

Link copied!

It was definitely an error with the data fields, and sizes of the data that was being submitted. After review, I was able to identify the problem.

Thanks,

Tony

Was this reply helpful? Yes No