Member since
03-31-2017
3
Posts
0
Kudos Received
0
Solutions
04-06-2017
07:28 AM
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
... View more
Labels:
- Labels:
-
Apache Oozie