Reject option is not working-Talend Open Studio-Data Integration 6.1.1

Anonymous — Fri, 08 Jul 2016 06:20:54 GMT

Hi Team,
I am trying to reject the data on error after configuring the settings as given in the screenshots.Also I am explaining the steps which I have followed.But I am not able to find the error data.I have reffered the URL -
Unchecked the die on error check box in tmap component
[list=1]

Made the output catch output reject --> true

Made the catch lookup inner join reject --> true

Added the column which needs to be displayed in the error log

Applied the changes

Added a new component tlogrow and given the errorReject option to this component from tmap

I am trying to catch the below error while migrating data from informix to oracle DB .
[statistics] connecting to socket on port 3359
[statistics] connected
java.io.IOException: Code-set conversion function failed due to illegal sequence or invalid value.
at com.informix.lang.JavaToIfxType.doConversion(JavaToIfxType.java:845)
at com.informix.lang.JavaToIfxType.JavaToIfxChar(JavaToIfxType.java:145)
at com.informix.jdbc.IfxVarChar.toString(IfxVarChar.java:247)
at com.informix.jdbc.IfxResultSet.getString(IfxResultSet.java:742)
at routines.system.JDBCUtil.getString(JDBCUtil.java:21)
at datamigration.newmylist_0_1.newmylist.tInformixInput_1Process(newmylist.java:1134)
at datamigration.newmylist_0_1.newmylist.runJobInTOS(newmylist.java:1944)
at datamigration.newmylist_0_1.newmylist.main(newmylist.java:1653)
java.io.IOException: Code-set conversion function failed due to illegal sequence or invalid value.
at com.informix.lang.JavaToIfxType.doConversion(JavaToIfxType.java:845)
at com.informix.lang.JavaToIfxType.JavaToIfxChar(JavaToIfxType.java:145)
at com.informix.jdbc.IfxVarChar.toString(IfxVarChar.java:247)
at com.informix.jdbc.IfxResultSet.getString(IfxResultSet.java:742)
at routines.system.JDBCUtil.getString(JDBCUtil.java:21)
at datamigration.newmylist_0_1.newmylist.tInformixInput_1Process(newmylist.java:1134)
at datamigration.newmylist_0_1.newmylist.runJobInTOS(newmylist.java:1944)
at datamigration.newmylist_0_1.newmylist.main(newmylist.java:1653)
java.io.IOException: Code-set conversion function failed due to illegal sequence or invalid value.
at com.informix.lang.JavaToIfxType.doConversion(JavaToIfxType.java:845)
at com.informix.lang.JavaToIfxType.JavaToIfxChar(JavaToIfxType.java:145)
at com.informix.jdbc.IfxVarChar.toString(IfxVarChar.java:247)
at com.informix.jdbc.IfxResultSet.getString(IfxResultSet.java:742)
at routines.system.JDBCUtil.getString(JDBCUtil.java:21)
at datamigration.newmylist_0_1.newmylist.tInformixInput_1Process(newmylist.java:1134)
at datamigration.newmylist_0_1.newmylist.runJobInTOS(newmylist.java:1944)
at datamigration.newmylist_0_1.newmylist.main(newmylist.java:1653)
java.io.IOException: Code-set conversion function failed due to illegal sequence or invalid value.
at com.informix.lang.JavaToIfxType.doConversion(JavaToIfxType.java:845)
at com.informix.lang.JavaToIfxType.JavaToIfxChar(JavaToIfxType.java:145)
at com.informix.jdbc.IfxVarChar.toString(IfxVarChar.java:247)
at com.informix.jdbc.IfxResultSet.getString(IfxResultSet.java:742)
at routines.system.JDBCUtil.getString(JDBCUtil.java:21)
at datamigration.newmylist_0_1.newmylist.tInformixInput_1Process(newmylist.java:1134)
at datamigration.newmylist_0_1.newmylist.runJobInTOS(newmylist.java:1944)
at datamigration.newmylist_0_1.newmylist.main(newmylist.java:1653)
java.io.IOException: Code-set conversion function failed due to illegal sequence or invalid value.
at com.informix.lang.JavaToIfxType.doConversion(JavaToIfxType.java:845)
at com.informix.lang.JavaToIfxType.JavaToIfxChar(JavaToIfxType.java:145)
at com.informix.jdbc.IfxVarChar.toString(IfxVarChar.java:247)
at com.informix.jdbc.IfxResultSet.getString(IfxResultSet.java:742)
at routines.system.JDBCUtil.getString(JDBCUtil.java:21)
at datamigration.newmylist_0_1.newmylist.tInformixInput_1Process(newmylist.java:1134)
at datamigration.newmylist_0_1.newmylist.runJobInTOS(newmylist.java:1944)
at datamigration.newmylist_0_1.newmylist.main(newmylist.java:1653)
java.io.IOException: Code-set conversion function failed due to illegal sequence or invalid value.
at com.informix.lang.JavaToIfxType.doConversion(JavaToIfxType.java:845)
at com.informix.lang.JavaToIfxType.JavaToIfxChar(JavaToIfxType.java:145)
at com.informix.jdbc.IfxVarChar.toString(IfxVarChar.java:247)
at com.informix.jdbc.IfxResultSet.getString(IfxResultSet.java:742)
at routines.system.JDBCUtil.getString(JDBCUtil.java:21)
at datamigration.newmylist_0_1.newmylist.tInformixInput_1Process(newmylist.java:1134)
at datamigration.newmylist_0_1.newmylist.runJobInTOS(newmylist.java:1944)
at datamigration.newmylist_0_1.newmylist.main(newmylist.java:1653)
[statistics] disconnected
Job newmylist ended at 10:23 08/07/2016. [exit code=0]

Re: Reject option is not working-Talend Open Studio-Data Integration 6.1.1

Anonymous — Fri, 08 Jul 2016 08:56:31 GMT

Hi
Make sure the 'Use batch size' box is unchecked in the advanced settings panel of tOracleOutput if you want to use the reject link.

Regards
Shong

Re: Reject option is not working-Talend Open Studio-Data Integration 6.1.1

Franz3 — Fri, 08 Jul 2016 09:54:51 GMT

Hi, i can t have the reject output in Mssql_output and i don t see 'Use batch size' in Advanced setting, am i missing something?
version 6.1.1

Re: Reject option is not working-Talend Open Studio-Data Integration 6.1.1

Anonymous — Fri, 08 Jul 2016 11:35:48 GMT

Hi Fwandz

The 'Use batch size' box aslo exists in the advanced settings of tMssqlOutput. Can you please upload a screenshot of advanced settings?

Regards
Shong

Re: Reject option is not working-Talend Open Studio-Data Integration 6.1.1

Anonymous — Fri, 08 Jul 2016 11:46:51 GMT

Thanks for the reply.

I have made the use batch size unchecked . Still I ma not able to capture the rejected data. Please help me .

Re: Reject option is not working-Talend Open Studio-Data Integration 6.1.1

Anonymous — Sun, 10 Jul 2016 09:51:48 GMT

The problem is a mismatch between the Java type of a schema column and the actual returned value from the query.
Please run the job again and look in the code section at this line:

at datamigration.newmylist_0_1.newmylist.tInformixInput_1Process(newmylist.java:1134)

perhaps the line number is changed - you will see it in the new stack trace.
Now find out which column is affected (you will see a schema column name assignment at the mentioned line).
[font=Verdana, Helvetica, Arial, sans-serif] Change the Java type of the schema column and try it again.[/font]

topic Re: Reject option is not working-Talend Open Studio-Data Integration 6.1.1 in Talend Studio

Reject option is not working-Talend Open Studio-Data Integration 6.1.1

Re: Reject option is not working-Talend Open Studio-Data Integration 6.1.1

Re: Reject option is not working-Talend Open Studio-Data Integration 6.1.1

Re: Reject option is not working-Talend Open Studio-Data Integration 6.1.1

Re: Reject option is not working-Talend Open Studio-Data Integration 6.1.1

Re: Reject option is not working-Talend Open Studio-Data Integration 6.1.1