You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Ranjana Rajendran (JIRA)" <ji...@apache.org> on 2014/07/12 00:41:04 UTC

[jira] [Created] (SQOOP-1373) Sqoop import schema is locked shows NullPointerException

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)