[
https://issues.apache.org/jira/browse/OOZIE-2979?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rajasekhar updated OOZIE-2979:
------------------------------
Environment:
Hi,
I have a shell script and it reads value from DB and then kickoff PIG script
inside. I need to call this shell script using oozie shell action. When i call
this i have got sqlplus not found error.
Shell script has sqlplus (path was set) command to read DB value.
Here is my workflow.xml.
<start to="shell-mobilemetric"/>
<action name="shell-mobilemetric">
<shell xmlns="uri:oozie:shell-action:0.2">
<job-tracker>${jobTracker}</job-tracker>
<name-node>${nameNode}</name-node>
<configuration>
<property>
<name>mapred.job.queue.name</name>
<value>${queueName}</value>
</property>
</configuration>
<exec>sample.sh</exec>
<argument>sample.pig</argument>
<file>${oozieAppPath}/sample.sh#sample.sh</file>
</shell>
<ok to="end-mobilemetric"/>
<error to="fail-mobilemetric"/>
</action>
<kill name="fail-mobilemetric">
<message>Mobile metric exection failed, error
message[${wf:errorMessage(wf:lastErrorNode())}]</message>
</kill>
<end name="end-mobilemetric"/>
was:
Hi,
I have a shell script and it reads value from DB and then kickoff PIG script
inside. I need to call this shell script using oozie shell action. When i call
this i have got sqlplus not found error.
Shell script has sqlplus (path was set) command to read DB value.
Here is my workflow.xml.
<start to="shell-mobilemetric"/>
<action name="shell-mobilemetric">
<shell xmlns="uri:oozie:shell-action:0.2">
<job-tracker>${jobTracker}</job-tracker>
<name-node>${nameNode}</name-node>
<configuration>
<property>
<name>mapred.job.queue.name</name>
<value>${queueName}</value>
</property>
</configuration>
<exec>run_mbl_pig_by_day.sh</exec>
<argument>mbl_s1browser_metrics.pig</argument>
<file>${oozieAppPath}/run_mbl_pig_by_day.sh#run_mbl_pig_by_day.sh</file>
</shell>
<ok to="end-mobilemetric"/>
<error to="fail-mobilemetric"/>
</action>
<kill name="fail-mobilemetric">
<message>Mobile metric exection failed, error
message[${wf:errorMessage(wf:lastErrorNode())}]</message>
</kill>
<end name="end-mobilemetric"/>
> sqlplus not found
> -----------------
>
> Key: OOZIE-2979
> URL: https://issues.apache.org/jira/browse/OOZIE-2979
> Project: Oozie
> Issue Type: Bug
> Environment: Hi,
> I have a shell script and it reads value from DB and then kickoff PIG script
> inside. I need to call this shell script using oozie shell action. When i
> call this i have got sqlplus not found error.
> Shell script has sqlplus (path was set) command to read DB value.
> Here is my workflow.xml.
> <start to="shell-mobilemetric"/>
> <action name="shell-mobilemetric">
> <shell xmlns="uri:oozie:shell-action:0.2">
> <job-tracker>${jobTracker}</job-tracker>
> <name-node>${nameNode}</name-node>
> <configuration>
> <property>
> <name>mapred.job.queue.name</name>
> <value>${queueName}</value>
> </property>
> </configuration>
> <exec>sample.sh</exec>
> <argument>sample.pig</argument>
> <file>${oozieAppPath}/sample.sh#sample.sh</file>
> </shell>
> <ok to="end-mobilemetric"/>
> <error to="fail-mobilemetric"/>
> </action>
> <kill name="fail-mobilemetric">
> <message>Mobile metric exection failed, error
> message[${wf:errorMessage(wf:lastErrorNode())}]</message>
> </kill>
> <end name="end-mobilemetric"/>
> Reporter: Rajasekhar
>
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
