2 Replies Latest reply: Feb 10, 2013 5:29 AM by Phanikanth RSS

    Create database link on target - Missing parameters error.

    988268
      Hi Experts,

      I am trying to load the data from oracle source to a Oracle DB. All the connections are tested and are working fine.
      But when i am executing the Interface, it is giving the following error:
      create database link     localhost:1521
      connect to          scott
      identified by          <@=snpRef.getInfo("SRC_PASS") @>
      using          'localhost:1521'

      and
      com.sunopsis.sql.SnpsMissingParametersException: Missing parameter

           at com.sunopsis.sql.SnpsQuery.completeHostVariable(SnpsQuery.java)

           at com.sunopsis.sql.SnpsQuery.updateExecStatement(SnpsQuery.java)

           at com.sunopsis.sql.SnpsQuery.executeUpdate(SnpsQuery.java)

           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execStdOrders(SnpSessTaskSql.java)

           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTaskTrt(SnpSessTaskSql.java)

           at com.sunopsis.dwg.dbobj.SnpSessTaskSqlC.treatTaskTrt(SnpSessTaskSqlC.java)

           at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java)

           at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java)

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

           at com.sunopsis.dwg.cmd.DwgCommandSession.treatCommand(DwgCommandSession.java)

           at com.sunopsis.dwg.cmd.DwgCommandBase.execute(DwgCommandBase.java)

           at com.sunopsis.dwg.cmd.e.i(e.java)

           at com.sunopsis.dwg.cmd.h.y(h.java)

           at com.sunopsis.dwg.cmd.e.run(e.java)

           at java.lang.Thread.run(Unknown Source)


      Please check this and do need full.

      Thanks
      Navee