My Oracle Support Banner

OdiOSCommand Fails With File Permission Error When Writing To File On Linux Platform (Doc ID 1574105.1)

Last updated on JULY 10, 2018

Applies to:

Oracle Data Integrator - Version 11.1.1.3.0 and later
Generic Linux

Symptoms

On Linux platform when calling OdiOSCommand from Oracle Data Integrator (ODI) Scenario to write to the Linux file system you might get the following error:

ODI-1226: Step OdiOSCommand 1 fails after 1 attempt(s).
ODI-1241: Oracle Data Integrator tool execution fails.
Caused By: com.sunopsis.dwg.function.SnpsFunctionBaseException: ODI-30038: OS command returned 2.
at com.sunopsis.dwg.tools.OSCommand.actionExecute(OSCommand.java:294)
at com.sunopsis.dwg.function.SnpsFunctionBase.execute(SnpsFunctionBase.java:276)
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:561)

While running the same operating system command from the Linux shell script directly outside ODI, it works fine which means that the operating system user is having the proper OS permission.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 How to calculate umasks?
 Examples


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.