Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
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)
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB