org.dspace.browse.BrowseException: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Sakai JIRA | Anna Andrlová | 5 years ago
  1. 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
  2. 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
  3. 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]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Atom service break Oracle DB support

    GitHub | 2 years ago | davinciagf
    org.hibernate.exception.SQLGrammarException: could not extract ResultSet
  6. 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
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.T4CTTIoer.processError()
  2. Oracle jdbc
    OraclePreparedStatementWrapper.executeQuery
    1. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
    2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
    3. oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
    4. oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
    5. oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
    6. oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
    7. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
    8. oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
    9. oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
    10. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
    11. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
    12. oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
    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:96)
    2. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    3. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    3 frames
  4. DSpace Kernel :: API and Implementation
    IndexBrowse.main
    1. org.dspace.storage.rdbms.DatabaseManager.queryTable(DatabaseManager.java:225)
    2. org.dspace.browse.BrowseCreateDAOOracle.getAllCommunityIDs(BrowseCreateDAOOracle.java:1060)
    3. org.dspace.browse.BrowseCreateDAOOracle.updateCommunityMappings(BrowseCreateDAOOracle.java:578)
    4. org.dspace.browse.IndexBrowse.indexItem(IndexBrowse.java:380)
    5. org.dspace.browse.IndexBrowse.createIndex(IndexBrowse.java:1124)
    6. org.dspace.browse.IndexBrowse.main(IndexBrowse.java:669)
    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. DSpace Kernel :: API and Implementation
    ScriptLauncher.main
    1. org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:183)
    1 frame