Hi,
I am trying to load data from Oracle table to IBM_DB2/400. I have used LKM as I am getting below error message, Can some one help me on this
ODI-1228: Task Store (Integration) fails on the target IBM_DB2_400 connection AS400_JDAMMS.
Caused By: java.sql.SQLException: [FMWGEN][DB2 JDBC Driver][DB2]Error occured with SQLCode -7008 with the
following parameters: I_KHAJAC , AVI , 3, null, null, null, null, null, null, null, null, null, null,
null, null, null, null, null
at weblogic.jdbc.db2base.ddb9.b(Unknown Source)
at weblogic.jdbc.db2base.ddb9.a(Unknown Source)
at weblogic.jdbc.db2base.ddb8.b(Unknown Source)
at weblogic.jdbc.db2base.ddb8.a(Unknown Source)
at weblogic.jdbc.db2.drda.ddn.c(Unknown Source)
at weblogic.jdbc.db2.drda.ddn.a(Unknown Source)
at weblogic.jdbc.db2.drda.ddp.a(Unknown Source)
at weblogic.jdbc.db2.drda.ddj.a(Unknown Source)
at weblogic.jdbc.db2.drda.ddn.b(Unknown Source)
at weblogic.jdbc.db2.ddg.h(Unknown Source)
at weblogic.jdbc.db2base.ddek.e(Unknown Source)
at weblogic.jdbc.db2base.ddek.a(Unknown Source)
at weblogic.jdbc.db2base.ddde.a(Unknown Source)
at weblogic.jdbc.db2base.ddek.v(Unknown Source)
at weblogic.jdbc.db2base.ddek.r(Unknown Source)
at weblogic.jdbc.db2base.ddde.execute(Unknown Source)
at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:163)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:102)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:558)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2093)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction
(StartSessRequestProcessor.java:366)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask
(StartSessRequestProcessor.java:300)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0
(StartSessRequestProcessor.java:292)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute
(StartSessRequestProcessor.java:855)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
at java.lang.Thread.run(Thread.java:736)