https://community.qlik.com/t5/Talend-Studio/tNetezzaInput-NzSQLException-Bad-Value-for-NZ-Time/m-p/2340626#M108644 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.<BR />If i use edit query and run the query on the schema it works fine.<BR /> Exception in component tNetezzaInput_1<BR /> org.netezza.error.NzSQLException: Bad value for: NZ_TIME<BR /> at org.netezza.sql.NzResultSet.getDbosTimestamp(NzResultSet.java:4038)<BR /> at org.netezza.sql.NzResultSet.getTimestamp(NzResultSet.java:1576)<BR /> at org.netezza.sql.NzResultSet.getTimestamp(NzResultSet.java:1526)<BR /> at rainbow_dq.preview_data.Preview_Data.tNetezzaInput_1Process(Preview_Data.java:3261)<BR /> at rainbow_dq.preview_data.Preview_Data.runJobInTOS(Preview_Data.java:4349)<BR /> at rainbow_dq.preview_data.Preview_Data.main(Preview_Data.java:4241) Thu, 23 May 2013 09:58:19 GMT Anonymous 2013-05-23T09:58:19Z https://community.qlik.com/t5/Talend-Studio/tNetezzaInput-NzSQLException-Bad-Value-for-NZ-Time/m-p/2340626#M108644 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.<BR />If i use edit query and run the query on the schema it works fine.<BR /> Exception in component tNetezzaInput_1<BR /> org.netezza.error.NzSQLException: Bad value for: NZ_TIME<BR /> at org.netezza.sql.NzResultSet.getDbosTimestamp(NzResultSet.java:4038)<BR /> at org.netezza.sql.NzResultSet.getTimestamp(NzResultSet.java:1576)<BR /> at org.netezza.sql.NzResultSet.getTimestamp(NzResultSet.java:1526)<BR /> at rainbow_dq.preview_data.Preview_Data.tNetezzaInput_1Process(Preview_Data.java:3261)<BR /> at rainbow_dq.preview_data.Preview_Data.runJobInTOS(Preview_Data.java:4349)<BR /> at rainbow_dq.preview_data.Preview_Data.main(Preview_Data.java:4241) Thu, 23 May 2013 09:58:19 GMT https://community.qlik.com/t5/Talend-Studio/tNetezzaInput-NzSQLException-Bad-Value-for-NZ-Time/m-p/2340626#M108644 Anonymous 2013-05-23T09:58:19Z