java.sql.SQLSyntaxErrorException: ORA-00904: "DEV_OIM"."XL_SP_DBCHECK": invalid identifier

Oracle Community | 2665779 | 3 years ago
  1. 0

    Reg: Error in creating schema by RCu for OIM 11.1.2.2.0

    Oracle Community | 3 years ago | 87f4c891-b4b4-4dec-b7ff-0594536c95b7
    java.sql.SQLSyntaxErrorException: ORA-00904: "DEV_OIM"."XL_SP_DBCHECK": invalid identifier
  2. 0

    Running RCU for OIM R2 PS2 gives error

    Oracle Community | 3 years ago | 2665779
    java.sql.SQLSyntaxErrorException: ORA-00904: "DEV_OIM"."XL_SP_DBCHECK": invalid identifier
  3. 0

    Error installing OIM 11.1.2.2

    Oracle Community | 3 years ago | 87f4c891-b4b4-4dec-b7ff-0594536c95b7
    java.sql.SQLSyntaxErrorException: ORA-00904: "DEV_OIM"."XL_SP_DBCHECK": invalid identifier
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    RCU 11.1.1.7 install fails on Oracle XE on Windows 7 64 bit

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

    hibernate.cfg.xml file error

    Stack Overflow | 1 year ago | user2517370
    org.hibernate.exception.SQLGrammarException: could not extract ResultSet

  1. rafafviola 1 times, last 1 month ago
  2. wendellpereira 128 times, last 2 months ago
  3. balintn 4 times, last 2 months ago
  4. balintn 3 times, last 3 months ago
  5. pnaranja 2 times, last 4 months ago
1 more registered users
30 unregistered visitors
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-00904: "DEV_OIM"."XL_SP_DBCHECK": invalid identifier

    at oracle.jdbc.driver.SQLStateMapping.newSQLException()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
    2. oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
    3. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
    4. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
    5. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
    6. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
    9. oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
    13 frames
  3. oracle.sysman.assistants
    ActualTask.run
    1. oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeQuery(JDBCEngine.java:1203)
    2. oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeQuery(JDBCEngine.java:921)
    3. oracle.sysman.assistants.rcu.backend.validation.PrereqEngine.execute(PrereqEngine.java:100)
    4. oracle.sysman.assistants.rcu.backend.validation.PrereqEngine.execute(PrereqEngine.java:71)
    5. oracle.sysman.assistants.rcu.backend.validation.PrereqHelper.evaluatePrereq(PrereqHelper.java:72)
    6. oracle.sysman.assistants.rcu.backend.validation.PrereqEvaluator.evaluatePrereq(PrereqEvaluator.java:139)
    7. oracle.sysman.assistants.rcu.backend.validation.PrereqEvaluator.evaluatePrereqSet(PrereqEvaluator.java:192)
    8. oracle.sysman.assistants.rcu.backend.validation.PrereqEvaluator.evaluatePrereqSet(PrereqEvaluator.java:146)
    9. oracle.sysman.assistants.rcu.backend.action.AbstractAction.evaluateValidIf(AbstractAction.java:312)
    10. oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:235)
    11. oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:306)
    11 frames
  4. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:662)
    1 frame