title: HDP 2.0 Oozie Error: E0803 : E0803: IO error, E0603
body: <p>I am new to Apache Oozie and I am trying to run map-reduce example from Oozie examples using Hortonwors HDP 2.0 platform. I am getting:</p>
  
  <pre><code>[jakub@puppetmaster main]$ oozie job -oozie http://puppetmaster:11000/oozie -config apps/map-reduce/job.properties -run
  Error: E0803 : E0803: IO error, E0603: SQL error in operation, &lt;openjpa-2.2.2-r422266:1468616 fatal store error&gt; 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@2e4263ee
  </code></pre>
  
  <p>I suspect that I didn't performed some of the installations instruction correctly. I purely followed HDP 2.0 installation manual but I wasn't sure under which user to run commands. So I did following set of steps:</p>
  
  <pre><code>su -
  cd /usr/lib/oozie/
  bin/oozie-setup.sh prepare-war
  cd /usr/lib/oozie/
  bin/ooziedb.sh create -sqlfile oozie.sql -run Validate DB Connection
  su oozie
  cd /usr/lib/oozie/
  /usr/lib/oozie/bin/oozie-start.sh
  </code></pre>
  
  <p>Smoke test </p>
  
  <pre><code>oozie admin -oozie http://$oozie.full.hostname:11000/oozie -status
  </code></pre>
  
  <p>were ok.</p>
  
  <p>I am using build in debry databese shipped with distribution rpm package.
  Property file for the job:</p>
  
  <pre><code>nameNode=hdfs://puppetmaster:8020
  jobTracker=puppetmaster:8050
  queueName=default
  examplesRoot=examples
  
  oozie.wf.application.path=${nameNode}/user/${user.name}/${examplesRoot}/apps/map-reduce
  outputDir=map-reduce
  </code></pre>
  
  <p>I am not sure 100% sure if address of job tracker is correct pointing to yarn resource manager. </p>
  
  <p>Workflow file for the example.</p>
  
  <pre><code>&lt;workflow-app xmlns="uri:oozie:workflow:0.2" name="map-reduce-wf"&gt;
      &lt;start to="mr-node"/&gt;
      &lt;action name="mr-node"&gt;
          &lt;map-reduce&gt;
              &lt;job-tracker&gt;${jobTracker}&lt;/job-tracker&gt;
              &lt;name-node&gt;${nameNode}&lt;/name-node&gt;
              &lt;prepare&gt;
                  &lt;delete path="${nameNode}/user/${wf:user()}/${examplesRoot}/output-data/${outputDir}"/&gt;
              &lt;/prepare&gt;
              &lt;configuration&gt;
                  &lt;property&gt;
                      &lt;name&gt;mapred.job.queue.name&lt;/name&gt;
                      &lt;value&gt;${queueName}&lt;/value&gt;
                  &lt;/property&gt;
                  &lt;property&gt;
                      &lt;name&gt;mapred.mapper.class&lt;/name&gt;
                      &lt;value&gt;org.apache.oozie.example.SampleMapper&lt;/value&gt;
                  &lt;/property&gt;
                  &lt;property&gt;
                      &lt;name&gt;mapred.reducer.class&lt;/name&gt;
                      &lt;value&gt;org.apache.oozie.example.SampleReducer&lt;/value&gt;
                  &lt;/property&gt;
                  &lt;property&gt;
                      &lt;name&gt;mapred.map.tasks&lt;/name&gt;
                      &lt;value&gt;1&lt;/value&gt;
                  &lt;/property&gt;
                  &lt;property&gt;
                      &lt;name&gt;mapred.input.dir&lt;/name&gt;
                      &lt;value&gt;/user/${wf:user()}/${examplesRoot}/input-data/text&lt;/value&gt;
                  &lt;/property&gt;
                  &lt;property&gt;
                      &lt;name&gt;mapred.output.dir&lt;/name&gt;
                      &lt;value&gt;/user/${wf:user()}/${examplesRoot}/output-data/${outputDir}&lt;/value&gt;
                  &lt;/property&gt;
              &lt;/configuration&gt;
          &lt;/map-reduce&gt;
          &lt;ok to="end"/&gt;
          &lt;error to="fail"/&gt;
      &lt;/action&gt;
      &lt;kill name="fail"&gt;
          &lt;message&gt;Map/Reduce failed, error message[${wf:errorMessage(wf:lastErrorNode())}]&lt;/message&gt;
      &lt;/kill&gt;
      &lt;end name="end"/&gt;
  &lt;/workflow-app&gt;
  </code></pre>
  
  <p>Logs </p>
  
  <pre><code>2014-06-11 11:01:45,705 ERROR SubmitXCommand:536 - USER[jakub] GROUP[-] TOKEN[] APP[map-reduce-wf] JOB[0000000-140611110030961-oozie-oozi-W] ACTION[-] XException, 
  org.apache.oozie.command.CommandException: E0803: IO error, E0603: SQL error in operation, &lt;openjpa-2.2.2-r422266:1468616 fatal store error&gt; 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@355319a8
      at org.apache.oozie.command.wf.SubmitXCommand.execute(SubmitXCommand.java:252)
      at org.apache.oozie.command.wf.SubmitXCommand.execute(SubmitXCommand.java:72)
      at org.apache.oozie.command.XCommand.call(XCommand.java:280)
      at org.apache.oozie.DagEngine.submitJob(DagEngine.java:108)
      at org.apache.oozie.servlet.V1JobsServlet.submitWorkflowJob(V1JobsServlet.java:188)
      at org.apache.oozie.servlet.V1JobsServlet.submitJob(V1JobsServlet.java:88)
      at org.apache.oozie.servlet.BaseJobsServlet.doPost(BaseJobsServlet.java:99)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
      at org.apache.oozie.servlet.JsonRestServlet.service(JsonRestServlet.java:286)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.oozie.servlet.AuthFilter$2.doFilter(AuthFilter.java:126)
      at org.apache.hadoop.security.authentication.server.AuthenticationFilter.doFilter(AuthenticationFilter.java:384)
      at org.apache.oozie.servlet.AuthFilter.doFilter(AuthFilter.java:131)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.oozie.servlet.HostnameFilter.doFilter(HostnameFilter.java:84)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
      at java.lang.Thread.run(Thread.java:744)
  Caused by: org.apache.oozie.command.CommandException: E0603: SQL error in operation, &lt;openjpa-2.2.2-r422266:1468616 fatal store error&gt; 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@355319a8
      at org.apache.oozie.command.wf.SubmitXCommand.execute(SubmitXCommand.java:231)
      ... 29 more
  Caused by: org.apache.oozie.executor.jpa.JPAExecutorException: E0603: SQL error in operation, &lt;openjpa-2.2.2-r422266:1468616 fatal store error&gt; 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@355319a8
      at org.apache.oozie.service.JPAService.execute(JPAService.java:228)
      at org.apache.oozie.command.wf.SubmitXCommand.execute(SubmitXCommand.java:228)
      ... 29 more
  Caused by: &lt;openjpa-2.2.2-r422266:1468616 fatal store error&gt; 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@355319a8
      at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:594)
      at org.apache.oozie.service.JPAService.execute(JPAService.java:223)
      ... 30 more
  Caused by: &lt;openjpa-2.2.2-r422266:1468616 fatal general error&gt; org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back.  See the nested exceptions for details on the errors that occurred.
  FailedObject: org.apache.oozie.WorkflowJobBean@355319a8
      at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2347)
      at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2184)
      at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2082)
      at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2000)
      at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
      at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1524)
      at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:933)
      at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:570)
      ... 31 more
  Caused by: &lt;openjpa-2.2.2-r422266:1468616 fatal general error&gt; org.apache.openjpa.persistence.PersistenceException: An SQL data change is not permitted for a read-only connection, user or database. {prepstmnt 2096695648 INSERT INTO WF_JOBS (id, app_name, app_path, conf, group_name, parent_id, run, user_name, bean_type, created_time, end_time, external_id, last_modified_time, log_token, proto_action_conf, sla_xml, start_time, status, wf_instance) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=20000, state=25502]
  FailedObject: org.apache.oozie.WorkflowJobBean@355319a8
      at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4962)
      at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4922)
      at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
      at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78)
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:144)
      at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:100)
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:88)
      at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
      at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
      at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
      at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:105)
      at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:78)
      at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:732)
      at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
      ... 38 more
  Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: An SQL data change is not permitted for a read-only connection, user or database. {prepstmnt 2096695648 INSERT INTO WF_JOBS (id, app_name, app_path, conf, group_name, parent_id, run, user_name, bean_type, created_time, end_time, external_id, last_modified_time, log_token, proto_action_conf, sla_xml, start_time, status, wf_instance) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=20000, state=25502]
      at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
      at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:195)
      at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:59)
      at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1134)
      at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:275)
      at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1792)
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:268)
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:119)
      ... 48 more
  2014-06-11 11:01:45,717  WARN V1JobsServlet:542 - USER[jakub] GROUP[-] TOKEN[] APP[map-reduce-wf] JOB[0000000-140611110030961-oozie-oozi-W] ACTION[-] URL[POST http://puppetmaster:11000/oozie/v2/jobs?action=start] error[E0803], E0803: IO error, E0603: SQL error in operation, &lt;openjpa-2.2.2-r422266:1468616 fatal store error&gt; 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@355319a8
  org.apache.oozie.servlet.XServletException: E0803: IO error, E0603: SQL error in operation, &lt;openjpa-2.2.2-r422266:1468616 fatal store error&gt; 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@355319a8
      at org.apache.oozie.servlet.V1JobsServlet.submitWorkflowJob(V1JobsServlet.java:193)
      at org.apache.oozie.servlet.V1JobsServlet.submitJob(V1JobsServlet.java:88)
      at org.apache.oozie.servlet.BaseJobsServlet.doPost(BaseJobsServlet.java:99)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
      at org.apache.oozie.servlet.JsonRestServlet.service(JsonRestServlet.java:286)
      at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.oozie.servlet.AuthFilter$2.doFilter(AuthFilter.java:126)
      at org.apache.hadoop.security.authentication.server.AuthenticationFilter.doFilter(AuthenticationFilter.java:384)
      at org.apache.oozie.servlet.AuthFilter.doFilter(AuthFilter.java:131)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.oozie.servlet.HostnameFilter.doFilter(HostnameFilter.java:84)
      at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
      at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
      at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
      at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
      at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
      at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
      at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
      at java.lang.Thread.run(Thread.java:744)
  Caused by: org.apache.oozie.DagEngineException: E0803: IO error, E0603: SQL error in operation, &lt;openjpa-2.2.2-r422266:1468616 fatal store error&gt; 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@355319a8
      at org.apache.oozie.DagEngine.submitJob(DagEngine.java:115)
      at org.apache.oozie.servlet.V1JobsServlet.submitWorkflowJob(V1JobsServlet.java:188)
      ... 25 more
  Caused by: org.apache.oozie.command.CommandException: E0803: IO error, E0603: SQL error in operation, &lt;openjpa-2.2.2-r422266:1468616 fatal store error&gt; 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@355319a8
      at org.apache.oozie.command.wf.SubmitXCommand.execute(SubmitXCommand.java:252)
      at org.apache.oozie.command.wf.SubmitXCommand.execute(SubmitXCommand.java:72)
      at org.apache.oozie.command.XCommand.call(XCommand.java:280)
      at org.apache.oozie.DagEngine.submitJob(DagEngine.java:108)
      ... 26 more
  Caused by: org.apache.oozie.command.CommandException: E0603: SQL error in operation, &lt;openjpa-2.2.2-r422266:1468616 fatal store error&gt; 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@355319a8
      at org.apache.oozie.command.wf.SubmitXCommand.execute(SubmitXCommand.java:231)
      ... 29 more
  Caused by: org.apache.oozie.executor.jpa.JPAExecutorException: E0603: SQL error in operation, &lt;openjpa-2.2.2-r422266:1468616 fatal store error&gt; 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@355319a8
      at org.apache.oozie.service.JPAService.execute(JPAService.java:228)
      at org.apache.oozie.command.wf.SubmitXCommand.execute(SubmitXCommand.java:228)
      ... 29 more
  Caused by: &lt;openjpa-2.2.2-r422266:1468616 fatal store error&gt; 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@355319a8
      at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:594)
      at org.apache.oozie.service.JPAService.execute(JPAService.java:223)
      ... 30 more
  Caused by: &lt;openjpa-2.2.2-r422266:1468616 fatal general error&gt; org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back.  See the nested exceptions for details on the errors that occurred.
  FailedObject: org.apache.oozie.WorkflowJobBean@355319a8
      at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2347)
      at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2184)
      at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2082)
      at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:2000)
      at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.java:81)
      at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1524)
      at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:933)
      at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.java:570)
      ... 31 more
  Caused by: &lt;openjpa-2.2.2-r422266:1468616 fatal general error&gt; org.apache.openjpa.persistence.PersistenceException: An SQL data change is not permitted for a read-only connection, user or database. {prepstmnt 2096695648 INSERT INTO WF_JOBS (id, app_name, app_path, conf, group_name, parent_id, run, user_name, bean_type, created_time, end_time, external_id, last_modified_time, log_token, proto_action_conf, sla_xml, start_time, status, wf_instance) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=20000, state=25502]
  FailedObject: org.apache.oozie.WorkflowJobBean@355319a8
      at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4962)
      at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java:4922)
      at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136)
      at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:78)
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:144)
      at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAndUpdate(BatchingPreparedStatementManagerImpl.java:79)
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(PreparedStatementManagerImpl.java:100)
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedStatementManagerImpl.java:88)
      at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:550)
      at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdateManager.java:106)
      at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(BatchingConstraintUpdateManager.java:59)
      at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:105)
      at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateManager.java:78)
      at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java:732)
      at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManager.java:131)
      ... 38 more
  Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: An SQL data change is not permitted for a read-only connection, user or database. {prepstmnt 2096695648 INSERT INTO WF_JOBS (id, app_name, app_path, conf, group_name, parent_id, run, user_name, bean_type, created_time, end_time, external_id, last_modified_time, log_token, proto_action_conf, sla_xml, start_time, status, wf_instance) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)} [code=20000, state=25502]
      at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:219)
      at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.wrap(LoggingConnectionDecorator.java:195)
      at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator.access$1000(LoggingConnectionDecorator.java:59)
      at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$LoggingPreparedStatement.executeUpdate(LoggingConnectionDecorator.java:1134)
      at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:275)
      at org.apache.openjpa.jdbc.kernel.JDBCStoreManager$CancelPreparedStatement.executeUpdate(JDBCStoreManager.java:1792)
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.executeUpdate(PreparedStatementManagerImpl.java:268)
      at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(PreparedStatementManagerImpl.java:119)
      ... 48 more
  </code></pre>
  
  <p>Neither oozie web console nor the resource manager noticed any job submission.
  My suspition is that something with the installation is not correct.</p>
  
  <p>Any hints where to look or what might cause the issue?</p>
  
  <p>Thx</p>