I am having a big headache with this. I am trying to insert data into my SQL Server Database with the DB Insert Node. The situation is this: I have some double columns in Knime in wich I may have some NaN values and I have some columns in SQL Server that are of Nullable Decimal type, but when I try to insert, it gives me two types of error:
With no Output Type Mapping changes:
ERROR DB Insert 0:85 Execute failed: Error while adding rows #-100 - #0, reason: The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter 1 (""): The supplied value is not a valid instance of data type float. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision.
When I change the Output Type Mapping for “-> Double -> DECIMAL”, it shows this error:
ERROR DB Insert 0:85 Execute failed: (“NumberFormatException”): null
Could you please help me with this?