This discussion is archived
1 Reply Latest reply: Feb 7, 2013 9:56 AM by 984330 RSS

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

984330 Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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)%>
    <%}%>

Legend

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