Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Sqoop, mail # user - OraOop error: cannot be called unless RememberSqoopJobType() has been used


Copy link to this message
-
Re: OraOop error: cannot be called unless RememberSqoopJobType() has been used
Jarek Jarcec Cecho 2013-09-12, 06:32
Hi Alexey,
It seems to be working for me, so I'm not sure what might went wrong. I would suggest you to create a bug report on OraOop [1] JIRA.

Jarcec

Links:
1: https://questmos.jira.com/browse/ORAOOP

On Fri, Sep 06, 2013 at 12:35:14PM +0400, Алексей Филановский wrote:
> Hi all!
>
> [root@cdh ~]# sqoop version
> Sqoop 1.4.2-cdh4.2.1
> git commit id a0862dc56393e3096c65d6ca26766c67f5ab5309
> Compiled by jenkins on Mon Apr 22 11:36:27 PDT 2013
>
> and
>
> Quest Connector for Oracle and Hadoop 1.6
> <http://downloads.cloudera.com/connectors/oraoop-1.6.0-cdh4.tgz>
>
>
> 2013/9/4 Jarek Jarcec Cecho <[EMAIL PROTECTED]>
>
> > Hi Alexey,
> > would you mind be a bit more specific? What exact version of Sqoop and
> > what exact version of OraOop are you using?
> >
> > Jarcec
> >
> > On Mon, Sep 02, 2013 at 03:11:23PM +0300, Alexey Filanovskiy wrote:
> > > Hi!
> > >
> > > 1.4
> > >
> > > Отправлено с iPad
> > >
> > > 02.09.2013, в 11:55, Jarek Jarcec Cecho <[EMAIL PROTECTED]> написал(а):
> > >
> > > > Hi Alexey,
> > > > what Sqoop and OraOop version are you using?
> > > >
> > > > Jarcec
> > > >
> > > > On Fri, Aug 30, 2013 at 11:55:03AM +0400, Алексей Филановский wrote:
> > > >> Hi all!
> > > >>
> > > >> I install OraOop as pointed in instruction:
> > > >> http://archive.cloudera.com/cdh/3/adapters/oraoopuserguide.pdf<
> > http://archive.cloudera.com/cdh/4/adapters/oraoopuserguide.pdf>
> > > >>
> > > >> And try to use OraOop,but get error:
> > > >>
> > > >> [oracle@db11203x64 ~]$ sqoop import   --connection-manager
> > > >> com.quest.oraoop.OraOopConnManager    --connect
> > > >> jdbc:oracle:thin:@//localhost:1521/orcl
> > > >>   --username demouser --password welcome1 --table
> > DEMOUSER.GUP_PROFILE_V2
> > > >> 13/08/30 03:15:45 WARN tool.BaseSqoopTool: Setting your password on
> > the
> > > >> command-line is insecure. Consider using -P instead.
> > > >> 13/08/30 03:15:45 INFO manager.SqlManager: Using default fetchSize of
> > 1000
> > > >> 13/08/30 03:15:45 INFO tool.CodeGenTool: Beginning code generation
> > > >> 13/08/30 03:15:48 ERROR sqoop.Sqoop: Got exception running Sqoop:
> > > >> java.lang.RuntimeException: RecallSqoopJobType() cannot be called
> > unless
> > > >> RememberSqoopJobType() has been used.
> > > >> java.lang.RuntimeException: RecallSqoopJobType() cannot be called
> > unless
> > > >> RememberSqoopJobType() has been used.
> > > >>        at
> > > >>
> > com.quest.oraoop.OraOopUtilities.recallSqoopJobType(OraOopUtilities.java:757)
> > > >>        at
> > > >>
> > com.quest.oraoop.OraOopConnManager.getColumnNamesInOracleTable(OraOopConnManager.java:115)
> > > >>        at
> > > >>
> > com.quest.oraoop.OraOopConnManager.getSelectedColumnNamesInOracleTable(OraOopConnManager.java:135)
> > > >>        at
> > > >>
> > com.quest.oraoop.OraOopConnManager.getColTypesQuery(OraOopConnManager.java:198)
> > > >>        at
> > > >>
> > org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:220)
> > > >>        at
> > > >>
> > com.quest.oraoop.OraOopConnManager.getColumnTypes(OraOopConnManager.java:460)
> > > >>        at
> > > >>
> > org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:283)
> > > >>        at
> > > >> org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1268)
> > > >>        at
> > org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1080)
> > > >>        at
> > > >> org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:96)
> > > >>        at
> > org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:390)
> > > >>        at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:476)
> > > >>        at org.apache.sqoop.Sqoop.run(Sqoop.java:145)
> > > >>        at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
> > > >>        at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)
> > > >>        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)
> > > >>        at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)
> > > >>        at org.apache.sqoop.Sqoop.main(Sqoop.java:238)