java.sql.SQLDataException: Cannot determine value type from string 'USD '

[shalinim1]

Hi,

I have a tfileinputdelimited connected to db table with tmap, in input file there is a column called currency_type which has data like 'USD', 'INR', 'GBR'. The job ran successfully and the data was loaded to the db table.

When I tried to load from that db table to another table, it is throwing the following exception,

Exception in component tDBInput_1 (Partdimension)

java.sql.SQLDataException: Cannot determine value type from string 'USD '

 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:114)

 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)

 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)

 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)

 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)

 at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:96)

 at com.mysql.cj.jdbc.result.ResultSetImpl.getInt(ResultSetImpl.java:895)

 at case_study_etl_process.partdimension_0_1.Partdimension.tDBInput_1Process(Partdimension.java:1718)

 at case_study_etl_process.partdimension_0_1.Partdimension.runJobInTOS(Partdimension.java:3559)

 at case_study_etl_process.partdimension_0_1.Partdimension.main(Partdimension.java:3409)

Caused by: com.mysql.cj.exceptions.DataConversionException: Cannot determine value type from string 'USD '

 at com.mysql.cj.result.StringConverter.createFromBytes(StringConverter.java:131)

 at com.mysql.cj.protocol.a.MysqlTextValueDecoder.decodeByteArray(MysqlTextValueDecoder.java:238)

 at com.mysql.cj.protocol.result.AbstractResultsetRow.decodeAndCreateReturnValue(AbstractResultsetRow.java:143)

 at com.mysql.cj.protocol.result.AbstractResultsetRow.getValueFromBytes(AbstractResultsetRow.java:250)

 at com.mysql.cj.protocol.a.result.ByteArrayRow.getValue(ByteArrayRow.java:91)

 at com.mysql.cj.jdbc.result.ResultSetImpl.getNonStringValueFromRow(ResultSetImpl.java:655)

 ... 4 more

[manodwhb]

@Shalini M​ , can you share the screenshot of schema of tDBinput and can u check do you have and USD value which is converting ?

Thanks,

Manohar

[shalinim1]

@Manohar B​  In the next process I just want to load the table. conversion will take place in next step.

Regards,

Shalini

[manodwhb]

@Shalini M​ , can you import the table in repository>>metadata , which you have loaded from tfileInputDelimited to DB? and check the data type for loading?

Thanks,

Manohar

[shalinim1]

Yes, I have imported that file in repository. and the data type is string.

[shalinim1]

@Manohar B​ The issue got resolved. Thank you for the response.

[manodwhb]

@Shalini M​ ,Great, please mark the answer so that it will help to others.

Thanks,

Manohar