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

Oracle Community | 880385 | 5 years ago
  1. 0

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

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

    Server startup issue

    Oracle Community | 6 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
  6. 0

    Initializing child class objects configured using grails discriminator

    Stack Overflow | 2 years ago | Gopal Samant
    java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

  1. Justin 1 times, last 7 months ago
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: 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