[xwiki-notifications] [Issue] Commented: (XE-172) Cannot upgrade to from 1.1.2 to 1.2 RC2

[Daniel Guenther (JIRA)]

    [ http://jira.xwiki.org/jira/browse/XE-172?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_20670 ] 

Daniel Guenther commented on XE-172:
------------------------------------

Hi Vincent,

thanks for your help.

I replaced the hibernate too. While upgrading it creates new tables, but I get a lot of the following error messages
ORA-01400: cannot insert NULL into ("XWIKI"."XWIKIRCS"."XWR_COMMENT"). XWIKI is not working.

It seems that my current 1.1.2 documents need a comment to get migrated.

> Cannot upgrade to from 1.1.2 to 1.2 RC2
> ---------------------------------------
>
>                 Key: XE-172
>                 URL: http://jira.xwiki.org/jira/browse/XE-172
>             Project: XWiki Enterprise
>          Issue Type: Bug
>          Components: Other
>    Affects Versions: 1.2 RC1
>            Reporter: Martin Vanek
>         Assigned To: Vincent Massol
>             Fix For: 1.2 RC3
>
>
> 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

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.xwiki.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira