TDS RPC protocol flow is not correct

gcavallaro — Fri, 09 Feb 2024 17:03:13 GMT

Hi everybody.

This is my first post, so I apologize if I'm doing something wrong.

I'm working in Talend on a Data Integration pipeline. This is quite straightforward: some input, couple of TMaps and two tDBOutput components to write the results on my DB. When I try to write my results (over 1.2M of rows) for a bunch of rows I obtain the following error:

"The TDS RPC protocol flow is not correct. Parameter 9 (""): the provided value is not a valid instance of the float data type. Check if the source data includes invalid values. An invalid value is, for example, a numeric value with a scale greater than the precision."

Now, looking at the error seems that is something that has to do with data input or output for a float data type, but I double checked every attribute that I have and I don't have any float type, nor in my final DB I try to write a float data. Also, I have no idea how to know which is Parameter9.

Anyone has ever encountered this?

Thank you in advance

topic TDS RPC protocol flow is not correct in Talend Studio

TDS RPC protocol flow is not correct