topic Re: Operand type clash: varbinary is incompatible with float error running in Talend Studio

Operand type clash: varbinary is incompatible with float error running

Anonymous — Mon, 13 May 2013 15:58:12 GMT

When my job runs a good number of rows are both updated and inserted and then everything turns nasty with the error: Operand type clash: varbinary is incompatible with float.
Thing is I'm not sure where to begin to find where the problem is. The mapping looks reasonable good and I suspect it is the data I am getting back in the 1st place.
In general what is the best course of action or process of elimination do you use in this scenario?
Thanks, Dave.

Re: Operand type clash: varbinary is incompatible with float error running

janhess — Mon, 13 May 2013 16:31:30 GMT

Check your schemas. Looks like data type incompatibility though the compiler should have picked it up.

Re: Operand type clash: varbinary is incompatible with float error running

Anonymous — Tue, 14 May 2013 05:02:43 GMT

Hi,
Varbinary will cast implicitly to varchar and int but not float.
See the graph here: http://msdn.microsoft.com/en-gb/library/ms187928.aspx
I suspect you are not storing a true database null in the varchar and int columns
Best regards
Sabrina

Re: Operand type clash: varbinary is incompatible with float error running

Anonymous — Thu, 16 May 2013 15:06:23 GMT

The problem seemed to in the select statement even though the destination table accepts NULLs for the money columns it seemed to not like the in TOS. So a simple ISNULL() seemed to do the trick