Return-Path: 
 <user-return-17237-apmail-hadoop-mapreduce-user-archive=hadoop.apache.org@hadoop.apache.org>
X-Original-To: apmail-hadoop-mapreduce-user-archive@minotaur.apache.org
Delivered-To: apmail-hadoop-mapreduce-user-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 2B488174DE
	for <apmail-hadoop-mapreduce-user-archive@minotaur.apache.org>;
 Thu,  2 Oct 2014 21:10:26 +0000 (UTC)
Received: (qmail 87055 invoked by uid 500); 2 Oct 2014 21:10:18 -0000
Delivered-To: apmail-hadoop-mapreduce-user-archive@hadoop.apache.org
Received: (qmail 86936 invoked by uid 500); 2 Oct 2014 21:10:18 -0000
Mailing-List: contact user-help@hadoop.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-help@hadoop.apache.org>
List-Unsubscribe: <mailto:user-unsubscribe@hadoop.apache.org>
List-Post: <mailto:user@hadoop.apache.org>
List-Id: <user.hadoop.apache.org>
Reply-To: user@hadoop.apache.org
Delivered-To: mailing list user@hadoop.apache.org
Received: (qmail 86926 invoked by uid 99); 2 Oct 2014 21:10:18 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Oct 2014 21:10:18 +0000
X-ASF-Spam-Status: No, hits=1.5 required=5.0
	tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of preya.2.shah@gmail.com
 designates 209.85.213.54 as permitted sender)
Received: from [209.85.213.54] (HELO mail-yh0-f54.google.com) (209.85.213.54)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Oct 2014 21:09:51 +0000
Received: by mail-yh0-f54.google.com with SMTP id f10so991839yha.41
        for <user@hadoop.apache.org>; Thu, 02 Oct 2014 14:09:50 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20120113;
        h=mime-version:date:message-id:subject:from:to:content-type;
        bh=AdT32ViTmtfbRjJDBr2Y5CiXdGZqnlUdRaEGR4BGxGA=;
        b=Nu46F71ERSNc9z9B3g4aHJZZm5ePboEctFVEg5NHa7ikfhhQ9CMSWzhy1gF0dUyF0x
         u9xyj16vwlSzBF1TjFmSdfsA8kZCAvNMjq6dFEAjtxQqT8C4yCaLvFRSoQ3IZlaNEf7Y
         avO619FAmccLlHAtelNSqCVO7jEVFtADE9Waf5lIGcoPva2yrks+T+wwLYiJ1MpLhr+s
         7SD4nO/lqbbHl85AQT/SDA1ZMUAJC5zabOePK5J6ojs+BhFqJbvP+DZKKTf0tszWQls5
         0YMEeabwE9cmBF9oy+2PFCxBw7S+7X9N0DJNpxHOaJwLxZkMXuL5om518d0z2jDvXmtV
         zTEQ==
MIME-Version: 1.0
X-Received: by 10.236.135.144 with SMTP id u16mr2083670yhi.142.1412284190284;
 Thu, 02 Oct 2014 14:09:50 -0700 (PDT)
Received: by 10.170.71.2 with HTTP; Thu, 2 Oct 2014 14:09:50 -0700 (PDT)
Date: Thu, 2 Oct 2014 14:09:50 -0700
Message-ID: 
 <CAA2GNh6XEP9RDDOSv_HqZXqC5nXQCHq2cPpAoCbR=T_RcpN6_Q@mail.gmail.com>
Subject: Oozie workflow for Sqoop Incremental update
From: Preya Shah <preya.2.shah@gmail.com>
To: user@hadoop.apache.org
Content-Type: multipart/alternative; boundary=20cf301afbbf7be0840504770934
X-Virus-Checked: Checked by ClamAV on apache.org

--20cf301afbbf7be0840504770934
Content-Type: text/plain; charset=UTF-8

Hi I am trying to get updated or newly added data from relational database
using Sqoop. Sqoop command is working fine but when I try to execute it
through the oozie workflow it does not work.

It is giving me below error:
Main class [org.apache.oozie.action.hadoop.SqoopMain], exit code [1]

*workflow.xml file*

<workflow-app xmlns="uri:oozie:workflow:0.2" name="ooziedemo-wf">
    <start to="sqoopIncrImport"/>

    <!-- Sqoop Action for Incremental Import -->
    <action name="sqoopIncrImport">
        <sqoop xmlns="uri:oozie:sqoop-action:0.2">
           <job-tracker>${jobTracker}</job-tracker>
           <name-node>${nameNode}</name-node>
           <prepare>
               <delete path="${nameNode}/user/abc/incr/TEST"/>
           </prepare>
           <arg>import</arg>
           <arg>--connect</arg>
           <arg>${dbURL}</arg>
           <arg>--driver</arg>
           <arg>${myOracleDriver}</arg>
           <arg>--username</arg>
           <arg>${user}</arg>
           <arg>--password</arg>
           <arg>apps</arg>
           <arg>--table</arg>
           <arg>TEST</arg>
           <arg>--warehouse-dir</arg>
           <arg>${nameNode}/user/abc/incr/</arg>
           <arg>--m</arg>
           <arg>1</arg>
        </sqoop>
       <ok to="end"/>
       <error to="fail"/>
   </action>
        <kill name="fail">
        <message>Workflow failed, error
message[${wf:errorMessage(wf:lastErrorNode())}]</message>
   </kill>
   <end name="end"/>
</workflow-app>


Can anyone please help me resolving this issue?

Thanks in advance.

--20cf301afbbf7be0840504770934
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: base64

PGRpdiBkaXI9Imx0ciI+PGRpdj5IaSBJIGFtIHRyeWluZyB0byBnZXQgdXBkYXRlZCBvciBuZXds
eSBhZGRlZCBkYXRhIGZyb20gcmVsYXRpb25hbCBkYXRhYmFzZSB1c2luZyBTcW9vcC4gU3Fvb3Ag
Y29tbWFuZCBpcyB3b3JraW5nIGZpbmUgYnV0IHdoZW4gSSB0cnkgdG8gZXhlY3V0ZSBpdCB0aHJv
dWdoIHRoZSBvb3ppZSB3b3JrZmxvdyBpdCBkb2VzIG5vdCB3b3JrLjxicj48YnI+PC9kaXY+PGRp
dj5JdCBpcyBnaXZpbmcgbWUgYmVsb3cgZXJyb3I6ICANCgkgICAgCQkJPGRpdiBzdHlsZT0id2lk
dGg6MTAwJTttYXgtaGVpZ2h0OjcwcHg7b3ZlcmZsb3c6YXV0bztjb2xvcjpyZWQiPk1haW4gY2xh
c3MgW29yZy5hcGFjaGUub296aWUuYWN0aW9uLmhhZG9vcC5TcW9vcE1haW5dLCBleGl0IGNvZGUg
WzFdPC9kaXY+PC9kaXY+PGRpdj48YnI+PC9kaXY+PGI+d29ya2Zsb3cueG1sIGZpbGU8L2I+PGJy
Pjxicj4mbHQ7d29ya2Zsb3ctYXBwIHhtbG5zPSZxdW90O3VyaTpvb3ppZTp3b3JrZmxvdzowLjIm
cXVvdDsgbmFtZT0mcXVvdDtvb3ppZWRlbW8td2YmcXVvdDsmZ3Q7PGJyPsKgwqDCoCAmbHQ7c3Rh
cnQgdG89JnF1b3Q7c3Fvb3BJbmNySW1wb3J0JnF1b3Q7LyZndDs8YnI+PGJyPsKgwqDCoCAmbHQ7
IS0tIFNxb29wIEFjdGlvbiBmb3IgSW5jcmVtZW50YWwgSW1wb3J0IC0tJmd0Ozxicj7CoMKgwqAg
Jmx0O2FjdGlvbiBuYW1lPSZxdW90O3Nxb29wSW5jckltcG9ydCZxdW90OyZndDs8YnI+wqDCoMKg
wqDCoMKgwqAgJmx0O3Nxb29wIHhtbG5zPSZxdW90O3VyaTpvb3ppZTpzcW9vcC1hY3Rpb246MC4y
JnF1b3Q7Jmd0Ozxicj7CoMKgwqDCoMKgwqDCoMKgwqDCoCAmbHQ7am9iLXRyYWNrZXImZ3Q7JHtq
b2JUcmFja2VyfSZsdDsvam9iLXRyYWNrZXImZ3Q7PGJyPsKgwqDCoMKgwqDCoMKgwqDCoMKgICZs
dDtuYW1lLW5vZGUmZ3Q7JHtuYW1lTm9kZX0mbHQ7L25hbWUtbm9kZSZndDs8YnI+wqDCoMKgwqDC
oMKgwqDCoMKgwqAgJmx0O3ByZXBhcmUmZ3Q7PGJyPsKgwqDCoMKgwqDCoMKgwqDCoMKgwqDCoMKg
wqAgJmx0O2RlbGV0ZSBwYXRoPSZxdW90OyR7bmFtZU5vZGV9L3VzZXIvYWJjL2luY3IvVEVTVCZx
dW90Oy8mZ3Q7PGJyPsKgwqDCoMKgwqDCoMKgwqDCoMKgICZsdDsvcHJlcGFyZSZndDs8YnI+wqDC
oMKgwqDCoMKgwqDCoMKgwqAgJmx0O2FyZyZndDtpbXBvcnQmbHQ7L2FyZyZndDs8YnI+wqDCoMKg
wqDCoMKgwqDCoMKgwqAgJmx0O2FyZyZndDstLWNvbm5lY3QmbHQ7L2FyZyZndDs8YnI+wqDCoMKg
wqDCoMKgwqDCoMKgwqAgJmx0O2FyZyZndDske2RiVVJMfSZsdDsvYXJnJmd0Ozxicj7CoMKgwqDC
oMKgwqDCoMKgwqDCoCAmbHQ7YXJnJmd0Oy0tZHJpdmVyJmx0Oy9hcmcmZ3Q7PGJyPsKgwqDCoMKg
wqDCoMKgwqDCoMKgICZsdDthcmcmZ3Q7JHtteU9yYWNsZURyaXZlcn0mbHQ7L2FyZyZndDs8YnI+
wqDCoMKgwqDCoMKgwqDCoMKgwqAgJmx0O2FyZyZndDstLXVzZXJuYW1lJmx0Oy9hcmcmZ3Q7PGJy
PsKgwqDCoMKgwqDCoMKgwqDCoMKgICZsdDthcmcmZ3Q7JHt1c2VyfSZsdDsvYXJnJmd0Ozxicj7C
oMKgwqDCoMKgwqDCoMKgwqDCoCAmbHQ7YXJnJmd0Oy0tcGFzc3dvcmQmbHQ7L2FyZyZndDs8YnI+
wqDCoMKgwqDCoMKgwqDCoMKgwqAgJmx0O2FyZyZndDthcHBzJmx0Oy9hcmcmZ3Q7PGJyPsKgwqDC
oMKgwqDCoMKgwqDCoMKgICZsdDthcmcmZ3Q7LS10YWJsZSZsdDsvYXJnJmd0Ozxicj7CoMKgwqDC
oMKgwqDCoMKgwqDCoCAmbHQ7YXJnJmd0O1RFU1QmbHQ7L2FyZyZndDs8YnI+wqDCoMKgwqDCoMKg
wqDCoMKgwqAgJmx0O2FyZyZndDstLXdhcmVob3VzZS1kaXImbHQ7L2FyZyZndDs8YnI+wqDCoMKg
wqDCoMKgwqDCoMKgwqAgJmx0O2FyZyZndDske25hbWVOb2RlfS91c2VyL2FiYy9pbmNyLyZsdDsv
YXJnJmd0Ozxicj7CoMKgwqDCoMKgwqDCoMKgwqDCoCAmbHQ7YXJnJmd0Oy0tbSZsdDsvYXJnJmd0
Ozxicj7CoMKgwqDCoMKgwqDCoMKgwqDCoCAmbHQ7YXJnJmd0OzEmbHQ7L2FyZyZndDs8YnI+wqDC
oMKgwqDCoMKgwqAgJmx0Oy9zcW9vcCZndDs8YnI+wqDCoMKgwqDCoMKgICZsdDtvayB0bz0mcXVv
dDtlbmQmcXVvdDsvJmd0Ozxicj7CoMKgwqDCoMKgwqAgJmx0O2Vycm9yIHRvPSZxdW90O2ZhaWwm
cXVvdDsvJmd0Ozxicj7CoMKgICZsdDsvYWN0aW9uJmd0Ozxicj7CoMKgwqDCoMKgwqDCoCAmbHQ7
a2lsbCBuYW1lPSZxdW90O2ZhaWwmcXVvdDsmZ3Q7PGJyPsKgwqDCoMKgwqDCoMKgICZsdDttZXNz
YWdlJmd0O1dvcmtmbG93IGZhaWxlZCwgZXJyb3IgbWVzc2FnZVske3dmOmVycm9yTWVzc2FnZSh3
ZjpsYXN0RXJyb3JOb2RlKCkpfV0mbHQ7L21lc3NhZ2UmZ3Q7PGJyPsKgwqAgJmx0Oy9raWxsJmd0
Ozxicj7CoMKgICZsdDtlbmQgbmFtZT0mcXVvdDtlbmQmcXVvdDsvJmd0Ozxicj4mbHQ7L3dvcmtm
bG93LWFwcCZndDs8YnI+PGJyIGNsZWFyPSJhbGwiPjxkaXY+PGRpdj48ZGl2Pjxicj48L2Rpdj5D
YW4gYW55b25lIHBsZWFzZSBoZWxwIG1lIHJlc29sdmluZyB0aGlzIGlzc3VlPzxicj48YnI+PC9k
aXY+PGRpdj5UaGFua3MgaW4gYWR2YW5jZS48YnI+PC9kaXY+PC9kaXY+PC9kaXY+DQo=
--20cf301afbbf7be0840504770934--