Ranjana Rajendran created SQOOP-1373:
----------------------------------------
Summary: Sqoop import schema is locked shows NullPointerException
Key: SQOOP-1373
URL: https://issues.apache.org/jira/browse/SQOOP-1373
Project: Sqoop
Issue Type: Improvement
Components: connectors/oracle, connectors/sqlserver
Affects Versions: 1.4.4
Environment: This was seen on Sqoop which came with CDH5.0.2.
Reporter: Ranjana Rajendran
Priority: Minor
Fix For: 1.4.5
The target Oracle database was locked and we were trying to do
import-all-tables and import table from that database. We get a
NullPointerException instead of 'database is locked'.
> sqoop import-all-tables --connect jdbc:oracle:thin:@cor:1521/database name
> --username xxxxx -P --verbose -m 1
Warning:
/opt/cloudera/parcels/CDH-5.0.2-1.cdh5.0.2.p0.13/bin/../lib/sqoop/../accumulo
does not exist! Accumulo imports will fail.
Please set $ACCUMULO_HOME to the root of your Accumulo installation.
14/07/10 12:47:03 INFO sqoop.Sqoop: Running Sqoop version: 1.4.4-cdh5.0.2
14/07/10 12:47:03 DEBUG tool.BaseSqoopTool: Enabled debug logging.
Enter password:
14/07/10 12:47:07 DEBUG sqoop.ConnFactory: Loaded manager factory:
com.cloudera.sqoop.manager.DefaultManagerFactory
14/07/10 12:47:07 DEBUG sqoop.ConnFactory: Trying ManagerFactory:
com.cloudera.sqoop.manager.DefaultManagerFactory
14/07/10 12:47:07 DEBUG manager.DefaultManagerFactory: Trying with scheme:
jdbc:oracle:thin:@cor
14/07/10 12:47:07 DEBUG manager.OracleManager$ConnCache: Instantiated new
connection cache.
14/07/10 12:47:07 INFO manager.SqlManager: Using default fetchSize of 1000
14/07/10 12:47:07 DEBUG sqoop.ConnFactory: Instantiated ConnManager
org.apache.sqoop.manager.OracleManager@5560c7a8
14/07/10 12:47:07 DEBUG manager.OracleManager: Creating a new connection for
jdbc:oracle:thin:@cor:1521/pitaqa.accidentfund.com, using username: underwriting
14/07/10 12:47:07 DEBUG manager.OracleManager: No connection paramenters
specified. Using regular API for making connection.
14/07/10 12:47:08 ERROR sqoop.Sqoop: Got exception running Sqoop:
java.lang.NullPointerException
java.lang.NullPointerException
at
org.apache.sqoop.manager.OracleManager.listTables(OracleManager.java:751)
at
org.apache.sqoop.tool.ImportAllTablesTool.run(ImportAllTablesTool.java:95)
at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:222)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:231)
at org.apache.sqoop.Sqoop.main(Sqoop.java:240)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
