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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tNetezzaInput NzSQLException Bad Value for: NZ_Time

I try to use a tNetezzaInput to read something from a table. The connection works, but previewing data by right clicking the schema's gives the same error as running the job with the tNetezzaInput.
If i use edit query and run the query on the schema it works fine.
Exception in component tNetezzaInput_1
org.netezza.error.NzSQLException: Bad value for: NZ_TIME
at org.netezza.sql.NzResultSet.getDbosTimestamp(NzResultSet.java:4038)
at org.netezza.sql.NzResultSet.getTimestamp(NzResultSet.java:1576)
at org.netezza.sql.NzResultSet.getTimestamp(NzResultSet.java:1526)
at rainbow_dq.preview_data.Preview_Data.tNetezzaInput_1Process(Preview_Data.java:3261)
at rainbow_dq.preview_data.Preview_Data.runJobInTOS(Preview_Data.java:4349)
at rainbow_dq.preview_data.Preview_Data.main(Preview_Data.java:4241)
Labels (3)
0 Replies