1 2 Previous Next 20 Replies Latest reply on May 27, 2013 12:03 PM by DecaXD Go to original post
      • 15. Re: ODI ERROR: While Executing the interface

        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
          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
            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

            • 18. Re: ODI ERROR: While Executing the interface
              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
                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

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