3 Replies Latest reply on Jun 11, 2019 2:11 PM by SH_INT

    Patch 29205229: Sftp connection issue: Message org.apache.commons.vfs2.FileSystemException: Unknown message with code "ODI-30089: Source file "sftp://z0311111c/vol2/home/remoteuser/poc/outbox" does not exist".

    3481721

      Getting below sftp connection error after apply the patch 29205229.

       

      Host: z0311111c

      Path: /vol2/home/remoteuser/poc/outbox

       

       

      OdiSftpGet "-HOST=#POC1.L_OBOUND_SRCHOST" "-USER=#POC1.L_OBOUND_SRCUNAME" "-PASSWORD=#POC1.L_OBOUND_SRCENCODEPWD" "-REMOTE_DIR=#POC1.L_OBOUND_SRCOUTBOX" "-REMOTE_FILE=#POC1.L_OBOUND_FILEFILTER" "-LOCAL_DIR=#POC1.L_OBOUND_ODILOCAL" "-COMPRESSION=NO" "-STRICT_HOSTKEY_CHECKING=NO"

       

      Sample Values:

      OdiSftpGet "-HOST=z0311111c" "-USER=remoteuser" "-PASSWORD=HAu41ChDhOxFtnUdhGm5HQ==" "-REMOTE_DIR=/vol2/home/remoteuser/poc/outbox" "-REMOTE_FILE=*Supplier*.txt|*LTBPurchasedItems*.txt|*PurchasedItemsInventory*.txt" "-LOCAL_DIR=/odi_SHARED/poc1/india" "-COMPRESSION=NO" "-STRICT_HOSTKEY_CHECKING=NO"

       

       

      Error Details:

      Message org.apache.commons.vfs2.FileSystemException: Unknown message with code "ODI-30089: Source file "sftp://z0311111c/vol2/home/remoteuser/poc/outbox" does not exist".

      at com.sunopsis.dwg.tools.filecopy.RemoteFileCopy.copy(RemoteFileCopy.java:575)

      at com.sunopsis.dwg.tools.SftpGet.actionExecute(SftpGet.java:49)

      at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:235)

      at oracle.odi.runtime.agent.execution.SessionTask.execIntegratedFunction(SessionTask.java:949)

      at oracle.odi.runtime.agent.execution.SessionTask.executeOdiCommand(SessionTask.java:607)

      at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:32)

      at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:18)

      at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)

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

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

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

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

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

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

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

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

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

      at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.access$2700(StartScenRequestProcessor.java:85)

      at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:917)

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

      at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$1.run(DefaultAgentTaskExecutor.java:66)

      at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:48)

      at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor.executeAgentTask(DefaultAgentTaskExecutor.java:76)

      at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.doExecuteAgentTask(TaskExecutorAgentRequestProcessor.java:146)

      at oracle.odi.runtime.agent.processor.TaskExecutorAgentRequestProcessor.process(TaskExecutorAgentRequestProcessor.java:137)

      at oracle.odi.runtime.agent.support.DefaultRuntimeAgent.execute(DefaultRuntimeAgent.java:79)

      at oracle.odi.runtime.agent.invocation.support.InternalLocalRuntimeAgentInvoker.invoke(InternalLocalRuntimeAgentInvoker.java:44)

      at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:274)

      at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invokeStartScenario(InternalRemoteRuntimeAgentInvoker.java:222)

      at com.sunopsis.dwg.tools.StartScen.actionExecute(StartScen.java:337)

      at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:235)

      at oracle.odi.runtime.agent.execution.SessionTask.execIntegratedFunction(SessionTask.java:949)

      at oracle.odi.runtime.agent.execution.SessionTask.executeOdiCommand(SessionTask.java:607)

      at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:32)

      at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:18)

      at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:52)

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

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

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

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

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

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

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

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

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

      at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.access$2700(StartScenRequestProcessor.java:85)

      at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:917)

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

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

      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

      at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)

      at oracle.odi.runtime.agent.execution.job.OdiJob.call(OdiJob.java:73)

      at java.util.concurrent.FutureTask.run(FutureTask.java:266)

      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

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