1 2 Previous Next 15 Replies Latest reply on Oct 27, 2014 9:32 AM by AH R

    Load Mapping Error with ODI Agent

    AH R

      Hi

      I am trying to upload mapping in ERPi but getting this error with odi agent:

      ODI-1228: Task 36501 (Integration) fails on the target GENERIC_SQL connection AIF_DS36501.

      ODI-1228: Task 36501 (Integration) fails on the target GENERIC_SQL connection AIF_DS36501.

      Caused By: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

       

          at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

          at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

          at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

          at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

          at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

          at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

          at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

          at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

          at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

          at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

          at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)

          at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)

          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 com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1889)

          at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

          at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

          at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

          at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1066)

          at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

          at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

          at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

          at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

          at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

          at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

          at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)

          at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:512)

          at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:442)

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

          at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)

          at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)

          at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)

          at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)

          at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)

          at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)

          at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)

          at org.mortbay.jetty.Server.handle(Server.java:326)

          at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)

          at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:879)

          at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)

          at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)

          at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)

          at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)

          at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)

       

      Please can any body help me to solve this.I have attached screen shot as well.

      Error in agent sessions.png

      Regards.

       

      Asad Hussain

        • 1. Re: Load Mapping Error with ODI Agent
          AH R

          I am highlighting the error code portion from odi agent log file.

           

           

          [2014-10-21T15:03:12.564+05:00] [] [NOTIFICATION] [ODI-1128] [] [tid: 10] [ecid: 0000K^mAGtbFS8WFLzATOA1KHYxV000001,0] Agent odi_agent is starting. Application Server: STANDALONE. Agent Version: 11.1.1.6.0 - 19/12/2011. Port: 20910. JMX Port: 21910.

          [2014-10-21T15:03:17.712+05:00] [] [NOTIFICATION] [ODI-1136] [] [tid: 10] [ecid: 0000K^mAGtbFS8WFLzATOA1KHYxV000001,0] Starting Schedulers on Agent odi_agent.

          [2014-10-21T15:03:18.133+05:00] [] [NOTIFICATION] [ODI-1111] [] [tid: 10] [ecid: 0000K^mAGtbFS8WFLzATOA1KHYxV000001,0] Agent odi_agent started. Agent version: 11.1.1.6.0 - 19/12/2011. Port: 20910. JMX Port: 21910.

          [2014-10-21T15:03:18.414+05:00] [] [NOTIFICATION] [ODI-1137] [] [tid: 11] [ecid: 0000K^mAGtbFS8WFLzATOA1KHYxV000001,0:41] Scheduler started for work repository ODI_WORK_REPOSITORY on Agent odi_agent.

          [2014-10-21T15:03:18.414+05:00] [odi] [NOTIFICATION:16] [ODI-2002] [oracle.odi.agent.scheduler] [tid: 11] [ecid: 0000K^mAGtbFS8WFLzATOA1KHYxV000001,0:41] Agent is in scheduling mode

          [2014-10-21T15:03:18.414+05:00] [odi] [NOTIFICATION:16] [ODI-2003] [oracle.odi.agent.scheduler] [tid: 11] [ecid: 0000K^mAGtbFS8WFLzATOA1KHYxV000001,0:41] Number of items for scheduled executions: 2

          [2014-10-21T15:03:28.510+05:00] [] [NOTIFICATION:16] [ODI-1100] [] [tid: 12] [ecid: 0000K^mAKuoFS8WFLzATOA1KHYxV00000P,0] Agent odi_agent successfully cleaned up 0 stale sessions from work repository ODI_WORK_REPOSITORY.

          [2014-10-21T15:04:27.926+05:00] [] [NOTIFICATION:16] [ODI-1125] [] [tid: 14] [ecid: 0000K^mAZGEFS8WFLzATOA1KHYxV00000Q,0] Agent odi_agent started session IMPORT_EXPORT36501 (55501) from scenario IMPORT_EXPORT36501 in work repository ODI_WORK_REPOSITORY using context 36501.

          [2014-10-21T15:04:33.215+05:00] [odi] [WARNING] [] [oracle.odi.agent] [tid: 14] [ecid: 0000K^mAZGEFS8WFLzATOA1KHYxV00000Q,0] THROW[[

          com.sunopsis.jdbc.driver.file.redir.NotImplementedException

              at com.sunopsis.jdbc.driver.file.redir.FileConnection.rollback(FileConnection.java:59)

              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

              at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

              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 com.sun.proxy.$Proxy39.rollback(Unknown Source)

              at com.sunopsis.dwg.dbobj.SnpSession.rollbackAllTansactions(SnpSession.java:3468)

              at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2227)

              at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1889)

              at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

              at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

              at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

              at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1066)

              at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

              at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

              at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

              at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

              at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

              at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

              at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)

              at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:512)

              at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:442)

              at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

              at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

              at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)

              at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)

              at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)

              at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)

              at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)

              at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)

              at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)

              at org.mortbay.jetty.Server.handle(Server.java:326)

              at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)

              at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:879)

              at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)

              at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)

              at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)

              at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)

              at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)

           

          ]]

          [2014-10-21T15:04:33.230+05:00] [] [ERROR] [ODI-1217] [] [tid: 14] [ecid: 0000K^mAZGEFS8WFLzATOA1KHYxV00000Q,0] Session IMPORT_EXPORT36501 (55501) fails with return code 933.[[

          ODI-1226: Step Load mappings fails after 1 attempt(s).

          ODI-1240: Flow Load mappings fails while performing a Integration operation. This flow loads target table TDATAMAP_T.

          ODI-1228: Task 36501 (Integration) fails on the target GENERIC_SQL connection AIF_DS36501.

          Caused By: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

           

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

              at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

              at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

              at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)

              at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)

              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 com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1889)

              at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

              at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

              at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

              at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1066)

              at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

              at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

              at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

              at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

              at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

              at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

              at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)

              at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:512)

              at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:442)

              at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

              at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

              at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)

              at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)

              at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)

              at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)

              at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)

              at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)

              at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)

              at org.mortbay.jetty.Server.handle(Server.java:326)

              at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)

              at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:879)

              at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)

              at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)

              at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)

              at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)

              at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)

           

          ]]

          [2014-10-21T15:04:33.464+05:00] [] [ERROR] [ODI-1134] [] [tid: 14] [ecid: 0000K^mAZGEFS8WFLzATOA1KHYxV00000Q,0] Agent odi_agent encountered an error: ODI-1217: Session IMPORT_EXPORT36501 (55501) fails with return code 933. Caused by: ODI-1226: Step Load mappings fails after 1 attempt(s).[[

          ODI-1217: Session IMPORT_EXPORT36501 (55501) fails with return code 933.

          ODI-1226: Step Load mappings fails after 1 attempt(s).

          ODI-1240: Flow Load mappings fails while performing a Integration operation. This flow loads target table TDATAMAP_T.

          ODI-1228: Task 36501 (Integration) fails on the target GENERIC_SQL connection AIF_DS36501.

          Caused By: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

           

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

              at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

              at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

              at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)

              at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)

              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 com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1889)

              at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

              at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

              at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

              at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1066)

              at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

              at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

              at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

              at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

              at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

              at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

              at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)

              at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:512)

              at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:442)

              at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

              at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

              at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)

              at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)

              at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)

              at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)

              at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)

              at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)

              at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)

              at org.mortbay.jetty.Server.handle(Server.java:326)

              at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)

              at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:879)

              at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)

              at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)

              at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)

              at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)

              at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)

           

          ]]

          • 3. Re: Load Mapping Error with ODI Agent
            Srini Chavali-Oracle

            I do not have any ODI experience, but the issue seems to be with malformed SQL

             

            Caused By: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
            • 4. Re: Load Mapping Error with ODI Agent
              SH_INT

              You need to investigate the error step in ODI. The error message is telling you quite explicitly that there is a problem with the SQL statement trying to perform the insert into the  TDATAMAP_T table so you need to look at the SQL statement to debug. Navigate to the failed step 8 - Insert New Rows in the ODI operator and select the Code tab n the main window to view the Insert statement. From that it should be possible to debug the root cause of the error 

              • 5. Re: Load Mapping Error with ODI Agent
                900736

                what is the source and target? Is mapping file has right format? (sometimes if file has issues you may encounter problem), pls give bit detailed so that it's easy to understand.

                 

                Did you try to do map manually and load data? you can test that for 1 or 2 records, just try to map manually and try load data if it's working, then its issue with completely import, then do it thru file with only 1/2 maps in the file and try import for the same location..see how it works and check the logs.

                 

                Also as SH mentioned, check out the SQL code in ODI logs (step where it failed) and it's easy to debug...


                • 6. Re: Load Mapping Error with ODI Agent
                  AH R

                  Thanks SH for reply.

                  I would like to tell you that these queries are automatically generated by ODI.

                  Can you please tell me how to solve this.

                   

                  Thanks

                  • 7. Re: Load Mapping Error with ODI Agent
                    AH R

                    Thanks for reply.

                    Yes I have done this manually by entering 1/2 maps without file.It works fine and can fetch data.

                    I can't upload mapping file. Similarly I can't download mapping in the form of .csv file as its giving me an empty .csv file.

                    • 8. Re: Load Mapping Error with ODI Agent
                      SH_INT

                      A couple of points:

                       

                      1) You have 2 threads open on this forum for the same issue, please close one to avoid duplication of effort

                      2)  Yes, the queries are automatically generated by ODI, but the root cause of the failure is still in the SQL Select statement. You have to look at this in the first instance to see what may be causing the error. More than likely it will point to something happening outside of the ODI process

                       

                      Paste the content of the SQL query into this thread from the error step I mentioned in my previous post or you are not going to get very far with resolving this problem as no one will miraculously be able to tell you how to solve this without following the basic debugging steps requested. You have all the information to solve this at your disposal, we do not. 

                      • 9. Re: Load Mapping Error with ODI Agent
                        AH R

                        Yes I'll talk on this thread only.

                        Contents of SQL query:

                         

                         

                        INSERT INTO    HYPERION.TDATAMAP_T

                        ( PARTITIONKEY,

                            DIMNAME,

                            SRCKEY,

                            SRCDESC,

                            TARGKEY,

                            WHERECLAUSETYPE,

                            WHERECLAUSEVALUE,

                            CHANGESIGN,

                            VBSCRIPT,

                            TDATAMAPTYPE

                            ,LOADID,

                            DATAKEY,

                            SYSTEM_GENERATED_FLAG,

                            VALID_FLAG

                        )

                         

                        SELECT

                            PARTITIONKEY,

                            DIMNAME,

                            SRCKEY,

                            SRCDESC,

                            TARGKEY,

                            WHERECLAUSETYPE,

                            WHERECLAUSEVALUE,

                            CHANGESIGN,

                            VBSCRIPT,

                            TDATAMAPTYPE  

                          ,204,

                            1,

                            'N',

                            'Y'

                        FROM ( SELECT     DISTINCT

                            CASE WHEN C1_SRCKEY IS NULL THEN 11 ELSE 11 END PARTITIONKEY,

                            CASE WHEN C1_SRCKEY IS NULL THEN 'ENTITY' ELSE 'ENTITY' END DIMNAME,

                            CASE WHEN C1_SRCKEY LIKE '#MULTIDIM%' THEN  COALESCE( C2_NAME, 'MULTIDIM' )

                          WHEN  C1_SRCKEY LIKE '%*%' OR C1_SRCKEY LIKE '%?%' OR C1_SRCKEY LIKE '%<1>%' OR C1_SRCKEY LIKE '%<2>%' OR C1_SRCKEY LIKE '%<3>%'   OR C1_SRCKEY LIKE '%<4>%' OR  C1_SRCKEY LIKE '%<5>%' OR lower( C1_SRCKEY  ) LIKE '%<blank>%' OR  C1_SRCKEY LIKE '%>%' THEN

                        COALESCE( C2_NAME,C1_SRCKEY )

                        ELSE

                          C1_SRCKEY

                        END SRCKEY,

                            CASE WHEN  ( C1_SRCKEY LIKE '%*%' OR C1_SRCKEY LIKE '%?%' OR C1_SRCKEY LIKE '%<1>%' OR C1_SRCKEY LIKE '%<2>%' OR C1_SRCKEY LIKE '%<3>%' OR  C1_SRCKEY LIKE '%<4>%' OR C1_SRCKEY LIKE '%<5>%' OR lower( C1_SRCKEY  ) LIKE '%<blank>%' OR  C1_SRCKEY LIKE '%>%' OR  C1_SRCKEY LIKE '#MULTIDIM%'  )  THEN

                              C3_SRCDESC

                          ELSE

                             COALESCE( C3_SRCDESC, C2_NAME  )

                          END SRCDESC,

                            CASE WHEN C4_TARGKEY LIKE '-%' THEN SUBSTR( C4_TARGKEY ,2,LENGTH( C4_TARGKEY  )-1 ) ELSE  C4_TARGKEY  END TARGKEY,

                            CASE WHEN  C1_SRCKEY  LIKE '#MULTIDIM%' THEN 'MULTIDIM'

                        WHEN  C1_SRCKEY  LIKE '%*%' OR  C1_SRCKEY  LIKE '%?%' OR  C1_SRCKEY  LIKE '%<1>%' OR  C1_SRCKEY  LIKE '%<2>%' OR  C1_SRCKEY  LIKE '%<3>%' OR  C1_SRCKEY  LIKE '%<4>%' OR  C1_SRCKEY  LIKE '%<5>%' OR  lower( C1_SRCKEY )  LIKE '%<blank>%'  THEN 'LIKE' WHEN   C1_SRCKEY  LIKE '%>%'  THEN 'BETWEEN'  ELSE null END WHERECLAUSETYPE,

                            CASE WHEN  C1_SRCKEY  LIKE '#MULTIDIM%' THEN null

                        WHEN C1_SRCKEY  LIKE '%*%' OR  C1_SRCKEY  LIKE '%?%' OR  C1_SRCKEY  LIKE '%<1>%' OR  C1_SRCKEY  LIKE '%<2>%' OR  C1_SRCKEY  LIKE '%<3>%' OR  C1_SRCKEY  LIKE '%<4>%' OR  C1_SRCKEY  LIKE '%<5>%' OR  lower( C1_SRCKEY )  LIKE '%<blank>%'   THEN  C1_SRCKEY  WHEN   C1_SRCKEY  LIKE '%>%' THEN REPLACE( C1_SRCKEY ,'>',',' ) ELSE null END WHERECLAUSEVALUE,

                            CASE WHEN C4_TARGKEY LIKE '-%' THEN 1 ELSE  0  END CHANGESIGN,

                            CASE WHEN C1_SRCKEY LIKE '#MULTIDIM%' THEN  rtrim( ltrim( REPLACE( C1_SRCKEY , '#MULTIDIM', '' ) ) )

                          ELSE

                          null

                        END VBSCRIPT,

                            CASE WHEN C1_SRCKEY IS NULL THEN 'ERP' ELSE 'ERP' END TDATAMAPTYPE

                        FROM    HYPERION."C$_555010TDATAMAP_T"

                        WHERE        ( 1=1 )   

                         

                        AND ( C1_SRCKEY IS NOT NULL AND C4_TARGKEY IS NOT NULL AND C1_SRCKEY <> ' ' AND C4_TARGKEY <> ' ' )

                         

                         

                         

                         

                        )  as  ODI_GET_FROM

                        • 10. Re: Load Mapping Error with ODI Agent
                          AH R

                          Error Message:

                           

                          ODI-1228: Task 36501 (Integration) fails on the target GENERIC_SQL connection AIF_DS36501.

                          Caused By: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended

                           

                              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)

                              at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)

                              at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)

                              at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)

                              at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)

                              at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)

                              at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)

                              at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1115)

                              at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)

                              at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)

                              at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)

                              at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)

                              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 com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1889)

                              at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)

                              at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)

                              at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)

                              at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1066)

                              at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)

                              at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:49)

                              at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:49)

                              at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:41)

                              at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:92)

                              at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:83)

                              at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:68)

                              at oracle.odi.runtime.agent.servlet.AgentServlet.processRequest(AgentServlet.java:512)

                              at oracle.odi.runtime.agent.servlet.AgentServlet.doPost(AgentServlet.java:442)

                              at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

                              at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

                              at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:502)

                              at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:389)

                              at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)

                              at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)

                              at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:765)

                              at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:417)

                              at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)

                              at org.mortbay.jetty.Server.handle(Server.java:326)

                              at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:534)

                              at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:879)

                              at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:747)

                              at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)

                              at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)

                              at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)

                              at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:520)

                          • 11. Re: Load Mapping Error with ODI Agent
                            AH R

                            I have uploaded error message and contents of SQL query.

                             

                            Can you help me with this?

                            • 12. Re: Load Mapping Error with ODI Agent
                              John Pak

                              Please provide a copy of your mapping template.  I'll try to load it in on my test machine.

                              • 13. Re: Load Mapping Error with ODI Agent
                                Francisco Amores

                                hi

                                when I read someone has an error importimy mappings I would like to see the mappings indeed.

                                hhow many mappinga are you importing?

                                try to isolate: import only one mapping, is it failing?

                                it seems to be related to mapping syntax but we would need to see how your mappings look like.

                                thanks

                                • 14. Re: Load Mapping Error with ODI Agent
                                  AH R

                                  This is the file that I am trying to upload.Please check it on your test machine.

                                   

                                  https://drive.google.com/a/mcs.edu.pk/folderview?id=0B8ZeIQKiuaPGeW05WnlfRHFJMDA&usp=sharing

                                   

                                  Thanks

                                  1 2 Previous Next