Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Oozie Workflow with Sqoop Action to Oracle Database Problem

avatar
Rising Star

Hey guys,

I am new with HDP (v2.5 as Sandbox) and I am trying to submit an Oozie job using a Sqoop action to connect to an Oracle Database. I managed to run Oozie jobs with a simple Hive action and a simple Sqoop action (just sending 'version') - both worked. The error occurs when sending the command:

<command>sqoop-list-tables --connect jdbc:oracle:thin:@//XX.XX.XX.XXX:XXXX/NAME --username USER --password PW</command>

The error is:

2016-11-08 15:14:46,581  WARN SqoopActionExecutor:523 - SERVER[sandbox.hortonworks.com] USER[root] GROUP[-] TOKEN[] APP[sqoopaction] JOB[0000065-161107122627815-oozie-oozi-W] ACTION[0000065-161107122627815-oozie-oozi-W@sqoopjob] Launcher ERROR, reason: Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]

Actually, the command is working from the command line so it has something to do with Oozie. At some point I have read that there might be an issue with the ojdbc6.jar file so I copied it to several /lib/ folders without success. To get rid of the spaces inbetween the command I also tried <arg></arg> but it didn't work.

What am I doing wrong here? Any advice is appreciated! I really have no clue what to do and the error log doesn't help.

Thanks and regards,

Ken

(If you need further information just let me know!)

-------------

job.properties:

nameNode=hdfs://sandbox.hortonworks.com:8020
jobTracker=hdfs://sandbox.hortonworks.com:8050
queueName=default
oozie.libpath=${nameNode}/user/oozie/share/lib
oozie.wf.application.path=data/oozie/sqoopaction
oozie.use.system.libpath=true
oozie.action.sharelib.for.sqoop = hive,hcatalog,sqoop
1 ACCEPTED SOLUTION

avatar
Rising Star
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
1 REPLY 1

avatar
Rising Star
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login