Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Patch 29205229: Sftp connection issue: Message org.apache.commons.vfs2.FileSystemException: Unknown

User_Y8G3XJun 10 2019 — edited Jun 11 2019

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)