java.io.CharConversionException error

RAJ6 — Thu, 12 Apr 2018 11:49:19 GMT

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]

Re: java.io.CharConversionException error

Anonymous — Mon, 16 Apr 2018 10:47:52 GMT

Hello,

What's your DB2 version you are using? Could you please refer to this online document about:TalendHelpCenterupported 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

topic Re: java.io.CharConversionException error in Talend Studio

java.io.CharConversionException error

Re: java.io.CharConversionException error