Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI error loading form delimited file(utf08) to informix on db2 repository

Ace-JinNov 4 2010 — edited Nov 4 2010

Hi, all.

I have big trouble......

I used ODI 10.1.3.5 on AIX. and ODI used DB2 9.5 for repository.

When a session start, that sorce is delimited file(UTF-8) and Target is a informix table, I got a error.

-99999 : null : com.ibm.db2.jcc.c.yi: [ibm][db2][jcc][102][10040] Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched elements.-302 : 22001 : com.ibm.db2.jcc.c.SqlException: Error for batch element #1: DB2 SQL error: SQLCODE: -302, SQLSTATE: 22001, SQLERRMC: null
com.ibm.db2.jcc.c.yi: [ibm][db2][jcc][102][10040] Non-atomic batch failure. The batch was submitted, but at least one exception occurred on an individual member of the batch.
Use getNextException() to retrieve the exceptions for specific batched elements.
at com.ibm.db2.jcc.c.p.a(p.java:455)
at com.ibm.db2.jcc.c.sh.a(sh.java:2831)
at com.ibm.db2.jcc.c.sh.b(sh.java:2664)
at com.ibm.db2.jcc.c.sh.executeBatch(sh.java:1501)
at com.sunopsis.sql.SnpsQuery.executeBatch(SnpsQuery.java)
at com.sunopsis.dwg.dbobj.SnpExpTxt.setString(SnpExpTxt.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskLog.saveText(SnpSessTaskLog.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskLog.updateBeforeAction(SnpSessTaskLog.java)
at com.sunopsis.dwg.DwgObject.update(DwgObject.java)
at com.sunopsis.dwg.DwgObject.update(DwgObject.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskPostTrt(SnpSessTaskSql.java)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java)
at com.sunopsis.dwg.cmd.DwgCommandSession.treatCommand(DwgCommandSession.java)
at com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)
at com.sunopsis.dwg.cmd.e.i(e.java)
at com.sunopsis.dwg.cmd.h.y(h.java)
at com.sunopsis.dwg.cmd.e.run(e.java)
at java.lang.Thread.run(Thread.java:810)

....plz . help me.

Edited by: JinMaRyong on 2010. 11. 4 오후 7:06

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 2 2010

Added on Nov 4 2010

#business-intelligence-applications, #data-integrator, #file, #odi, #system-management-and-integration

0 comments

252 views