Dear All:
I meet a problem about oozie workflow about shell Action. I use hue
to control my oozie.
The step is as follows:
1. I create my workflow using shell and using a exist shell below：
#!/bin/sh
DB_USER=test
DB_PWD=test
DB_SERV=192.168.1.207/razor
sqlplus64 -s "$DB_USER/$DB_PWD@$DB_SERV" << EOF
spool /opt/extract_data.sql
set trimspool on
set linesize 8000
set pagesize 50000
set newpage 1
set heading off
set term off
set feedback off
set sqlblankline off
SELECT * FROM RAZOR_WORKS WHERE STATUS='FAIL';
spool off
exit
EOF
2. I run this and got this error:
2017-05-09 19:50:46,238 INFO ActionStartXCommand:520 - SERVER[tw-master]
USER[root] GROUP[-] TOKEN[] APP[SHELL_AGAIN]
JOB[0000127-170506114458023-oozie-oozi-W]
ACTION[0000127-170506114458023-oozie-oozi-W@:start:] Start action
[0000127-170506114458023-oozie-oozi-W@:start:] with user-retry state :
userRetryCount [0], userRetryMax [0], userRetryInterval [10]
2017-05-09 19:50:46,245 INFO ActionStartXCommand:520 - SERVER[tw-master]
USER[root] GROUP[-] TOKEN[] APP[SHELL_AGAIN]
JOB[0000127-170506114458023-oozie-oozi-W]
ACTION[0000127-170506114458023-oozie-oozi-W@:start:]
[***0000127-170506114458023-oozie-oozi-W@:start:***]Action status=DONE
2017-05-09 19:50:46,246 INFO ActionStartXCommand:520 - SERVER[tw-master]
USER[root] GROUP[-] TOKEN[] APP[SHELL_AGAIN]
JOB[0000127-170506114458023-oozie-oozi-W]
ACTION[0000127-170506114458023-oozie-oozi-W@:start:]
[***0000127-170506114458023-oozie-oozi-W@:start:***]Action updated in DB!
2017-05-09 19:50:46,363 INFO WorkflowNotificationXCommand:520 -
SERVER[tw-master] USER[-] GROUP[-] TOKEN[-] APP[-]
JOB[0000127-170506114458023-oozie-oozi-W]
ACTION[0000127-170506114458023-oozie-oozi-W@:start:] No Notification URL is
defined. Therefore nothing to notify for job
0000127-170506114458023-oozie-oozi-W@:start:
2017-05-09 19:50:46,363 INFO WorkflowNotificationXCommand:520 -
SERVER[tw-master] USER[-] GROUP[-] TOKEN[-] APP[-]
JOB[0000127-170506114458023-oozie-oozi-W] ACTION[] No Notification URL is
defined. Therefore nothing to notify for job
0000127-170506114458023-oozie-oozi-W
2017-05-09 19:50:46,399 INFO ActionStartXCommand:520 - SERVER[tw-master]
USER[root] GROUP[-] TOKEN[] APP[SHELL_AGAIN]
JOB[0000127-170506114458023-oozie-oozi-W]
ACTION[0000127-170506114458023-oozie-oozi-W@shell-077a] Start action
[0000127-170506114458023-oozie-oozi-W@shell-077a] with user-retry state :
userRetryCount [0], userRetryMax [0], userRetryInterval [10]
2017-05-09 19:50:48,543 INFO ShellActionExecutor:520 - SERVER[tw-master]
USER[root] GROUP[-] TOKEN[] APP[SHELL_AGAIN]
JOB[0000127-170506114458023-oozie-oozi-W]
ACTION[0000127-170506114458023-oozie-oozi-W@shell-077a] checking action, hadoop
job ID [job_1494042098609_0071] status [RUNNING]
2017-05-09 19:50:48,547 INFO ActionStartXCommand:520 - SERVER[tw-master]
USER[root] GROUP[-] TOKEN[] APP[SHELL_AGAIN]
JOB[0000127-170506114458023-oozie-oozi-W]
ACTION[0000127-170506114458023-oozie-oozi-W@shell-077a]
[***0000127-170506114458023-oozie-oozi-W@shell-077a***]Action status=RUNNING
2017-05-09 19:50:48,547 INFO ActionStartXCommand:520 - SERVER[tw-master]
USER[root] GROUP[-] TOKEN[] APP[SHELL_AGAIN]
JOB[0000127-170506114458023-oozie-oozi-W]
ACTION[0000127-170506114458023-oozie-oozi-W@shell-077a]
[***0000127-170506114458023-oozie-oozi-W@shell-077a***]Action updated in DB!
2017-05-09 19:50:48,585 INFO WorkflowNotificationXCommand:520 -
SERVER[tw-master] USER[-] GROUP[-] TOKEN[-] APP[-]
JOB[0000127-170506114458023-oozie-oozi-W]
ACTION[0000127-170506114458023-oozie-oozi-W@shell-077a] No Notification URL is
defined. Therefore nothing to notify for job
0000127-170506114458023-oozie-oozi-W@shell-077a
2017-05-09 19:51:06,432 INFO CallbackServlet:520 - SERVER[tw-master] USER[-]
GROUP[-] TOKEN[-] APP[-] JOB[0000127-170506114458023-oozie-oozi-W]
ACTION[0000127-170506114458023-oozie-oozi-W@shell-077a] callback for action
[0000127-170506114458023-oozie-oozi-W@shell-077a]
2017-05-09 19:51:06,601 INFO ShellActionExecutor:520 - SERVER[tw-master]
USER[root] GROUP[-] TOKEN[] APP[SHELL_AGAIN]
JOB[0000127-170506114458023-oozie-oozi-W]
ACTION[0000127-170506114458023-oozie-oozi-W@shell-077a] action completed,
external ID [job_1494042098609_0071]
2017-05-09 19:51:06,611 WARN ShellActionExecutor:523 - SERVER[tw-master]
USER[root] GROUP[-] TOKEN[] APP[SHELL_AGAIN]
JOB[0000127-170506114458023-oozie-oozi-W]
ACTION[0000127-170506114458023-oozie-oozi-W@shell-077a] Launcher ERROR, reason:
Main class [org.apache.oozie.action.hadoop.ShellMain], exit code [1]
2017-05-09 19:51:06,711 INFO ActionEndXCommand:520 - SERVER[tw-master]
USER[root] GROUP[-] TOKEN[] APP[SHELL_AGAIN]
JOB[0000127-170506114458023-oozie-oozi-W]
ACTION[0000127-170506114458023-oozie-oozi-W@shell-077a] ERROR is considered as
FAILED for SLA
2017-05-09 19:51:06,853 INFO ActionStartXCommand:520 - SERVER[tw-master]
USER[root] GROUP[-] TOKEN[] APP[SHELL_AGAIN]
JOB[0000127-170506114458023-oozie-oozi-W]
ACTION[0000127-170506114458023-oozie-oozi-W@Kill] Start action
[0000127-170506114458023-oozie-oozi-W@Kill] with user-retry state :
userRetryCount [0], userRetryMax [0], userRetryInterval [10]
2017-05-09 19:51:06,864 INFO ActionStartXCommand:520 - SERVER[tw-master]
USER[root] GROUP[-] TOKEN[] APP[SHELL_AGAIN]
JOB[0000127-170506114458023-oozie-oozi-W]
ACTION[0000127-170506114458023-oozie-oozi-W@Kill]
[***0000127-170506114458023-oozie-oozi-W@Kill***]Action status=DONE
2017-05-09 19:51:06,864 INFO ActionStartXCommand:520 - SERVER[tw-master]
USER[root] GROUP[-] TOKEN[] APP[SHELL_AGAIN]
JOB[0000127-170506114458023-oozie-oozi-W]
ACTION[0000127-170506114458023-oozie-oozi-W@Kill]
[***0000127-170506114458023-oozie-oozi-W@Kill***]Action updated in DB!
2017-05-09 19:51:06,994 INFO WorkflowNotificationXCommand:520 -
SERVER[tw-master] USER[-] GROUP[-] TOKEN[-] APP[-]
JOB[0000127-170506114458023-oozie-oozi-W]
ACTION[0000127-170506114458023-oozie-oozi-W@Kill] No Notification URL is
defined. Therefore nothing to notify for job
0000127-170506114458023-oozie-oozi-W@Kill
2017-05-09 19:51:06,994 INFO WorkflowNotificationXCommand:520 -
SERVER[tw-master] USER[-] GROUP[-] TOKEN[-] APP[-]
JOB[0000127-170506114458023-oozie-oozi-W]
ACTION[0000127-170506114458023-oozie-oozi-W@shell-077a] No Notification URL is
defined. Therefore nothing to notify for job
0000127-170506114458023-oozie-oozi-W@shell-077a
2017-05-09 19:51:06,995 INFO WorkflowNotificationXCommand:520 -
SERVER[tw-master] USER[-] GROUP[-] TOKEN[-] APP[-]
JOB[0000127-170506114458023-oozie-oozi-W] ACTION[] No Notification URL is
defined. Therefore nothing to notify for job
0000127-170506114458023-oozie-oozi-W
3. I don't know how to do with ERROR is considered as FAILED for
SLA.Is there something wrong with my permission,or the solution is not
supported.
Thanks
Best Regards,
Hollis
