Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
PaulyWally
Contributor III
Contributor III

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(SQLDiagnostic.java:372)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2988)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2421)
at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:671)
at net.sourceforge.jtds.jdbc.JtdsStatement.executeSQLQuery(JtdsStatement.java:505)
at net.sourceforge.jtds.jdbc.JtdsPreparedStatement.executeQuery(JtdsPreparedStatement.java:1029)
at test_Project.useraccounts_0_1.UserAccounts.tMSSqlInput_2Process(UserAccounts.java:6646)
at test_Project.useraccounts_0_1.UserAccounts.tFileInputExcel_1Process(UserAccounts.java:4146)
at test_Project.useraccounts_0_1.UserAccounts.runJobInTOS(UserAccounts.java:8608)
at test_Project.useraccounts_0_1.UserAccounts.main(UserAccounts.java:8416)

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!
Labels (4)
2 Replies
Anonymous
Not applicable

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?
PaulyWally
Contributor III
Contributor III
Author

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.