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

[Anonymous]

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]

[Anonymous]

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

[Franz3]

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

[Anonymous]

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

[Anonymous]

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 .

[Anonymous]

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]