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
