If an exception happens during an action's execution, it should show up in the task tracker's log for the single map task that launched the job. This would be the same as the "external id" that Oozie reports when you get info about that job.
- Robert On Fri, Apr 5, 2013 at 10:27 PM, Jarek Jarcec Cecho <jar...@apache.org>wrote: > I'm unfortunately not an Oozie expert, so I'll leave others to chime in > with answering the question how to get entire exception trace. > > Jarcec > > On Thu, Apr 04, 2013 at 04:01:43PM +0100, Dave Cardwell wrote: > > Hi Jarek, > > > > Do you know what log file I’d find that in? It’s not in the job log nor > the > > task tracker’s setup/map/cleanup logs. > > > > > > -- > > Best wishes, > > Dave Cardwell. > > > > http://davecardwell.co.uk/ > > > > > > On 4 April 2013 15:56, Jarek Jarcec Cecho <jar...@apache.org> wrote: > > > > > Hi Dave, > > > do you think that you can share entire stack trace of the exception? I > > > think that I do know where the issue might be, but I would like to > verify > > > that. > > > > > > However please do note that Sqoop is not general query tool and using > it > > > for calling stored procedures is not supported nor recommended use. The > > > tool "eval" is available only for evaluation purpose and should not be > used > > > in any production workflow. > > > > > > Jarcec > > > > > > On Thu, Apr 04, 2013 at 02:28:55PM +0100, Dave Cardwell wrote: > > > > I have a Sqoop action which uses sqoop-eval to call a MySQL stored > > > > procedure. It works fine from the command line, and the call actually > > > > completes in Oozie giving an external status of “SUCCEEDED”, but the > > > > resulting status of the action is ERROR, with the following message: > > > > > > > > IllegalArgumentException: JobId string : is not properly formed > > > > > > > > Here is the action configuration: > > > > > > > > <sqoop xmlns="uri:oozie:sqoop-action:0.2"> > > > > <job-tracker>my.server.com:8021</job-tracker> > > > > <name-node>hdfs://my.server.com:8020</name-node> > > > > <arg>eval</arg> > > > > <arg>--query</arg> > > > > <arg>CALL `move_cdrs_to_working`;</arg> > > > > <arg>--connect</arg> > > > > <arg>jdbc:mysql://my.server.com/my_database</arg> > > > > <arg>--username</arg> > > > > <arg>my_user</arg> > > > > <arg>--password</arg> > > > > <arg>my_password</arg> > > > > </sqoop> > > > > > > > > > > > > The job log: > > > > https://gist.github.com/davecardwell/fd08802d6bdfd901d38a > > > > > > > > > > > > Any ideas? > > > > > > > > -- > > > > Best wishes, > > > > Dave Cardwell. > > > > > > > > http://davecardwell.co.uk/ > > > >
