[bcc:sqoop-u...@cloudera.org, to:sqoop-user@incubator.apache.org. Please move the conversation over to Apache mailing list].
Hi Sonal, You are likely running into [SQOOP-222]. Try specifying the username/password for the user that is associated with the EMP table instead of scott/tiger. [SQOOP-222] https://issues.cloudera.org/browse/SQOOP-222 Thanks, Arvind On Thu, Aug 4, 2011 at 3:46 AM, Sonal <imsonalku...@gmail.com> wrote: > Hi, > > Am trying for the sqoop-export with following command: > sqoop-export --connect jdbc:oracle:thin:@adc2190481.us.oracle.com: > 1521:qooptry --username scott --password tiger --table "EMP" --export- > dir SQOOP_TEST > > scoop version: > Sqoop 1.3.0-cdh3u1 > git commit id 3a60cc809b14d538dd1eb0e90ffa9767e8d06a43 > Compiled by jenkins@ubuntu-slave01 on Mon Jul 18 08:38:49 PDT 2011 > > It is failing with > ERROR manager.OracleManager: Failed to rollback transaction > ERROR manager.OracleManager: Failed to list columns > 11/08/04 03:39:49 ERROR sqoop.Sqoop: Got exception running Sqoop: > java.lang.IllegalArgumentException: Field names must be greater than 0 > > 11/08/04 03:39:47 WARN tool.BaseSqoopTool: Setting your password on > the command-line is insecure. Consider using -P instead. > 11/08/04 03:39:47 INFO manager.SqlManager: Using default fetchSize of > 1000 > 11/08/04 03:39:47 INFO tool.CodeGenTool: Beginning code generation > 11/08/04 03:39:47 INFO manager.OracleManager: Time zone has been set > to GMT > 11/08/04 03:39:47 INFO manager.SqlManager: Executing SQL statement: > SELECT t.* FROM EMP t WHERE 1=0 > 11/08/04 03:39:47 WARN manager.SqlManager: SQLException closing > ResultSet: java.sql.SQLException: Could not commit with auto-commit > set on > 11/08/04 03:39:47 ERROR manager.OracleManager: Failed to rollback > transaction > java.sql.SQLException: Could not rollback with auto-commit set on > at > oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java: > 3988) > at > com.cloudera.sqoop.manager.OracleManager.getColumnNames(OracleManager.java: > 669) > at > com.cloudera.sqoop.orm.ClassWriter.getColumnNames(ClassWriter.java: > 1154) > at > com.cloudera.sqoop.orm.ClassWriter.generate(ClassWriter.java:1029) > at > com.cloudera.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82) > at > com.cloudera.sqoop.tool.ExportTool.exportTable(ExportTool.java:64) > at com.cloudera.sqoop.tool.ExportTool.run(ExportTool.java:110) > at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) > at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180) > at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:219) > at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:228) > at com.cloudera.sqoop.Sqoop.main(Sqoop.java:237) > 11/08/04 03:39:47 ERROR manager.OracleManager: Failed to list columns > java.sql.SQLException: Could not commit with auto-commit set on > at > oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java: > 3926) > at > oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java: > 3973) > at > com.cloudera.sqoop.manager.OracleManager.getColumnNames(OracleManager.java: > 666) > at > com.cloudera.sqoop.orm.ClassWriter.getColumnNames(ClassWriter.java: > 1154) > at > com.cloudera.sqoop.orm.ClassWriter.generate(ClassWriter.java:1029) > at > com.cloudera.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:82) > at > com.cloudera.sqoop.tool.ExportTool.exportTable(ExportTool.java:64) > at com.cloudera.sqoop.tool.ExportTool.run(ExportTool.java:110) > at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) > at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180) > at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:219) > at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:228) > at com.cloudera.sqoop.Sqoop.main(Sqoop.java:237) > 11/08/04 03:39:47 INFO orm.CompilationManager: HADOOP_HOME is /usr/lib/ > hadoop > 11/08/04 03:39:47 INFO orm.CompilationManager: Found hadoop core jar > at: /usr/lib/hadoop/hadoop-0.20.2+737-core.jar > Note: /tmp/sqoop-sonkumar/compile/a51ce8fa8e7e85f00e02dbd1e0ea38b6/ > EMP.java uses or overrides a deprecated API. > Note: Recompile with -Xlint:deprecation for details. > 11/08/04 03:39:49 ERROR orm.CompilationManager: Could not rename /tmp/ > sqoop-sonkumar/compile/a51ce8fa8e7e85f00e02dbd1e0ea38b6/EMP.java to / > net/adc2190481/scratch/sonkumar/view_storage/sonkumar_sqooptry/work/./ > EMP.java > java.io.IOException: Destination '/net/adc2190481/scratch/sonkumar/ > view_storage/sonkumar_sqooptry/work/./EMP.java' already exists > at org.apache.commons.io.FileUtils.moveFile(FileUtils.java: > 1811) > at > com.cloudera.sqoop.orm.CompilationManager.compile(CompilationManager.java: > 227) > at > com.cloudera.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:83) > at > com.cloudera.sqoop.tool.ExportTool.exportTable(ExportTool.java:64) > at com.cloudera.sqoop.tool.ExportTool.run(ExportTool.java:110) > at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) > at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180) > at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:219) > at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:228) > at com.cloudera.sqoop.Sqoop.main(Sqoop.java:237) > 11/08/04 03:39:49 INFO orm.CompilationManager: Writing jar file: /tmp/ > sqoop-sonkumar/compile/a51ce8fa8e7e85f00e02dbd1e0ea38b6/EMP.jar > 11/08/04 03:39:49 INFO mapreduce.ExportJobBase: Beginning export of > EMP > 11/08/04 03:39:49 ERROR manager.OracleManager: Failed to rollback > transaction > java.lang.NullPointerException > at > com.cloudera.sqoop.manager.OracleManager.getColumnNames(OracleManager.java: > 669) > at > com.cloudera.sqoop.mapreduce.JdbcExportJob.configureOutputFormat(JdbcExportJob.java: > 84) > at > com.cloudera.sqoop.mapreduce.ExportJobBase.runExport(ExportJobBase.java: > 331) > at > com.cloudera.sqoop.manager.OracleManager.exportTable(OracleManager.java: > 375) > at > com.cloudera.sqoop.tool.ExportTool.exportTable(ExportTool.java:73) > at com.cloudera.sqoop.tool.ExportTool.run(ExportTool.java:110) > at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) > at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180) > at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:219) > at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:228) > at com.cloudera.sqoop.Sqoop.main(Sqoop.java:237) > 11/08/04 03:39:49 ERROR manager.OracleManager: Failed to list columns > java.sql.SQLException: Could not rollback with auto-commit set on > at > oracle.jdbc.driver.PhysicalConnection.rollback(PhysicalConnection.java: > 3988) > at com.cloudera.sqoop.manager.OracleManager > $ConnCache.getConnection(OracleManager.java:179) > at > com.cloudera.sqoop.manager.OracleManager.makeConnection(OracleManager.java: > 268) > at > com.cloudera.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java: > 51) > at > com.cloudera.sqoop.manager.OracleManager.getColumnNames(OracleManager.java: > 656) > at > com.cloudera.sqoop.mapreduce.JdbcExportJob.configureOutputFormat(JdbcExportJob.java: > 84) > at > com.cloudera.sqoop.mapreduce.ExportJobBase.runExport(ExportJobBase.java: > 331) > at > com.cloudera.sqoop.manager.OracleManager.exportTable(OracleManager.java: > 375) > at > com.cloudera.sqoop.tool.ExportTool.exportTable(ExportTool.java:73) > at com.cloudera.sqoop.tool.ExportTool.run(ExportTool.java:110) > at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) > at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180) > at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:219) > at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:228) > at com.cloudera.sqoop.Sqoop.main(Sqoop.java:237) > 11/08/04 03:39:49 ERROR sqoop.Sqoop: Got exception running Sqoop: > java.lang.IllegalArgumentException: Field names must be greater than 0 > java.lang.IllegalArgumentException: Field names must be greater than 0 > at > com.cloudera.sqoop.mapreduce.db.DBOutputFormat.setOutput(DBOutputFormat.java: > 205) > at > com.cloudera.sqoop.mapreduce.JdbcExportJob.configureOutputFormat(JdbcExportJob.java: > 86) > at > com.cloudera.sqoop.mapreduce.ExportJobBase.runExport(ExportJobBase.java: > 331) > at > com.cloudera.sqoop.manager.OracleManager.exportTable(OracleManager.java: > 375) > at > com.cloudera.sqoop.tool.ExportTool.exportTable(ExportTool.java:73) > at com.cloudera.sqoop.tool.ExportTool.run(ExportTool.java:110) > at com.cloudera.sqoop.Sqoop.run(Sqoop.java:144) > at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65) > at com.cloudera.sqoop.Sqoop.runSqoop(Sqoop.java:180) > at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:219) > at com.cloudera.sqoop.Sqoop.runTool(Sqoop.java:228) > at com.cloudera.sqoop.Sqoop.main(Sqoop.java:237) > > can anyone help , what is the cause for it? > > Thanks & Regards, > Sonal > > -- > NOTE: The mailing list sqoop-u...@cloudera.org is deprecated in favor of > Apache Sqoop mailing list sqoop-user@incubator.apache.org. Please subscribe > to it by sending an email to incubator-sqoop-user-subscr...@apache.org. >
