Rajasekhar created OOZIE-2979:
---------------------------------

             Summary: 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>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"/>
            Reporter: Rajasekhar






--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to