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

Database schema update issue when migrating from XE 1.1.2 to 1.2 RC2 on Oracle 10g

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.2 RC2
    • Fix Version/s: 1.2 RC3
    • Component/s: Storage
    • Labels:
      None
    • Environment:
      oracle
    • Similar issues:

      Description

      SW: OracleAS 10.1.3.2 + OracleDB 10.2.0.?
      Steps:
      1. deploy 1.1.2 war
      2. import enterprise 1.1.2 xar (works so far)
      3. deploy 1.2 RC2 war
      4. exception while accessing first page
      java.sql.SQLException: ORA-00942: table or view does not exist

      at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316)
      at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282)
      at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639)
      at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:185)
      at oracle.jdbc.driver.T4CPreparedStatement.execute_for_describe(T4CPreparedStatement.java:503)
      at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:1029)
      at oracle.jdbc.driver.T4CPreparedStatement.execute_maybe_describe(T4CPreparedStatement.java:535)
      at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1126)
      at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3001)
      at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3043)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
      at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
      at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:139)
      at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
      at org.hibernate.loader.Loader.doQuery(Loader.java:662)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
      at org.hibernate.loader.Loader.doList(Loader.java:2145)
      at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029)
      at org.hibernate.loader.Loader.list(Loader.java:2024)
      at org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:94)
      at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1552)
      at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:283)
      at org.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:305)
      at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager$1.doInHibernate(XWikiHibernateMigrationManager.java:64)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:918)
      at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:947)
      at com.xpn.xwiki.store.migration.hibernate.XWikiHibernateMigrationManager.getDBVersion(XWikiHibernateMigrationManager.java:60)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrationsForDatabase(AbstractXWikiMigrationManager.java:140)
      at com.xpn.xwiki.store.migration.AbstractXWikiMigrationManager.startMigrations(AbstractXWikiMigrationManager.java:102)
      at com.xpn.xwiki.XWiki.initXWiki(XWiki.java:721)
      at com.xpn.xwiki.XWiki.<init>(XWiki.java:672)

      Steps 2:
      1. deploy 1.1.2 war
      2. import enterprise 1.1.2 xar (works so far)
      3. import enterprise 1.2 RC2 xar (works so far)
      4. deploy 1.2 RC2 war
      5. same exception while accessing first page

        Attachments

          Activity

            People

            Assignee:
            vmassol Vincent Massol
            Reporter:
            anthavio Martin Vanek
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Date of First Response: