4 Replies Latest reply on Sep 7, 2012 1:58 PM by 950270

    Execution Error

    950270
      Hi, When I am executing my interface ,I am getting following Error,Please any one help regarding this..


      ODI-1228: Task LOAD_INT (Integration) fails on the target ORACLE connection LOAD.
      Caused By: java.sql.SQLException: Missing IN or OUT parameter at index:: 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.executeUpdate(OraclePreparedStatement.java:3467)
           at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350)
           at com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java:665)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeUpdate(SnpSessTaskSql.java:3218)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execStdOrders(SnpSessTaskSql.java:1785)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java:2805)
           at com.sunopsis.dwg.dbobj.SnpSessTaskSqlI.treatTaskTrt(SnpSessTaskSqlI.java:68)
           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:662)

      and below i am providing you the code also..

      BeanShell script error: Sourced file: inline evaluation of: ``out.print("insert into\t") ; out.print(odiRef.getTable("L","INT_NAME","A")) ; ou . . . '' : Typed variable declaration : Error in method invocation: Method getDataSetMin() not found in class'com.sunopsis.dwg.snpreference.SnpReferenceInterne' : at Line: 6 : in file: inline evaluation of: ``out.print("insert into\t") ; out.print(odiRef.getTable("L","INT_NAME","A")) ; ou . . . '' : odiRef .getDataSetMin ( )
      BSF info: Insert flow into I$ table at line: 0 column: columnNo
      out.print("insert into\t") ;
      out.print(odiRef.getTable("L","INT_NAME","A")) ;
      out.print("\n(\n\t") ;
      out.print(odiRef.getColList("", "[COL_NAME]", ",\\n\\t", "", "(((INS or UPD) and !TRG) and REW)")) ;
      out.print(",\n\tIND_UPDATE\n)\n") ;
      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]", ",\\n\\t", "", "(((INS or UPD) and !TRG) and REW)")) ;
      out.print(",\n") ;
      if (odiRef.getDataSet(i, "HAS_JRN").equals("1")) { out.print("\n\tJRN_FLAG IND_UPDATE\n") ;
      } else {out.print("\n\t'I' IND_UPDATE\n") ;
      }out.print("\nfrom\t") ;
      out.print(odiRef.getFrom(i)) ;
      out.print("\nwhere\t(1=1)\n") ;
      out.print(odiRef.getJoin(i)) ;
      out.print("\n") ;
      out.print(odiRef.getFilter(i)) ;
      out.print("\n") ;
      out.print(odiRef.getJrnFilter(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 ******
      insert into     <%=odiRef.getTable("L","INT_NAME","A")%>
      (
           <%=odiRef.getColList("", "[COL_NAME]", ",\n\t", "", "(((INS or UPD) and !TRG) and REW)")%>,
           IND_UPDATE
      )
      <%for (int i=odiRef.getDataSetMin(); i <= odiRef.getDataSetMax(); i++){%>
      <%=odiRef.getDataSet(i, "Operator")%>
      select      <%=odiRef.getPop("DISTINCT_ROWS")%>
           <%=odiRef.getColList(i,"", "[EXPRESSION]", ",\n\t", "", "(((INS or UPD) and !TRG) and REW)")%>,
      <% if (odiRef.getDataSet(i, "HAS_JRN").equals("1")) { %>
           JRN_FLAG IND_UPDATE
      <%} else {%>
           'I' IND_UPDATE
      <%}%>
      from     <%=odiRef.getFrom(i)%>
      where     (1=1)
      <%=odiRef.getJoin(i)%>
      <%=odiRef.getFilter(i)%>
      <%=odiRef.getJrnFilter(i)%>
      <%=odiRef.getGrpBy(i)%>
      <%=odiRef.getHaving(i)%>
      <%}%>

      Thanks in Advance