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!

how to load data from sysbase to oracle using sysbase odbc drivers??

840494Dec 26 2012 — edited Dec 27 2012

Hi ,

I am trying to create an interface from sysbase to oracle, using LKM sql to orcle and IKM SQL control append, IKM SQL incremental append,CKM oracle . when we are running the interface we are getting below error

com.sunopsis.sql.SnpsMissingParametersException: Missing parameter: C1_WORKGROUP_ID
SQL: insert into ODIUSER.C$_0AGENTLOGINLOGOUT ( C1_WORKGROUP_ID, C2_USER_ID, C3_CREATEDT, C4_UPDATEDT, C5_REASONID, C6_LOGOUTDT, C7_LOGINDT, C8_SERVICE_ID ) values ( :C1_WORKGROUP_ID, :C2_USER_ID, :C3_CREATEDT, :C4_UPDATEDT, :C5_REASONID, :C6_LOGOUTDT, :C7_LOGINDT, :C8_SERVICE_ID )
at com.sunopsis.sql.SnpsQuery.completeHostVariable(SnpsQuery.java:439)
at com.sunopsis.sql.SnpsQuery.updateExecStatement(SnpsQuery.java:1926)
at com.sunopsis.sql.SnpsQuery.addBatch(SnpsQuery.java:122)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeUpdate(SnpSessTaskSql.java:3034)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execCollOrders(SnpSessTaskSql.java:729)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java:2815)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2515)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:534)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:449)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1954)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:322)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:224)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:246)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:237)
at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:794)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:114)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
at java.lang.Thread.run(Thread.java:619)

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 24 2013

Added on Dec 26 2012

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

1 comment

196 views