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

Oracle Community | Gaff | 6 years ago
  1. 0

    Can't install BI Publisher Scheduler Schema

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

    Extend a baseclass and perform findById in Hibernate

    Stack Overflow | 3 years ago | user3018766
    javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not load an entity: [ExtendedClass#1011361]
  3. 0

    Atom service break Oracle DB support

    GitHub | 2 years ago | davinciagf
    org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Hi, we have recently installed DSpace (version 1.7.1 on Oracle) and put there some training data. Further we tried to search and browse and it didn't work. We realized that no index was created. Then we tried to run index-init and it didn't work, we got back this failure notice tarted: 1323741602223 Ended: 1323741646993 Elapsed time: 44 secs (44770 msecs) Exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist org.dspace.browse.BrowseException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at org.dspace.browse.BrowseCreateDAOOracle.updateCommunityMappings(BrowseCreateDAOOracle.java:641) at org.dspace.browse.IndexBrowse.indexItem(IndexBrowse.java:380) at org.dspace.browse.IndexBrowse.createIndex(IndexBrowse.java:1124) at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:669) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:183) Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.java:225) at org.dspace.browse.BrowseCreateDAOOracle.getAllCommunityIDs(BrowseCreateDAOOracle.java:1060) at org.dspace.browse.BrowseCreateDAOOracle.updateCommunityMappings(BrowseCreateDAOOracle.java:578) ... 8 more Do anaone know how to solve it, or how to successfully create index from metadata in Dspace

    Sakai JIRA | 5 years ago | Anna Andrlová
    org.dspace.browse.BrowseException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
  6. 0

    Hi, we have recently installed DSpace (version 1.7.1 on Oracle) and put there some training data. Further we tried to search and browse and it didn't work. We realized that no index was created. Then we tried to run index-init and it didn't work, we got back this failure notice tarted: 1323741602223 Ended: 1323741646993 Elapsed time: 44 secs (44770 msecs) Exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist org.dspace.browse.BrowseException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at org.dspace.browse.BrowseCreateDAOOracle.updateCommunityMappings(BrowseCreateDAOOracle.java:641) at org.dspace.browse.IndexBrowse.indexItem(IndexBrowse.java:380) at org.dspace.browse.IndexBrowse.createIndex(IndexBrowse.java:1124) at org.dspace.browse.IndexBrowse.main(IndexBrowse.java:669) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:183) Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) at org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.java:225) at org.dspace.browse.BrowseCreateDAOOracle.getAllCommunityIDs(BrowseCreateDAOOracle.java:1060) at org.dspace.browse.BrowseCreateDAOOracle.updateCommunityMappings(BrowseCreateDAOOracle.java:578) ... 8 more Do anaone know how to solve it, or how to successfully create index from metadata in Dspace

    Sakai JIRA | 5 years ago | Anna Andrlová
    org.dspace.browse.BrowseException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

  1. rafafviola 1 times, last 3 weeks 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-00942: table or view does not exist

    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:1035)
    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:1187)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3386)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3430)
    13. oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
    13 frames
  3. Commons DBCP
    DelegatingPreparedStatement.executeQuery
    1. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:205)
    1 frame
  4. quartz
    QuartzInitializerServlet.init
    1. org.quartz.impl.jdbcjobstore.StdJDBCDelegate.selectVolatileTriggers(StdJDBCDelegate.java:3884)
    2. org.quartz.impl.jdbcjobstore.JobStoreSupport.cleanVolatileTriggerAndJobs(JobStoreSupport.java:615)
    3. org.quartz.impl.jdbcjobstore.JobStoreTX.cleanVolatileTriggerAndJobs(JobStoreTX.java:114)
    4. org.quartz.impl.jdbcjobstore.JobStoreSupport.initialize(JobStoreSupport.java:491)
    5. org.quartz.impl.jdbcjobstore.JobStoreTX.initialize(JobStoreTX.java:68)
    6. org.quartz.impl.StdSchedulerFactory.instantiate(StdSchedulerFactory.java:1010)
    7. org.quartz.impl.StdSchedulerFactory.getScheduler(StdSchedulerFactory.java:1152)
    8. org.quartz.ee.servlet.QuartzInitializerServlet.init(QuartzInitializerServlet.java:157)
    8 frames
  5. oracle.apps.xdo
    ExtendedQuartzInitializerServlet.init
    1. oracle.apps.xdo.servlet.scheduler.quartz.ExtendedQuartzInitializerServlet.init(ExtendedQuartzInitializerServlet.java:124)
    1 frame
  6. Atmosphere weblogic
    StubSecurityHelper$ServletInitAction.run
    1. weblogic.servlet.internal.StubSecurityHelper$ServletInitAction.run(StubSecurityHelper.java:283)
    1 frame
  7. weblogic.security.acl
    AuthenticatedSubject.doAs
    1. weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
    1 frame
  8. weblogic.security.service
    SecurityManager.runAs
    1. weblogic.security.service.SecurityManager.runAs(SecurityManager.java:121)
    1 frame
  9. Atmosphere weblogic
    WebAppModule.start
    1. weblogic.servlet.internal.StubSecurityHelper.createServlet(StubSecurityHelper.java:64)
    2. weblogic.servlet.internal.StubLifecycleHelper.createOneInstance(StubLifecycleHelper.java:58)
    3. weblogic.servlet.internal.StubLifecycleHelper.<init>(StubLifecycleHelper.java:48)
    4. weblogic.servlet.internal.ServletStubImpl.prepareServlet(ServletStubImpl.java:531)
    5. weblogic.servlet.internal.WebAppServletContext.preloadServlet(WebAppServletContext.java:1915)
    6. weblogic.servlet.internal.WebAppServletContext.loadServletsOnStartup(WebAppServletContext.java:1889)
    7. weblogic.servlet.internal.WebAppServletContext.preloadResources(WebAppServletContext.java:1807)
    8. weblogic.servlet.internal.WebAppServletContext.start(WebAppServletContext.java:3045)
    9. weblogic.servlet.internal.WebAppModule.startContexts(WebAppModule.java:1397)
    10. weblogic.servlet.internal.WebAppModule.start(WebAppModule.java:460)
    10 frames
  10. weblogic.application.internal
    ModuleStateDriver$3.next
    1. weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
    1 frame
  11. weblogic.application.utils
    StateMachineDriver.nextState
    1. weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
    1 frame
  12. weblogic.application.internal
    ModuleStateDriver$3.next
    1. weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
    2. weblogic.application.internal.flow.ScopedModuleDriver.start(ScopedModuleDriver.java:200)
    3. weblogic.application.internal.flow.ModuleListenerInvoker.start(ModuleListenerInvoker.java:247)
    4. weblogic.application.internal.flow.ModuleStateDriver$3.next(ModuleStateDriver.java:425)
    4 frames
  13. weblogic.application.utils
    StateMachineDriver.nextState
    1. weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
    1 frame
  14. weblogic.application.internal
    BaseDeployment$2.next
    1. weblogic.application.internal.flow.ModuleStateDriver.start(ModuleStateDriver.java:119)
    2. weblogic.application.internal.flow.StartModulesFlow.activate(StartModulesFlow.java:27)
    3. weblogic.application.internal.BaseDeployment$2.next(BaseDeployment.java:1267)
    3 frames
  15. weblogic.application.utils
    StateMachineDriver.nextState
    1. weblogic.application.utils.StateMachineDriver.nextState(StateMachineDriver.java:83)
    1 frame
  16. weblogic.application.internal
    DeploymentStateChecker.activate
    1. weblogic.application.internal.BaseDeployment.activate(BaseDeployment.java:409)
    2. weblogic.application.internal.SingleModuleDeployment.activate(SingleModuleDeployment.java:39)
    3. weblogic.application.internal.DeploymentStateChecker.activate(DeploymentStateChecker.java:161)
    3 frames
  17. weblogic.deploy.internal
    DeploymentServiceDispatcher.commit
    1. weblogic.deploy.internal.targetserver.AppContainerInvoker.activate(AppContainerInvoker.java:79)
    2. weblogic.deploy.internal.targetserver.operations.AbstractOperation.activate(AbstractOperation.java:569)
    3. weblogic.deploy.internal.targetserver.operations.ActivateOperation.activateDeployment(ActivateOperation.java:150)
    4. weblogic.deploy.internal.targetserver.operations.ActivateOperation.doCommit(ActivateOperation.java:116)
    5. weblogic.deploy.internal.targetserver.operations.AbstractOperation.commit(AbstractOperation.java:323)
    6. weblogic.deploy.internal.targetserver.DeploymentManager.handleDeploymentCommit(DeploymentManager.java:844)
    7. weblogic.deploy.internal.targetserver.DeploymentManager.activateDeploymentList(DeploymentManager.java:1253)
    8. weblogic.deploy.internal.targetserver.DeploymentManager.handleCommit(DeploymentManager.java:440)
    9. weblogic.deploy.internal.targetserver.DeploymentServiceDispatcher.commit(DeploymentServiceDispatcher.java:163)
    9 frames
  18. weblogic.deploy.service
    DeploymentReceiverCallbackDeliverer$2.run
    1. weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.doCommitCallback(DeploymentReceiverCallbackDeliverer.java:181)
    2. weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer.access$100(DeploymentReceiverCallbackDeliverer.java:12)
    3. weblogic.deploy.service.internal.targetserver.DeploymentReceiverCallbackDeliverer$2.run(DeploymentReceiverCallbackDeliverer.java:67)
    3 frames
  19. weblogic.work
    ExecuteThread.run
    1. weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:516)
    2. weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
    3. weblogic.work.ExecuteThread.run(ExecuteThread.java:173)
    3 frames