java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在

Oracle Community | 937883 | 5 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    THE problem [EPMINS] [ERROR] [EPMINS-00001]

    Oracle Community | 5 years ago | 937883
    java.sql.SQLSyntaxErrorException: ORA-00942: 表或视图不存在
  2. 0

    Fail Deployed application server in EPM  11.1.2.4

    Oracle Community | 2 years ago | 1752932
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  3. 0

    Web Service Configuration -Failed

    Oracle Community | 1 year ago | Ghansham
    java.sql.SQLSyntaxErrorException: ORA-04080: trigger 'LCM-MIGRATION_ID-TRIG' does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    DBUM Connector : java.sql.SQLSyntaxErrorException: ORA-01919: role 'xxx' does not exist

    Oracle Community | 1 year ago | user8744020
    java.sql.SQLSyntaxErrorException: ORA-01919: role 'PSSEL' does not exist
  6. 0

    OIM 11.1.2.3 Create Organization recon event

    Oracle Community | 10 months ago | 1035694
    java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification
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. java.sql.SQLSyntaxErrorException

    ORA-00942: 表或视图不存在

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OracleStatementWrapper.execute
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
    7. oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:202)
    8. oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:1110)
    9. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
    10. oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:2251)
    11. oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:2192)
    12. oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:347)
    12 frames
  3. com.hyperion.hit
    Registry.createBasicComponents
    1. com.hyperion.hit.registry.RegistryConnection.createRegistry(RegistryConnection.java:474)
    2. com.hyperion.hit.registry.RegistryUtils.initUpgradeRegistry(RegistryUtils.java:272)
    3. com.hyperion.hit.registry.RegistryUtils.dropRegistry(RegistryUtils.java:240)
    4. com.hyperion.hit.registry.RegistryUtils.initRegistry(RegistryUtils.java:102)
    5. com.hyperion.hit.registry.Registry.createBasicComponents(Registry.java:2305)
    5 frames
  4. com.hyperion.config
    Storage.initRegistry
    1. com.hyperion.config.document.Storage.initRegistry(Storage.java:245)
    1 frame
  5. com.hyperion.cis
    ConfigRegistryUtils.initializeRegistry
    1. com.hyperion.cis.config.ConfigRegistryUtils.initializeRegistry(ConfigRegistryUtils.java:384)
    1 frame
  6. com.hyperion.config
    RegistryWizardState$1$1.commit
    1. com.hyperion.config.wizard.impl.RegistryWizardState$1$1.commit(RegistryWizardState.java:228)
    1 frame
  7. com.hyperion.hit
    Wizard$NextClass.run
    1. com.hyperion.hit.wizard.Wizard$NextClass.run(Wizard.java:544)
    1 frame
  8. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:662)
    1 frame