This discussion is archived
1 2 Previous Next 20 Replies Latest reply: May 27, 2013 5:03 AM by DecaXD Go to original post RSS
  • 15. Re: ODI ERROR: While Executing the interface
    988501 Newbie
    Currently Being Moderated
    Hi

    I am not able to paste the screen shot in the forum.please let me know how to do.
  • 16. Re: ODI ERROR: While Executing the interface
    Sid_Middleware Explorer
    Currently Being Moderated
    So you have a target called EMP which is excel based data store? What is your source, is it one of those normal RDBMS? Or do you have an RDBMS schema where you can create those C$/I$ tables? If yes, then go to first tab of interface, check the checkbox "Staging Area Different From Target" and choose the required logical schema.

    Now if the problem persists, see if the KM option like "Create Target" is on or not. Turn it off. That should work fine.

    By the way, find an image uploader site through google, upload your image and paste a link here if you want to show a screenshot.
  • 17. Re: ODI ERROR: While Executing the interface
    988501 Newbie
    Currently Being Moderated
    Hi Sid

    Yes i am using source as a RDBMS datastore and target as a Excel Datastore,
    As you mentioned in the previoues post i made the changes but still the issue exist.

    can you please help me.

    KM used

    LKM SQL TO SQL
    and IKM INCREMENTAL UPDATE or IKM SQL CONTROL APPEND


    Regards,
    Anil
  • 18. Re: ODI ERROR: While Executing the interface
    Sid_Middleware Explorer
    Currently Being Moderated
    I assume that you have the error in LKM. After changing the work schema to RDBMS, you still have error at CREATE TABLE step? What is the error? If it is same as the error you pasted in the first post, it means that your changes did not take any effect because if your staging schema was changed, the create C$_ table would have been created in the RDBMS staging schema.

    Paste the error and the SQL code here. Also, did you check if the LKM has Multi-connection enabled or not?
  • 19. Re: ODI ERROR: While Executing the interface
    988501 Newbie
    Currently Being Moderated
    Hi Sid,


    Sorry for the delay.As you mentioned in the previous post please find the below Error,Code.



    Error :

    ODI-1228: Task SrcSet0 (Loading) fails on the target MICROSOFT_EXCEL connection EMP.
    Caused By: java.sql.SQLException: [Microsoft][ODBC Excel Driver] Syntax error in CREATE TABLE statement.
         at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
         at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
         at sun.jdbc.odbc.JdbcOdbc.SQLPrepare(JdbcOdbc.java:4830)
         at sun.jdbc.odbc.JdbcOdbcConnection.prepareStatement(JdbcOdbcConnection.java:475)
         at sun.jdbc.odbc.JdbcOdbcConnection.prepareStatement(JdbcOdbcConnection.java:443)
         at sun.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)
         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
         at java.lang.reflect.Method.invoke(Method.java:597)
         at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter$OnDisconnectCommandExecutionHandler.invoke(OnConnectOnDisconnectDataSourceAdapter.java:200)
         at $Proxy2.prepareStatement(Unknown Source)
         at oracle.odi.runtime.agent.execution.sql.SQLCommand.doInitializeStatement(SQLCommand.java:83)
         at oracle.odi.runtime.agent.execution.sql.SQLCommand.getStatement(SQLCommand.java:117)
         at oracle.odi.runtime.agent.execution.sql.SQLCommand.getStatement(SQLCommand.java:111)
         at oracle.odi.runtime.agent.execution.sql.SQLCommand.execute(SQLCommand.java:158)
         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:662)

    Code :

    create table "C$_0Employee"
    (
         C1_EMPNO     NUMBER(15) ,
         C2_ENAME     VARCHAR(255) ,
         C3_JOB     VARCHAR(255) ,
         C4_MGR     NUMBER(15) ,
         C5_DEPTNO     NUMBER(15)
    )
  • 20. Re: ODI ERROR: While Executing the interface
    DecaXD Pro
    Currently Being Moderated
    HI,

    you need to select in the first tab "Staging area different from target."
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points