https://community.cloudera.com/t5/Support-Questions/Launcher-ERROR-reason-Main-class-org-apache-oozie-action/m-p/229923#M191776 <P>I've create an Oozie Job that uses Sqoop import get data from mysql database to hive.</P><P> the strange thing is that on Hadoop job list all my job status are SUCCEEDED instead on Oozie that job is FAIL.</P><P> <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="63423-1.jpg" style="width: 1366px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15061iFCA8EA3D3DCC3DB7/image-size/medium?v=v2&amp;px=400" role="button" title="63423-1.jpg" alt="63423-1.jpg" /></span></P><P> <span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="63424-2.jpg" style="width: 1366px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/15062i52D3AB27CECFD576/image-size/medium?v=v2&amp;px=400" role="button" title="63424-2.jpg" alt="63424-2.jpg" /></span></P><P> This is my workflow.xml configuration </P> <PRE>&lt;?xml version="1.0" encoding="UTF-8"?&gt; &lt;workflow-app xmlns="uri:oozie:workflow:0.2" name="sqoop-importAssurance"&gt; &lt;start to="sqoop-node"/&gt; &lt;action name="sqoop-node"&gt; &lt;sqoop xmlns="uri:oozie:sqoop-action:0.2"&gt; &lt;job-tracker&gt;${jobTracker}&lt;/job-tracker&gt; &lt;name-node&gt;${nameNode}&lt;/name-node&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;oozie.hive.defaults&lt;/name&gt; &lt;value&gt;/tmp/hive-site.xml&lt;/value&gt; &lt;/property&gt; &lt;property&gt; &lt;name&gt;yarn.nodemanager.vmem-check-enabled&lt;/name&gt; &lt;value&gt;false&lt;/value&gt; &lt;description&gt;Whether virtual memory limits will be enforced for containers&lt;/description&gt; &lt;/property&gt; &lt;property&gt; &lt;name&gt;yarn.nodemanager.vmem-pmem-ratio&lt;/name&gt; &lt;value&gt;4&lt;/value&gt; &lt;description&gt;Ratio between virtual memory to physical memory when setting memory limits for containers&lt;/description&gt; &lt;/property&gt; &lt;/configuration&gt; &lt;command&gt;import -Dorg.apache.sqoop.splitter.allow_text_splitter=true --connect jdbc:mysql://xxxxxx --table assurance --username xxxxx --password xxxxxx --driver com.mysql.jdbc.Driver --hive-import --hive-table assurance --check-column lastaccess --incremental lastmodified --map-column-hive firstaccess=TIMESTAMP,lastaccess=TIMESTAMP -m 1 --merge-key macaddr&lt;/command&gt; &lt;file&gt;/tmp/hive-site.xml#hive-site.xml&lt;/file&gt; &lt;/sqoop&gt; &lt;ok to="end"/&gt; &lt;error to="fail"/&gt; &lt;/action&gt; &lt;kill name="fail"&gt; &lt;message&gt;Sqoop failed, error message[${wf:errorMessage(wf:lastErrorNode())}]&lt;/message&gt; &lt;/kill&gt; &lt;end name="end"/&gt; &lt;/workflow-app&gt; </PRE><P>and this is myproperties </P><PRE>nameNode=hdfs://172.17.0.2:8020 jobTracker=sandbox-hdp.hortonworks.com:8032 queueName=default examplesRoot=examples oozie.use.system.libpath=true oozie.action.sharelib.for.sqoop=hive,hcatalog,sqoop oozie.action.sharelib.for.hive=hive,hcatalog,sqoop oozie.wf.application.path=${nameNode}/user/test/ workflowAppUri=${nameNode}/user/test/ oozie.libpat=/user/oozie/share/lib/ user.name=root start=2018-02-14T17:30Z end=2018-02-14T19:30Z </PRE><P>I've insert mysql-connector-java-5.1.45 into oozie.libpath folder and uplod hive-conf.xml into /etc/hive/conf/,</P><P>but nothing.</P><P>below there are my full log, i've set oozie log level to DEBUG</P><P><A href="https://community.cloudera.com/legacyfs/online/attachments/63426-logs.txt" target="_blank">logs.txt</A></P><P>Any suggestion?</P><P>thanks in advance</P> Sun, 18 Aug 2019 00:52:12 GMT smatino 2019-08-18T00:52:12Z