Six Stars

Error: "Invalid Column Name"

I'm trying to 'Insert if not exist' on a MSSQL table and I'm getting this error:
Exception in component tMSSqlOutput_2
java.sql.SQLException: Invalid column name 'null'.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(
at test_Project.useraccounts_0_1.UserAccounts.tMSSqlInput_2Process(
at test_Project.useraccounts_0_1.UserAccounts.tFileInputExcel_1Process(
at test_Project.useraccounts_0_1.UserAccounts.runJobInTOS(
at test_Project.useraccounts_0_1.UserAccounts.main(

I've defined all non-null columns in a tJavaRow component just prior to the tMSSQLOutput.  Anywhere in particular I should be looking to fix this?
Thanks in advance!
Seventeen Stars

Re: Error: "Invalid Column Name"

Could you please show us the schema and the component basic settings. Do you have the Field Options in the advanced settings activated and set some options there?
Six Stars

Re: Error: "Invalid Column Name"

So I closed Talend yesterday.  This morning I reopened it, tried it, and it worked.  :-/
Confirmed again.  I put another tMSSQLOutput elsewhere in my dataflow.  I got the same error. Closed and re-opened Talend and it worked.
Weird bug I guess.