com.teradata.connector.common.exception.ConnectorException: java.sql.SQLException: [Teradata Database] [TeraJDBC 15.00.00.20] [Error 3802] [SQLState 42S02] Database 'P_STORAGE' does not exist.

Stack Overflow | Prakash M | 2 months ago
  1. 0

    sqoop data from teradata to hdfs using shell script

    Stack Overflow | 2 months ago | Prakash M
    com.teradata.connector.common.exception.ConnectorException: java.sql.SQLException: [Teradata Database] [TeraJDBC 15.00.00.20] [Error 3802] [SQLState 42S02] Database 'P_STORAGE' does not exist.
  2. 0

    Hortonworks Teradata Connector Incremental import : Teradata table to Hive table - Hortonworks

    hortonworks.com | 1 year ago
    com.teradata.connector.common.exception.ConnectorException: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 14.10.00.26] [Error 3706] [SQLState 42000] Syntax error: expected something between an integer and the integer ’12’.
  3. 0

    Hortonworks » All Topics

    rssing.com | 5 months ago
    com.teradata.connector.common.exception.ConnectorException: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 14.10.00.26] [Error 3706] [SQLState 42000] Syntax error: expected something between an integer and the integer ’12’.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    RE: Hortonworks Connector for Teradata + Sqoop Query

    sqoop-user | 2 years ago | Dhandapani, Karthik
    com.teradata.connector.common.exception.ConnectorException: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 14.10.00.26] [Error 3524] [SQLState 42000] The user does not have CREATE VIEW access to database
  6. 0

    Re: Hortonworks Connector for Teradata + Sqoop Query

    sqoop-user | 2 years ago | Whitmore, Mattie [USA]
    com.teradata.connector.common.exception.ConnectorException: com.teradata.jdbc.jdbc_4.util.JDBCException: [Teradata Database] [TeraJDBC 14.10.00.26] [Error 3524] [SQLState 42000] The user does not have CREATE VIEW access to database

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.teradata.connector.common.exception.ConnectorException

      java.sql.SQLException: [Teradata Database] [TeraJDBC 15.00.00.20] [Error 3802] [SQLState 42S02] Database 'P_STORAGE' does not exist.

      at com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException()
    2. com.teradata.jdbc
      TDSession.prepareStatement
      1. com.teradata.jdbc.jdbc_4.util.ErrorFactory.makeDatabaseSQLException(ErrorFactory.java:308)
      2. com.teradata.jdbc.jdbc_4.statemachine.ReceiveInitSubState.action(ReceiveInitSubState.java:109)
      3. com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.subStateMachine(StatementReceiveState.java:307)
      4. com.teradata.jdbc.jdbc_4.statemachine.StatementReceiveState.action(StatementReceiveState.java:196)
      5. com.teradata.jdbc.jdbc_4.statemachine.StatementController.runBody(StatementController.java:123)
      6. com.teradata.jdbc.jdbc_4.statemachine.StatementController.run(StatementController.java:114)
      7. com.teradata.jdbc.jdbc_4.TDStatement.executeStatement(TDStatement.java:385)
      8. com.teradata.jdbc.jdbc_4.TDStatement.prepareRequest(TDStatement.java:569)
      9. com.teradata.jdbc.jdbc_4.TDPreparedStatement.<init>(TDPreparedStatement.java:117)
      10. com.teradata.jdbc.jdk6.JDK6_SQL_PreparedStatement.<init>(JDK6_SQL_PreparedStatement.java:29)
      11. com.teradata.jdbc.jdk6.JDK6_SQL_Connection.constructPreparedStatement(JDK6_SQL_Connection.java:81)
      12. com.teradata.jdbc.jdbc_4.TDSession.prepareStatement(TDSession.java:1357)
      13. com.teradata.jdbc.jdbc_4.TDSession.prepareStatement(TDSession.java:1401)
      14. com.teradata.jdbc.jdbc_4.TDSession.prepareStatement(TDSession.java:1387)
      14 frames
    3. com.teradata.connector
      ConnectorJobRunner.runJob
      1. com.teradata.connector.teradata.db.TeradataConnection.getColumnDescsForSQL(TeradataConnection.java:995)
      2. com.teradata.connector.teradata.db.TeradataConnection.getColumnNamesForSQL(TeradataConnection.java:940)
      3. com.teradata.connector.teradata.utils.TeradataUtils.validateInputTeradataProperties(TeradataUtils.java:315)
      4. com.teradata.connector.teradata.processor.TeradataInputProcessor.validateConfiguration(TeradataInputProcessor.java:91)
      5. com.teradata.connector.teradata.processor.TeradataSplitByPartitionProcessor.validateConfiguration(TeradataSplitByPartitionProcessor.java:412)
      6. com.teradata.connector.teradata.processor.TeradataInputProcessor.inputPreProcessor(TeradataInputProcessor.java:36)
      7. com.teradata.connector.common.tool.ConnectorJobRunner.runJob(ConnectorJobRunner.java:116)
      8. com.teradata.connector.common.tool.ConnectorJobRunner.runJob(ConnectorJobRunner.java:56)
      8 frames
    4. org.apache.sqoop
      Sqoop.run
      1. org.apache.sqoop.teradata.TeradataSqoopImportHelper.runJob(TeradataSqoopImportHelper.java:370)
      2. org.apache.sqoop.teradata.TeradataConnManager.importQuery(TeradataConnManager.java:531)
      3. org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:499)
      4. org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605)
      5. org.apache.sqoop.Sqoop.run(Sqoop.java:148)
      5 frames
    5. Hadoop
      ToolRunner.run
      1. org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
      1 frame
    6. org.apache.sqoop
      Sqoop.main
      1. org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:184)
      2. org.apache.sqoop.Sqoop.runTool(Sqoop.java:226)
      3. org.apache.sqoop.Sqoop.runTool(Sqoop.java:235)
      4. org.apache.sqoop.Sqoop.main(Sqoop.java:244)
      4 frames
    7. com.teradata.connector
      ConnectorJobRunner.runJob
      1. com.teradata.connector.common.tool.ConnectorJobRunner.runJob(ConnectorJobRunner.java:140)
      2. com.teradata.connector.common.tool.ConnectorJobRunner.runJob(ConnectorJobRunner.java:56)
      2 frames
    8. org.apache.sqoop
      Sqoop.run
      1. org.apache.sqoop.teradata.TeradataSqoopImportHelper.runJob(TeradataSqoopImportHelper.java:370)
      2. org.apache.sqoop.teradata.TeradataConnManager.importQuery(TeradataConnManager.java:531)
      3. org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:499)
      4. org.apache.sqoop.tool.ImportTool.run(ImportTool.java:605)
      5. org.apache.sqoop.Sqoop.run(Sqoop.java:148)
      5 frames
    9. Hadoop
      ToolRunner.run
      1. org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70)
      1 frame
    10. org.apache.sqoop
      Sqoop.main
      1. org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:184)
      2. org.apache.sqoop.Sqoop.runTool(Sqoop.java:226)
      3. org.apache.sqoop.Sqoop.runTool(Sqoop.java:235)
      4. org.apache.sqoop.Sqoop.main(Sqoop.java:244)
      4 frames