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
Change the namenode port in your job.properties, it should be:
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.