Error: E0803 : E0803: IO error, E0603: SQL error in operation,how to resolve Error: E0803 while executing oozie workflow

[#1]

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@6af7a4af

[#2]

@Lekhraj Prasoya

Are you getting this error while starting Oozie service or in Oozie workflow? If you are getting this in Oozie workflow then can you please attach complete Oozie launcher logs?

By looking at the error, It looks like database user permission issue.

Also, Have a look at below URL

http://stackoverflow.com/questions/24166026/hdp-2-0-oozie-error-e0803-e0803-io-error-e0603

Hope this helps.