Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

sqoop job in oozie gets killed with Launcher ERROR, reason: Main class [org.apache.oozie.action]

Highlighted

sqoop job in oozie gets killed with Launcher ERROR, reason: Main class [org.apache.oozie.action]

Visitor
2016-07-11 02:02:06,386 INFO org.apache.oozie.command.wf.ActionStartXCommand: SERVER[quickstart.cloudera] USER[root] GROUP[-] TOKEN[] APP[Sqoop_import_from_mssql] JOB[0000000-160711020124641-oozie-oozi-W] ACTION[0000000-160711020124641-oozie-oozi-W@:start:] Start action [0000000-160711020124641-oozie-oozi-W@:start:] with user-retry state : userRetryCount [0], userRetryMax [0], userRetryInterval [10]
2016-07-11 02:02:06,391 INFO org.apache.oozie.command.wf.ActionStartXCommand: SERVER[quickstart.cloudera] USER[root] GROUP[-] TOKEN[] APP[Sqoop_import_from_mssql] JOB[0000000-160711020124641-oozie-oozi-W] ACTION[0000000-160711020124641-oozie-oozi-W@:start:] [***0000000-160711020124641-oozie-oozi-W@:start:***]Action status=DONE
2016-07-11 02:02:06,391 INFO org.apache.oozie.command.wf.ActionStartXCommand: SERVER[quickstart.cloudera] USER[root] GROUP[-] TOKEN[] APP[Sqoop_import_from_mssql] JOB[0000000-160711020124641-oozie-oozi-W] ACTION[0000000-160711020124641-oozie-oozi-W@:start:] [***0000000-160711020124641-oozie-oozi-W@:start:***]Action updated in DB!
2016-07-11 02:02:06,602 INFO org.apache.oozie.command.wf.ActionStartXCommand: SERVER[quickstart.cloudera] USER[root] GROUP[-] TOKEN[] APP[Sqoop_import_from_mssql] JOB[0000000-160711020124641-oozie-oozi-W] ACTION[0000000-160711020124641-oozie-oozi-W@sqoop-408c] Start action [0000000-160711020124641-oozie-oozi-W@sqoop-408c] with user-retry state : userRetryCount [0], userRetryMax [0], userRetryInterval [10]
2016-07-11 02:02:12,084 INFO org.apache.oozie.action.hadoop.SqoopActionExecutor: SERVER[quickstart.cloudera] USER[root] GROUP[-] TOKEN[] APP[Sqoop_import_from_mssql] JOB[0000000-160711020124641-oozie-oozi-W] ACTION[0000000-160711020124641-oozie-oozi-W@sqoop-408c] checking action, hadoop job ID [job_1468217949412_0017] status [RUNNING]
2016-07-11 02:02:12,086 INFO org.apache.oozie.command.wf.ActionStartXCommand: SERVER[quickstart.cloudera] USER[root] GROUP[-] TOKEN[] APP[Sqoop_import_from_mssql] JOB[0000000-160711020124641-oozie-oozi-W] ACTION[0000000-160711020124641-oozie-oozi-W@sqoop-408c] [***0000000-160711020124641-oozie-oozi-W@sqoop-408c***]Action status=RUNNING
2016-07-11 02:02:12,086 INFO org.apache.oozie.command.wf.ActionStartXCommand: SERVER[quickstart.cloudera] USER[root] GROUP[-] TOKEN[] APP[Sqoop_import_from_mssql] JOB[0000000-160711020124641-oozie-oozi-W] ACTION[0000000-160711020124641-oozie-oozi-W@sqoop-408c] [***0000000-160711020124641-oozie-oozi-W@sqoop-408c***]Action updated in DB!
2016-07-11 02:02:23,326 INFO org.apache.oozie.servlet.CallbackServlet: SERVER[quickstart.cloudera] USER[-] GROUP[-] TOKEN[-] APP[-] JOB[0000000-160711020124641-oozie-oozi-W] ACTION[0000000-160711020124641-oozie-oozi-W@sqoop-408c] callback for action [0000000-160711020124641-oozie-oozi-W@sqoop-408c]
2016-07-11 02:02:23,628 INFO org.apache.oozie.action.hadoop.SqoopActionExecutor: SERVER[quickstart.cloudera] USER[root] GROUP[-] TOKEN[] APP[Sqoop_import_from_mssql] JOB[0000000-160711020124641-oozie-oozi-W] ACTION[0000000-160711020124641-oozie-oozi-W@sqoop-408c] action completed, external ID [job_1468217949412_0017]
2016-07-11 02:02:23,683 WARN org.apache.oozie.action.hadoop.SqoopActionExecutor: SERVER[quickstart.cloudera] USER[root] GROUP[-] TOKEN[] APP[Sqoop_import_from_mssql] JOB[0000000-160711020124641-oozie-oozi-W] ACTION[0000000-160711020124641-oozie-oozi-W@sqoop-408c] Launcher ERROR, reason: Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]
2016-07-11 02:02:23,739 INFO org.apache.oozie.command.wf.ActionEndXCommand: SERVER[quickstart.cloudera] USER[root] GROUP[-] TOKEN[] APP[Sqoop_import_from_mssql] JOB[0000000-160711020124641-oozie-oozi-W] ACTION[0000000-160711020124641-oozie-oozi-W@sqoop-408c] ERROR is considered as FAILED for SLA
2016-07-11 02:02:23,786 INFO org.apache.oozie.command.wf.ActionStartXCommand: SERVER[quickstart.cloudera] USER[root] GROUP[-] TOKEN[] APP[Sqoop_import_from_mssql] JOB[0000000-160711020124641-oozie-oozi-W] ACTION[0000000-160711020124641-oozie-oozi-W@Kill] Start action [0000000-160711020124641-oozie-oozi-W@Kill] with user-retry state : userRetryCount [0], userRetryMax [0], userRetryInterval [10]
2016-07-11 02:02:23,793 INFO org.apache.oozie.command.wf.ActionStartXCommand: SERVER[quickstart.cloudera] USER[root] GROUP[-] TOKEN[] APP[Sqoop_import_from_mssql] JOB[0000000-160711020124641-oozie-oozi-W] ACTION[0000000-160711020124641-oozie-oozi-W@Kill] [***0000000-160711020124641-oozie-oozi-W@Kill***]Action status=DONE
2016-07-11 02:02:23,793 INFO org.apache.oozie.command.wf.ActionStartXCommand: SERVER[quickstart.cloudera] USER[root] GROUP[-] TOKEN[] APP[Sqoop_import_from_mssql] JOB[0000000-160711020124641-oozie-oozi-W] ACTION[0000000-160711020124641-oozie-oozi-W@Kill] [***0000000-160711020124641-oozie-oozi-W@Kill***]Action updated in DB!

i'm trying to import data from ms sql server to hdfs using sqoop and running it through oozie via cloudera manager. i've included the sqljdbc4.jar in the /user/oozie/share/lib/lib_<timestamp>/sqoop and /var/lib/sqoop/lib and included it in the workflow's lib folder as well. sqoop as a standalone job without oozie works perfectly without any errors or warnings. please do help me in solving the issue i'm stuck with it for weeks.

1 REPLY 1

Re: sqoop job in oozie gets killed with Launcher ERROR, reason: Main class [org.apache.oozie.action]

Cloudera Employee

Can you please include some launcher log files?