How to resolve this error Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]?

[#1]

I am trying to execute a sqoop action with oozie, the command in sqoop action is like this(with the correct information for database connection)

sqoop import \
--connect jdbc:oracle://localhost/userdb \--username root \
--table mms \
--m 1 \
--target-dir /queryresult

[#2]

@Cecilia Posadas

Add the mysql-connector-java.jar library into the lib directory located inside the oozie project root directory where the job.properties and workflow.xml files are located.

Better solution is to add the mysql-connector-java-*.jar once to share/lib/sqoop directory in HDFS.

Please do that and let me know

[#3]

But I am using a database in Oracle, this does't matter?

[#4]

it does matter, use the Oracle driver jar. @Cecilia Posadas

[#5]

I have the oracle driver ojdbc6.jar in this location /user/oozie/share/lib/lib_20150401172510/sqoop in HDFS

The error is the same

<<< Invocation of Main class completed <<<

Failing Oozie Launcher, Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]

Oozie Launcher failed, finishing Hadoop job gracefully

[#6]

@Cecilia Posadas go to job history, drill down to the log of the failed attempt and paste the error from there.

[#7]

Sorry, but I am sure where is ? Could help my screen is like this

[#8]

go to ambari > yarn > resource manager UI > find your job, drill down to task attempt. It is not in Hue. @Cecilia Posadas

[#9]

But I am using Hue for do the workflows with Oozie, I don't understand why ambari?

[#10]

@Cecilia Posadas the error you provided is generic, to find out the real reason you're having issue you only possible if you go to the task attempt, Hue will not give you that.