java.io.CharConversionException error

Eight Stars RAJ
Eight Stars

java.io.CharConversionException error

Hi talend folks,

 

I am moving data from db2 to PostgreSQL. My db2 input query like select * from table name. when I ran the job getting java.io.CharConversionException error.

I tried below link also. still am facing same issue

https://community.talend.com/t5/Design-and-Development/DB2-CharConversionException/m-p/53308#M17929

kindly share your information for below error. 

 

[statistics] connecting to socket on port 3484
[statistics] connected
Exception in component tDB2Input_1 (demo_job)
com.ibm.db2.jcc.am.SqlException: [jcc][t4][1065][12306][4.11.77] Caught java.io.CharConversionException. See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null
at com.ibm.db2.jcc.am.gd.a(gd.java:660)
at com.ibm.db2.jcc.am.gd.a(gd.java:60)
at com.ibm.db2.jcc.am.gd.a(gd.java:112)
at com.ibm.db2.jcc.am.jc.a(jc.java:2027)
at com.ibm.db2.jcc.am.jc.n(jc.java:491)
at com.ibm.db2.jcc.am.jc.K(jc.java:1402)
at com.ibm.db2.jcc.am.ym.e(ym.java:1147)
at com.ibm.db2.jcc.am.ym.getString(ym.java:1122)
at routines.system.JDBCUtil.getString(JDBCUtil.java:21)
at db2_to_postgres.demo_job_0_1.demo_job.tDB2Input_1Process(demo_job.java:1111)
at db2_to_postgres.demo_job_0_1.demo_job.runJobInTOS(demo_job.java:1867)
at db2_to_postgres.demo_job_0_1.demo_job.main(demo_job.java:1693)
Caused by: java.nio.charset.MalformedInputException: Input length = 1
at java.nio.charset.CoderResult.throwException(CoderResult.java:281)
[FATAL]: db2_to_postgres.demo_job_0_1.demo_job - tDB2Input_1 [jcc][t4][1065][12306][4.11.77] Caught java.io.CharConversionException. See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null
com.ibm.db2.jcc.am.SqlException: [jcc][t4][1065][12306][4.11.77] Caught java.io.CharConversionException. See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null
at com.ibm.db2.jcc.am.gd.a(gd.java:660)
at com.ibm.db2.jcc.am.gd.a(gd.java:60)
at com.ibm.db2.jcc.am.gd.a(gd.java:112)
at com.ibm.db2.jcc.am.jc.a(jc.java:2027)
at com.ibm.db2.jcc.am.jc.n(jc.java:491)
at com.ibm.db2.jcc.am.jc.K(jc.java:1402)
at com.ibm.db2.jcc.am.ym.e(ym.java:1147)
at com.ibm.db2.jcc.am.ym.getString(ym.java:1122)
at routines.system.JDBCUtil.getString(JDBCUtil.java:21)
at db2_to_postgres.demo_job_0_1.demo_job.tDB2Input_1Process(demo_job.java:1111)
at db2_to_postgres.demo_job_0_1.demo_job.runJobInTOS(demo_job.java:1867)
at db2_to_postgres.demo_job_0_1.demo_job.main(demo_job.java:1693)
at com.ibm.db2.jcc.am.t.a(t.java:44)
at com.ibm.db2.jcc.am.jc.a(jc.java:2019)
... 8 more
Caused by: java.nio.charset.MalformedInputException: Input length = 1
at java.nio.charset.CoderResult.throwException(CoderResult.java:281)
at com.ibm.db2.jcc.am.t.a(t.java:44)
at com.ibm.db2.jcc.am.jc.a(jc.java:2019)
... 8 more
[statistics] disconnected
Job demo_job ended at 06:15 11/04/2018. [exit code=1]

Thanks
RAJ
Moderator

Re: java.io.CharConversionException error

Hello,

What's your DB2 version you are using? Could you please refer to this online document about:TalendHelpCenterSmiley Frustratedupported systems, databases and business applications by Talend components for V 7.0?

DB2 11.x, 10.5 and 10.1 are list on the supported databases table.

Best regards

Sabrina

 

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

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads