Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-16495

Cannot create subwikis on Oracle: ORA-00942: table or view does not exist

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 11.5-rc-1
    • Fix Version/s: 11.6-rc-1
    • Component/s: Old Core
    • Labels:
    • Environment:
      Windows 10 Pro 64 bit, Firefox 67, using a local instance of XWiki 11.5RC1 on Oracle 12c
    • Tests:
      Integration
    • Difficulty:
      Unknown
    • Documentation:
      N/A
    • Documentation in Release Notes:
      N/A
    • Similar issues:

      Description

      STEPS TO REPRODUCE

      1. Configure and create a XWiki 11.5RC1 instance with Oracle (11.2 or 12c)
      2. Go to Wiki Index
      3. Click 'Create Wiki'
      4. Type a Pretty Name for the new subwiki (e.g. subwikiglobal)
      5. Select Standard Flavor
      6. Click 'Next Step'
      7. Select an 'User Scope' and a 'Membership Type'
      8. Click 'Create'

      EXPECTED RESULTS

      The subwiki is created successfully.

      ACTUAL RESULTS

      The subwiki could not be created, some errors are encountered both in browser and in console. Partial stacktrace:

      2019-06-19 12:10:47,640 [com.xpn.xwiki.internal.WikiInitializerJob@40a6ed56([initialization, wiki, subwikiglobal])] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: 942, SQLState: 42000 
      2019-06-19 12:10:47,641 [com.xpn.xwiki.internal.WikiInitializerJob@40a6ed56([initialization, wiki, subwikiglobal])] ERROR o.h.e.j.s.SqlExceptionHelper   - ORA-00942: tabelul sau vizualizarea nu există
       
      2019-06-19 12:10:47,647 [com.xpn.xwiki.internal.WikiInitializerJob@40a6ed56([initialization, wiki, subwikiglobal])] ERROR .HibernateDataMigrationManager - Database subwikiglobal seems to be inaccessible, please check your configuration! 
      com.xpn.xwiki.store.migration.DataMigrationException: Failed to get the database version
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.getDBVersionFromDatabase(HibernateDataMigrationManager.java:139)
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.getDataMigrationStatus(AbstractDataMigrationManager.java:422)
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.getDatabaseStatus(AbstractDataMigrationManager.java:565)
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:533)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:569)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:530)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:707)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:577)
      	at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:909)
      	at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:365)
      	at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2007)
      	at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2069)
      	at com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1395)
      	at com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1362)
      	at com.xpn.xwiki.internal.WikiInitializerJob.runInternal(WikiInitializerJob.java:108)
      	at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:236)
      	at org.xwiki.job.AbstractJob.run(AbstractJob.java:213)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      	at java.lang.Thread.run(Unknown Source)
      Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:826)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:889)
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.getDBVersionFromDatabase(HibernateDataMigrationManager.java:124)
      	... 19 common frames omitted
      Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      	at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
      	at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1538)
      	at org.hibernate.query.Query.getResultList(Query.java:165)
      	at org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.getResultList(CriteriaQueryTypeQueryAdapter.java:76)
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$1.doInHibernate(HibernateDataMigrationManager.java:133)
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$1.doInHibernate(HibernateDataMigrationManager.java:125)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:820)
      	... 21 common frames omitted
      Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
      	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
      	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
      	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
      	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:69)
      	at org.hibernate.loader.Loader.getResultSet(Loader.java:2171)
      	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1934)
      	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1896)
      	at org.hibernate.loader.Loader.doQuery(Loader.java:936)
      	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:339)
      	at org.hibernate.loader.Loader.doList(Loader.java:2693)
      	at org.hibernate.loader.Loader.doList(Loader.java:2676)
      	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2510)
      	at org.hibernate.loader.Loader.list(Loader.java:2505)
      	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:504)
      	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:396)
      	at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219)
      	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1537)
      	at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1561)
      	at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1529)
      	... 26 common frames omitted
      Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: tabelul sau vizualizarea nu există
      
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
      	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
      	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
      	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
      	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
      	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747)
      	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
      	at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822)
      	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
      	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60)
      	... 41 common frames omitted
      Caused by: oracle.jdbc.OracleDatabaseException: ORA-00942: tabelul sau vizualizarea nu există
      
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
      	... 59 common frames omitted
      2019-06-19 12:10:47,659 [com.xpn.xwiki.internal.WikiInitializerJob@40a6ed56([initialization, wiki, subwikiglobal])] ERROR c.x.x.XWiki                    - Failed to initialize mandatory document 
      com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document [subwikiglobal:XWiki.Notifications.Code.NotificationFilterDisplayerClass]
      	at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:1039)
      	at com.xpn.xwiki.store.XWikiCacheStore.loadXWikiDoc(XWikiCacheStore.java:365)
      	at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2007)
      	at com.xpn.xwiki.XWiki.getDocument(XWiki.java:2069)
      	at com.xpn.xwiki.XWiki.initializeMandatoryDocument(XWiki.java:1395)
      	at com.xpn.xwiki.XWiki.initializeMandatoryDocuments(XWiki.java:1362)
      	at com.xpn.xwiki.internal.WikiInitializerJob.runInternal(WikiInitializerJob.java:108)
      	at org.xwiki.job.AbstractJob.runInContext(AbstractJob.java:236)
      	at org.xwiki.job.AbstractJob.run(AbstractJob.java:213)
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      	at java.lang.Thread.run(Unknown Source)
      Caused by: com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while switching to database subwikiglobal
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:575)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:530)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:707)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:577)
      	at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:909)
      	... 11 common frames omitted
      Caused by: com.xpn.xwiki.store.migration.DataMigrationException: Database subwikiglobal seems to be inaccessible, please check your configuration!
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.getDatabaseStatus(AbstractDataMigrationManager.java:570)
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:533)
      	at com.xpn.xwiki.internal.store.hibernate.HibernateStore.setWiki(HibernateStore.java:569)
      	... 15 common frames omitted
      Caused by: com.xpn.xwiki.store.migration.DataMigrationException: Failed to get the database version
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.getDBVersionFromDatabase(HibernateDataMigrationManager.java:139)
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.getDataMigrationStatus(AbstractDataMigrationManager.java:422)
      	at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.getDatabaseStatus(AbstractDataMigrationManager.java:565)
      	... 17 common frames omitted
      Caused by: com.xpn.xwiki.XWikiException: Error number 0 in 3: Exception while hibernate execute
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:826)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:889)
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager.getDBVersionFromDatabase(HibernateDataMigrationManager.java:124)
      	... 19 common frames omitted
      Caused by: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      	at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)
      	at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1538)
      	at org.hibernate.query.Query.getResultList(Query.java:165)
      	at org.hibernate.query.criteria.internal.compile.CriteriaQueryTypeQueryAdapter.getResultList(CriteriaQueryTypeQueryAdapter.java:76)
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$1.doInHibernate(HibernateDataMigrationManager.java:133)
      	at com.xpn.xwiki.store.migration.hibernate.HibernateDataMigrationManager$1.doInHibernate(HibernateDataMigrationManager.java:125)
      	at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:820)
      	... 21 common frames omitted
      Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet
      	at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)
      	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)
      	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)
      	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)
      	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:69)
      	at org.hibernate.loader.Loader.getResultSet(Loader.java:2171)
      	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1934)
      	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1896)
      	at org.hibernate.loader.Loader.doQuery(Loader.java:936)
      	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:339)
      	at org.hibernate.loader.Loader.doList(Loader.java:2693)
      	at org.hibernate.loader.Loader.doList(Loader.java:2676)
      	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2510)
      	at org.hibernate.loader.Loader.list(Loader.java:2505)
      	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:504)
      	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:396)
      	at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:219)
      	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1537)
      	at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1561)
      	at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1529)
      	... 26 common frames omitted
      Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: tabelul sau vizualizarea nu există
      
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
      	at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
      	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
      	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
      	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
      	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
      	at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747)
      	at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)
      	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
      	at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
      	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822)
      	at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
      	at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:122)
      	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60)
      	... 41 common frames omitted
      Caused by: oracle.jdbc.OracleDatabaseException: ORA-00942: tabelul sau vizualizarea nu există
      
      	at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
      	... 59 common frames omitted

      Please also find the log attached from Oracle 12c.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                tmortagne Thomas Mortagne
                Reporter:
                iandriuta Ilie Andriuta
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: