1 Reply Latest reply: Feb 7, 2013 11:56 AM by 984330 RSS

    ODI-12227: Task SrcSet0 (Loading) fails on the source ORACLE connection ...

    984330
      Hi,

      when exexcuted the interface I get this message:

      ODI-12227: Task SrcSet0 (Loading) fails on the source ORACLE connection DS_INSITE.
      Caused By: java.sql.SQLException: Missing IN or OUT parameter at index:: 1

      ODI-1227: Fallo en la tarea SrcSet0 (Carga) en el origen ORACLE conexión DS_INSITE.
      Caused By: java.sql.SQLException: Falta el parámetro IN o OUT en el índice:: 1
           at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
           at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:199)
           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:263)
           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:271)
           at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1737)
           at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3381)
           at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3430)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
           at com.sunopsis.sql.SnpsQuery.executeQuery(SnpsQuery.java:602)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeQuery(SnpSessTaskSql.java:3078)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execCollOrders(SnpSessTaskSql.java:571)
           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)

      Please, if somebody could give me a tip. Thanks!!!
        • 1. Re: ODI-12227: Task SrcSet0 (Loading) fails on the source ORACLE connection ...
          984330
          I'm using the LKM SQL to Oracle...

          The command Load data generates the following code:

          BeanShell script error: Sourced file: inline evaluation of: ``for (int i=odiRef.getDataSetMin(); i <= odiRef.getDataSetMax(); i++){out.print(" . . . '' : Typed variable declaration : Error in method invocation: Method getDataSetMin() not found in class'com.sunopsis.dwg.snpreference.SnpReferenceInterne' : at Line: 1 : in file: inline evaluation of: ``for (int i=odiRef.getDataSetMin(); i <= odiRef.getDataSetMax(); i++){out.print(" . . . '' : odiRef .getDataSetMin ( )
          BSF info: Load data at line: 0 column: columnNo
          for (int i=odiRef.getDataSetMin(); i <= odiRef.getDataSetMax(); i++){out.print("\n") ;
          out.print(odiRef.getDataSet(i, "Operator")) ;
          out.print("\nselect\t") ;
          out.print(odiRef.getPop("DISTINCT_ROWS")) ;
          out.print("\n\t") ;
          out.print(odiRef.getColList(i, "", "[EXPRESSION]\\t[ALIAS_SEP] [CX_COL_NAME]", ",\\n\\t", "", "")) ;
          out.print("\nfrom\t") ;
          out.print(odiRef.getFrom(i)) ;
          out.print("\nwhere\t(1=1)\n") ;
          out.print(odiRef.getFilter(i)) ;
          out.print("\n") ;
          out.print(odiRef.getJrnFilter(i)) ;
          out.print("\n") ;
          out.print(odiRef.getJoin(i)) ;
          out.print("\n") ;
          out.print(odiRef.getGrpBy(i)) ;
          out.print("\n") ;
          out.print(odiRef.getHaving(i)) ;
          out.print("\n") ;
          }out.print("\n") ;

          ****** ORIGINAL TEXT ******
          <%for (int i=odiRef.getDataSetMin(); i <= odiRef.getDataSetMax(); i++){%>
          <%=odiRef.getDataSet(i, "Operator")%>
          select     <%=odiRef.getPop("DISTINCT_ROWS")%>
               <%=odiRef.getColList(i, "", "[EXPRESSION]\t[ALIAS_SEP] [CX_COL_NAME]", ",\n\t", "", "")%>
          from     <%=odiRef.getFrom(i)%>
          where     (1=1)
          <%=odiRef.getFilter(i)%>
          <%=odiRef.getJrnFilter(i)%>
          <%=odiRef.getJoin(i)%>
          <%=odiRef.getGrpBy(i)%>
          <%=odiRef.getHaving(i)%>
          <%}%>