java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Oracle Community | 880385 | 6 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    OIA+OIM: Import Users, Accounts, User Role Memberships and Entitlements

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

    Server startup issue

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

    cache.cluster.multicast.ip and Installing Oracle Identity Analytics

    Oracle Community | 6 years ago | 801070
    java.sql.SQLSyntaxErrorException: ORA-00904: "HASH_VALUE": invalid identifier
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    java.sql.SQLSyntaxErrorException: unexpected token: ACTN_VAL required: LOCAL

    Stack Overflow | 2 years ago | user3625105
    java.sql.SQLSyntaxErrorException: unexpected token: ACTN_VAL required: LOCAL

Root Cause Analysis

  1. java.sql.SQLSyntaxErrorException

    ORA-00942: table or view does not exist

    at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate()
  2. Spring Framework
    AbstractFallbackSQLExceptionTranslator.translate
    1. org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:220)
    2. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
    2 frames
  3. Spring ORM
    SqlMapClientTemplate.queryForList
    1. org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:212)
    2. org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:249)
    3. org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:296)
    4. org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:290)
    4 frames
  4. com.vaau.rbacx
    RbacxIAMServiceImpl.dataLoad
    1. com.vaau.rbacx.iam.db.dao.ibatis.SqlMapIamDbUserDao.findAllUserIds(SqlMapIamDbUserDao.java:48)
    2. com.vaau.rbacx.iam.db.manager.IamDbUserManagerImpl.getUserIds(IamDbUserManagerImpl.java:48)
    3. com.vaau.rbacx.iam.db.helpers.IamDbUserImporterImpl.readUsers(IamDbUserImporterImpl.java:78)
    4. com.vaau.rbacx.iam.db.DBIAMSolution.doDataLoad(DBIAMSolution.java:547)
    5. com.vaau.rbacx.iam.db.DBIAMSolution.loadData(DBIAMSolution.java:284)
    6. com.vaau.rbacx.iam.service.impl.RbacxIAMServiceImpl.dataLoad(RbacxIAMServiceImpl.java:510)
    6 frames
  5. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    4. java.lang.reflect.Method.invoke(Method.java:597)
    4 frames
  6. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
    3 frames
  7. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
    1 frame
  8. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
    2 frames
  9. Unknown
    $Proxy135.dataLoad
    1. $Proxy135.dataLoad(Unknown Source)
    1 frame
  10. com.vaau.rbacx
    AbstractJob.execute
    1. com.vaau.rbacx.scheduling.executor.iam.DbIamJobExecutor.execute(DbIamJobExecutor.java:83)
    2. com.vaau.rbacx.scheduling.manager.providers.quartz.jobs.AbstractJob.execute(AbstractJob.java:72)
    2 frames
  11. quartz
    JobRunShell.run
    1. org.quartz.core.JobRunShell.run(JobRunShell.java:202)
    1 frame