Five Stars


Hi All,


I am new here, so sorry if this is not the right thread to post this.

I have a job where I am needed to put in 100 datas into my teradata using the teradataSCD (as I need to get the scd_end, scd_start, version infos)... this was all fine till I was about to put in 1 new data into the table.


I got this :


[trace] connecting to socket on port 4890
[trace] connected
Exception in component tTeradataSCD_1
java.sql.SQLException: [Teradata JDBC Driver] [TeraJDBC] [Error 602] [SQLState HY000] ResultSet:getInt: conversion error ( )
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(
at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDriverJDBCException(
at com.teradata.jdbc.jdbc_4.TDResultSet.internalGetInt(
at com.teradata.jdbc.jdbc_4.TDResultSet.getInt(
at try_sample.dummy1_0_1.dummy1.tFileInputDelimited_1Process(
[FATAL]: try_sample.dummy1_0_1.dummy1 - tTeradataSCD_1 [Teradata JDBC Driver] [TeraJDBC] [Error 602] [SQLState HY000] ResultSet:getInt: conversion error ( )
at try_sample.dummy1_0_1.dummy1.tTeradataConnection_1Process(
at try_sample.dummy1_0_1.dummy1.runJobInTOS(
at try_sample.dummy1_0_1.dummy1.main(
Caused by: java.lang.NumberFormatException: empty String
at sun.misc.FloatingDecimal.readJavaFormatString(
at sun.misc.FloatingDecimal.parseDouble(
at java.lang.Double.parseDouble(
at java.lang.Double.<init>(
at com.teradata.jdbc.jdbc_4.TDResultSet.internalGetInt(
... 5 more
[statistics] disconnected
[trace] disconnected


I seem to be only be able to input data into an empty table using SCD...


Can anyone advice me on this? 


Re: teradataSCD


What's your data type of your column? Could there be some null values in your column?

Best regards


Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Five Stars

Re: teradataSCD

hi xsdhi,


I have figured it out. Seems like my schema was wrong and it didn't sync.

Thanks for the reply and help!


Smiley Happy