[jira] [Resolved] (OOZIE-2979) sqlplus not found

["Robert Kanter (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/OOZIE-2979?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Robert Kanter resolved OOZIE-2979.
----------------------------------
    Resolution: Not A Bug

[~rajkonda], it sounds like you need help figuring out a problem you're having with your script; but JIRA is for filing bugs, feature requests, etc.  Please try emailing the Users mailing list and maybe someone on there can help you.  I'd recommend attaching your run_mbl_pig_by_day.sh script so people can see what you're actually running.  The launcher logs would also likely be helpful to attach.

http://oozie.apache.org/mail-lists.html

> 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)