Msg 8152, Level 16, State 14, Line 1 String or binary data would be truncated. The statement has been terminated??
I had come up with a strange issue while working with the ADF V2, I have a pipeline that we run for multiple table where only thing is required to execute the stored procuedres, now we have 10-15 lines of code writtent to execute the stored procedure that takes data from stage tables and populate the facts and dimensions, whenever we run the procedure from SSMS it runs successfuly without any issues, but when we try to run this using ADF stored procedure activity it fails delebraetly with this error:
Msg 8152, Level 16, State 14, Line 1
String or binary data would be truncated.
The statement has been terminated.
both our tables are in Synapse Analytics, when we look depper into the procedure and tried to increase the length of the data type from 50 to 150 the stored procedure worked from ADF itself, but not sure I understand this earlier this was working from SSMS itself and not from ADF and after increase the length of the data type this started to work. Any insights would be helpful
If the SP is running fine in SSMS, it should run fine in ADF as well. Just cross check you are running the same SP from same server & database.
Sign in to comment
@Vaibhav Chaudhari I checked it 2-3 times from the ADF input properties and output as well, same SP has been running but not executing successfuly, after increasing the data type of 1 particular column its gets running, let me reproduce and send some screenshots here.
Hello @Anmol Ganju ,
Thanks for the patience , unfortunately we are not getting the kind of response from the team here . if you have a support plan you may file a support ticket, else could you please send an email to email@example.com with the below details, so that we can create a one-time-free support ticket for you to work closely on this matter.
Subject : Attn Himanshu
Please let me know once you have done the same.