Skip to Main Content

Integration

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!

LKM SAP ERP to SQL - Execution Interface

2875303Jan 21 2016 — edited Jan 21 2016

This error happens when you try to run the interface with the SAP table, I'm using LKM SAP ERP to SQL with the option FSMOUNT_DIRECT and Load Extract Data stage has this message:

LKM Seletor: LKM SAP ERP to SQL

Option:FSMOUNT_DIRECT:SAP AS writes data into file on shared directory of ODI agent machine.

Step: Load Extract Data

Message error :

java.lang.RuntimeException: Error occured in open tool execute method: {0}...Error in executing ABAP program: {0}...File "/usr/sap/integracao_odi_sap/ZODI_8525001_3630001_DESENVOLVIMENTO.txt" is not open.

Cause: File "/usr/sap/integracao_odi_sap/ZODI_8525001_3630001_DESENVOLVIMENTO.txt" is not open.

Cause: File "/usr/sap/integracao_odi_sap/ZODI_8525001_3630001_DESENVOLVIMENTO.txt" is not open.

  at oracle.odi.sap.km._OdiSapAbapExecute.chainedSAPException(_OdiSapAbapExecute.java:746)

  at oracle.odi.sap.km._OdiSapAbapExecute.execute(_OdiSapAbapExecute.java:689)

  at com.sunopsis.dwg.function.SnpsOpenToolFunction.actionExecute(SnpsOpenToolFunction.java:47)

  at com.sunopsis.dwg.function.SnpsOpenToolFunction.execute(SnpsOpenToolFunction.java:148)

  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3437)

  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1509)

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

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

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

  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)

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

  at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:580)

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

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

  at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)

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

  at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)

  at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)

  at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)

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

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

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 18 2016
Added on Jan 21 2016
0 comments
821 views