Support Questions

Find answers, ask questions, and share your expertise

OOZIE error

avatar
New Contributor

While I am running an oozie command :

oozie job -oozie http://sandbox.hortonworks.com:11000/oozie -config job.properties -run

getting an error as

Error: E0803 : E0803: IO error, E0603: SQL error in operation, <openjpa-2.2.2-r422266:1468616 fatal store error> org.apache.openjpa.persistence.RollbackException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred. FailedObject: org.apache.oozie.WorkflowJobBean@6336a3e5

Please find my workflow.xml

<workflow-app name="WorkFlowForShellActionWithCaptureOutput" xmlns="uri:oozie:workflow:0.4">

<start to="shellAction"/>

<action name="shellAction">

<shell xmlns="uri:oozie:shell-action:0.4">

<job-tracker>${JobTracker}</job-tracker>

<name-node>${namenode}</name-node>

<configuration>

<property>

<name>mapred.job.queue.name</name> <value>${QueuName}</value>

</property> </configuration>

<exec>${recordShellScript}</exec>

<file>${recordShScriptPath}#${recordShellScript}</file>

<capture-output/> </shell> <ok to="end"/> <error to="killAction"/> </action> <kill name="killAction"> <message>"Killed job due to error"</message> </kill> <end name="end"/> </workflow-app>

job.properties as

namenode=hdfs://sandbox.hortonworks.com:50070

JobTracker=hdfs://sandbox.hortonworks.com:8050

QueuName=default oozie.libpath=/L301/

oozie.use.system.libpath=true oozie.wf.rerun.failnodes=true

appPath=/L301/workfowShell.xml

recordShScriptPath=/L301/recordtime.sh r

recordShellScript=recordtime.sh

1 REPLY 1

avatar
Master Guru

Change the namenode port in your job.properties, it should be:

namenode=hdfs://sandbox.hortonworks.com:8020

You may have other errors too. By the way, there are many simple but good examples of Oozie actions in /usr/hdp/current/oozie-client/doc/examples on every Oozie client node. Copy that to your home directory and customize/test actions for your applications. Then copy "examples" to hdfs and test your actions. No need to write actions all by yourself.