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)