Error: "Invalid Column Name"

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.

Cloud Free Trial

Try Talend Cloud free for 30 days.


Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.