topic Re: Required character converter is not available. in Talend Studio

Required character converter is not available.

_AnonymousUser — Thu, 22 Oct 2015 19:29:22 GMT

Hi. I have created a connection to DB2 by going to Metadata/ DB Connections / Create Connection.
I added the JDBC jars and the connection parameters correctly. When I click "Check" to validate the connection, I get a failure with error code 4220. The full error is pasted below.
Any help on how to fix it?

Connection failure. You must change the Database Settings.
com.ibm.db2.jcc.b.SqlException: Required character converter is not available. ERRORCODE=-4220, SQLSTATE=null
      at com.ibm.db2.jcc.b.wc.a(wc.java:55)
      at com.ibm.db2.jcc.b.wc.a(wc.java:119)
      at com.ibm.db2.jcc.b.bc.a(bc.java:1758)
      at com.ibm.db2.jcc.b.bc.n(bc.java:496)
      at com.ibm.db2.jcc.b.bc.F(bc.java:1263)
      at com.ibm.db2.jcc.b.jk.d(jk.java:939)
      at com.ibm.db2.jcc.b.jk.getString(jk.java:917)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.checkSchemaConnection(ExtractMetaDataFromDataBase.java:387)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:330)
      at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:272)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:2674)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:1)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
      at java.util.concurrent.FutureTask.run(Unknown Source)
      at java.lang.Thread.run(Unknown Source)

Re: Required character converter is not available.

Anonymous — Mon, 26 Oct 2015 02:29:55 GMT

Hi DaniM,
Can you connect to your DB2 successfully through client without using Talend tool?

Best regards
Sabrina

Re: Required character converter is not available.

Anonymous — Tue, 27 Oct 2015 13:50:38 GMT

Thank you for the response, Sabrina. I was able to fix this issue by importing a more recent version of te JDBC driver. It's working now.

Re: Required character converter is not available.

Anonymous — Fri, 04 Mar 2016 16:50:38 GMT

Hi Sabrina,
I am getting below error while unloadind data from tDB2Input.
Exception in component tDB2Input_1

com.ibm.db2.jcc.am.SqlException: Caught java.io.CharConversionException. See attached Throwable for details. ERRORCODE=-4220, SQLSTATE=null

at com.ibm.db2.jcc.am.fd.a(fd.java:663)

at com.ibm.db2.jcc.am.fd.a(fd.java:60)

at com.ibm.db2.jcc.am.fd.a(fd.java:112)

at com.ibm.db2.jcc.am.ic.a(ic.java:2314)

at com.ibm.db2.jcc.am.ic.p(ic.java:521)

at com.ibm.db2.jcc.am.ic.N(ic.java:1525)

at com.ibm.db2.jcc.am.nn.e(nn.java:1147)

at com.ibm.db2.jcc.am.nn.getString(nn.java:1122)

at rpa_med.rpa_test_job_0_1.RPA_Test_Job.tDB2Input_1Process(RPA_Test_Job.java:6539)

at rpa_med.rpa_test_job_0_1.RPA_Test_Job.tDB2Connection_1Process(RPA_Test_Job.java:5292)

at rpa_med.rpa_test_job_0_1.RPA_Test_Job.tSystem_1Process(RPA_Test_Job.java:5140)

at rpa_med.rpa_test_job_0_1.RPA_Test_Job.tJava_3Process(RPA_Test_Job.java:4960)

at rpa_med.rpa_test_job_0_1.RPA_Test_Job.tJava_2Process(RPA_Test_Job.java:4848)

at rpa_med.rpa_test_job_0_1.RPA_Test_Job.runJobInTOS(RPA_Test_Job.java:8478)

at rpa_med.rpa_test_job_0_1.RPA_Test_Job.main(RPA_Test_Job.java:7253)

Caused by: java.nio.charset.MalformedInputException: Input length = 13099

at com.ibm.db2.jcc.am.t.a(t.java:19)

at com.ibm.db2.jcc.am.ic.a(ic.java:2310)

... 11 more

Caused by: sun.io.MalformedInputException

at sun.io.ByteToCharUTF8.convert(ByteToCharUTF8.java:167)

at com.ibm.db2.jcc.am.t.a(t.java:16)

... 12 more

Re: Required character converter is not available.

Anonymous — Mon, 06 Jun 2016 11:00:16 GMT

Hi DaniM
Can you please set me the link for JDBC Driver class, I am also getting error
Connection failure. You must change the Database Settings.
com.ibm.db2.jcc.b.SqlException: Required character converter is not available. ERRORCODE=-4220, SQLSTATE=null
      at com.ibm.db2.jcc.b.wc.a(wc.java:55)
      at com.ibm.db2.jcc.b.wc.a(wc.java:119)
      at com.ibm.db2.jcc.b.bc.a(bc.java:1758)
      at com.ibm.db2.jcc.b.bc.n(bc.java:496)
      at com.ibm.db2.jcc.b.bc.F(bc.java:1263)
      at com.ibm.db2.jcc.b.jk.d(jk.java:939)
      at com.ibm.db2.jcc.b.jk.getString(jk.java:917)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.checkSchemaConnection(ExtractMetaDataFromDataBase.java:387)
      at org.talend.core.model.metadata.builder.database.ExtractMetaDataFromDataBase.testConnection(ExtractMetaDataFromDataBase.java:330)
      at org.talend.metadata.managment.repository.ManagerConnection.check(ManagerConnection.java:272)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:2674)
      at org.talend.repository.ui.wizards.metadata.connection.database.DatabaseForm$31.runWithCancel(DatabaseForm.java:1)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$1.runnableWithCancel(AProgressMonitorDialogWithCancel.java:77)
      at org.talend.repository.ui.dialog.AProgressMonitorDialogWithCancel$ARunnableWithProgressCancel$1.call(AProgressMonitorDialogWithCancel.java:161)
      at java.util.concurrent.FutureTask.run(Unknown Source)
      at java.lang.Thread.run(Unknown Source)
Thanks
Anil Kumar Burri

Re: Required character converter is not available.

Anonymous — Tue, 07 Jun 2016 12:35:26 GMT

Hi
Looking for help on above post, I can able to retrieve database using input component but when I am trying to load using tDB2Ouput unable to load.
thanks
Anil Kumar Buri

Re: Required character converter is not available.

Anonymous — Tue, 07 Jun 2016 12:54:31 GMT

Thank you
I can able to resolve this issue, by appliying relevant jar modules.
thanks
Anil Kumar Burri

Re: Required character converter is not available.

Anonymous — Wed, 25 Apr 2018 09:22:26 GMT

Hallo,

could you please share your solution - we have the same issue and not able to fix it.

Thanks a lot,

Als

Re: Required character converter is not available.

Anonymous — Sat, 28 Apr 2018 06:58:50 GMT

Hello,

Could you please refer to this online document about:TalendHelpCenter:Installing external modules?

Best regards

Sabrina

Re: Required character converter is not available.

Anonymous — Wed, 02 May 2018 11:22:15 GMT

Hallo,

just to summarize - I have updated Talend to the latest version. I have used the external modules approach to add my own latest DB2 drivers - now it works.

Thanks a lot,

Als

Re: Required character converter is not available.

Anonymous — Thu, 03 May 2018 07:40:52 GMT

Hello,

Thanks for sharing your solution on forum.

Best regards

Sabrina