java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification

Oracle Community | 1035694 | 5 months ago
  1. 0

    OIM 11.1.2.3 Create Organization recon event

    Oracle Community | 5 months ago | 1035694
    java.sql.SQLSyntaxErrorException: ORA-01747: invalid user.table.column, table.column, or column specification
  2. 0

    Error executing a Oracle query when connection is fetched from Datasource

    Oracle Community | 4 years ago | 992632
    java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier
  3. 0

    Error Installing CS delivery - Table or view does not exist?

    Oracle Community | 4 years ago | 785434
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Cant provision user using AD connector (9.1.1.7.2) in OIM (11.1.1.5.0)

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

    Error executing a Oracle specific query when connection is fetched from Datasource

    Coderanch | 4 years ago | Rob Eddy
    java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier

    3 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-01747: invalid user.table.column, table.column, or column specification

      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. weblogic.jdbc.wrapper
      Statement.execute
      1. weblogic.jdbc.wrapper.Statement.execute(Statement.java:485)
      1 frame
    4. oracle.iam.reconciliation
      ReconActionDao$13.process
      1. oracle.iam.reconciliation.dao.ReconActionDao$13.process(ReconActionDao.java:1545)
      2. oracle.iam.reconciliation.dao.ReconActionDao$13.process(ReconActionDao.java:1531)
      2 frames
    5. oracle.iam.platform
      OIMTransactionCallback.doInTransaction
      1. oracle.iam.platform.tx.OIMTransactionCallback.doInTransaction(OIMTransactionCallback.java:13)
      2. oracle.iam.platform.tx.OIMTransactionCallback.doInTransaction(OIMTransactionCallback.java:6)
      2 frames
    6. Spring Tx
      TransactionTemplate.execute
      1. org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128)
      1 frame
    7. oracle.iam.platform
      OIMTransactionManager.execute
      1. oracle.iam.platform.tx.OIMTransactionManager.execute(OIMTransactionManager.java:22)
      1 frame
    8. oracle.iam.reconciliation
      ActionEngine.processEvent
      1. oracle.iam.reconciliation.dao.ReconActionDao.executeOrgMatch(ReconActionDao.java:1531)
      2. oracle.iam.reconciliation.impl.OrganizationHandler.executeSingleEventMatch(OrganizationHandler.java:37)
      3. oracle.iam.reconciliation.impl.EntityTypeHandler.match(EntityTypeHandler.java:56)
      4. oracle.iam.reconciliation.impl.ActionEngine.processEvent(ActionEngine.java:173)
      4 frames