0 Replies Latest reply: Aug 26, 2014 1:51 PM by Khadka RSS

    Unable to create XML output in ODI 12c?

    Khadka

      Hello All,

       

      I am trying to load data from integrate data from Oracle DB and create xml output.

       

      Steps

      i)  Reverse engineered XSD file and create Model.

      ii) Created mapping between oracle db as source and xsd model as target

      iii) Use knowledge module LKM SQL to SQL and IKM XML Control Append

       

      Errors out - Load Default_AP LKM SQL to SQL

       

      Error message

       

      ava.lang.StringIndexOutOfBoundsException: String index out of range: -1

          at java.lang.AbstractStringBuilder.delete(AbstractStringBuilder.java:694)

          at java.lang.StringBuffer.delete(StringBuffer.java:369)

          at com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.manageQuotes(SnpsXmlConnection.java:1000)

          at com.sunopsis.jdbc.driver.xml.SnpsXmlConnection.prepareStatement(SnpsXmlConnection.java:1234)

          at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

          at java.lang.reflect.Method.invoke(Method.java:606)

          at oracle.odi.core.datasource.dwgobject.support.OnConnectOnDisconnectDataSourceAdapter$OnDisconnectCommandExecutionHandler.invoke(OnConnectOnDisconnectDataSourceAdapter.java:231)

          at com.sun.proxy.$Proxy19.prepareStatement(Unknown Source)

          at sun.reflect.GeneratedMethodAccessor68.invoke(Unknown Source)

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

          at java.lang.reflect.Method.invoke(Method.java:606)

          at com.sunopsis.sql.SnpsConnection$ConnectionProxyInvocationHandler.invoke(SnpsConnection.java:141)

          at com.sun.proxy.$Proxy23.prepareStatement(Unknown Source)

          at oracle.odi.runtime.agent.execution.sql.SQLCommand.doInitializeStatement(SQLCommand.java:104)

          at oracle.odi.runtime.agent.execution.sql.SQLCommand.getStatement(SQLCommand.java:147)

          at oracle.odi.runtime.agent.execution.sql.SQLCommand.getBatchCommand(SQLCommand.java:388)

          at oracle.odi.runtime.agent.execution.sql.SQLCommand.processRecord(SQLCommand.java:167)

          at oracle.odi.runtime.agent.execution.sql.SQLCommand.processRecord(SQLCommand.java:37)

          at oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:127)

          at oracle.odi.runtime.agent.execution.SessionTask.processTask(SessionTask.java:214)

          at oracle.odi.runtime.agent.execution.SessionTask.doExecuteTask(SessionTask.java:135)

          at oracle.odi.runtime.agent.execution.AbstractSessionTask.execute(AbstractSessionTask.java:856)

          at oracle.odi.runtime.agent.execution.SessionExecutor$SerialTrain.runTasks(SessionExecutor.java:2004)

          at oracle.odi.runtime.agent.execution.SessionExecutor.executeSession(SessionExecutor.java:544)

          at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:709)

          at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor$1.doAction(TaskExecutorAgentRequestProcessor.java:624)

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

          at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doProcessStartAgentTask(TaskExecutorAgentRequestProcessor.java:789)

          at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:330)

          at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$2700(StartSessRequestProcessor.java:80)

          at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:957)

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

          at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:110)

          at java.lang.Thread.run(Thread.java:745)

       

       

      Any idea GURUS