Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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]
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]
at datamigration.newmylist_0_1.newmylist.tInformixInput_1Process(newmylist.java:1134)