java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long

Oracle Community | Kszysztof | 2 years ago
  1. 0

    ORA-00972: identifier is too long

    Oracle Community | 2 years ago | Kszysztof
    java.sql.SQLSyntaxErrorException: ORA-00972: identifier is too long
  2. 0

    IKM SQL to Hyperion Essbase (Data) Error

    Oracle Community | 5 years ago | ankist
    java.sql.SQLSyntaxErrorException: ORA-00936: missing expression
  3. 0

    Help required: Error when execute the Interface.

    Oracle Community | 4 years ago | AMSI
    java.sql.SQLSyntaxErrorException: ORA-00923: FROM keyword not found where expected
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Using Database Sequence in Interface with Union

    Oracle Community | 4 years ago | Sai
    java.sql.SQLSyntaxErrorException: ORA-02287: sequence number not allowed here
  6. 0

    ODI-1227: Task SrcSet0 (Loading) fails on the source ORACLE connection

    Oracle Community | 4 years ago | 988501
    java.sql.SQLSyntaxErrorException: ORA-00904: "C1_PERSON_FIRST_NAME": invalid identifier
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-00972: identifier is too long

    at oracle.jdbc.driver.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    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.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:217)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:947)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1283)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1441)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3823)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1671)
    13 frames
  3. oracle.odi.query
    JDBCTemplate.executeQuery
    1. oracle.odi.query.JDBCTemplate.executeQuery(JDBCTemplate.java:189)
    1 frame
  4. oracle.odi.runtime
    DataMovementTaskExecutionHandler.handleTask
    1. oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:94)
    2. oracle.odi.runtime.agent.execution.sql.SQLDataProvider.readData(SQLDataProvider.java:1)
    3. oracle.odi.runtime.agent.execution.DataMovementTaskExecutionHandler.handleTask(DataMovementTaskExecutionHandler.java:70)
    3 frames
  5. com.sunopsis.dwg
    SnpSession.treatSession
    1. com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2913)
    2. com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
    3. com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:577)
    4. com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:468)
    5. com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
    5 frames
  6. oracle.odi.runtime
    StartSessRequestProcessor$2.doAction
    1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:366)
    1 frame
  7. oracle.odi.core
    DwgObjectTemplate.execute
    1. oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
    1 frame
  8. oracle.odi.runtime
    DefaultAgentTaskExecutor$2.run
    1. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:300)
    2. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:292)
    3. oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:855)
    4. oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
    5. oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
    5 frames
  9. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:745)
    1 frame