This issue has been created
There are 3 updates.
 
 
XWiki Platform / cid:jira-generated-image-avatar-fb7a7be5-61f6-4551-a352-f8702aca6abf XWIKI-24490 Open

ORA-00932 error which prevents upgrading from instances pre XWiki 13.10.x to instances post XWiki 18.0.x on Oracle
 
View issue   ·   Add comment
 

Issue created

 
cid:jira-generated-image-avatar-ba5d1f73-2910-4791-8716-fb6c28200a71 Ilie Andriuta created this issue on 15/Jun/26 19:52
 
Summary: ORA-00932 error which prevents upgrading from instances pre XWiki 13.10.x to instances post XWiki 18.0.x on Oracle
Issue Type: cid:jira-generated-image-avatar-fb7a7be5-61f6-4551-a352-f8702aca6abf Bug
Affects Versions: 18.1.0
Assignee: Unassigned
Attachments: Tomcat_11_Oracle_logs_13_4_7_to_18_4_0.txt, localhost.2026-06-15.log
Created: 15/Jun/26 19:52
Environment: Windows 11 Pro, Firefox 151, using an instance of XWiki 18.4.0 on Oracle 19c, Tomcat 11.0.22
Priority: cid:jira-generated-image-static-blocker-c064304f-8337-47fd-88ac-fc98180e42ea Blocker
Reporter: Ilie Andriuta
Description:

Steps to reproduce

  1. Create an older instance of XWiki pre 13.10.x (e.g. 13.9 or older) on Oracle 19c (tested with a local (non-docker) Tomcat 9.0.118, Java 17, using the XWiki Oracle Docker image and JDBC 11 connector)
  2. Close the instance
  3. Prepare a Tomcat 11 instance, copy the [...]webapps\xwiki folder of the new XWiki version (e.g. 18.4.0) and configure it with Oracle (insert the JDBC 11 connector as well in the WEB-INF\lib folder)
  4. Copy the permanent folder (e.g. Catalina) from the Tomcat 9 instance into Tomcat 11 instance
  5. Start XWiki
  6. Access the instance in the browser and observe the migration

Expected results

The upgrade process is completed successfully without errors. The Distribution Wizard is displayed and can be completed in order to upgrade XWiki.

Actual results

After the instance is initialized, the upgrade fails and there are many errors in the logs, such as:

2026-06-15 16:24:13,028 [XWiki initialization] ERROR nDocumentCustomizationDetector - Failed to get document [xwiki:XWiki.DocumentTreeMacros()] from database.
com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document [xwiki:XWiki.DocumentTreeMacros()]
        at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:1233)
        at com.xpn.xwiki.store.XWikiCacheStore.lambda$loadXWikiDoc$2(XWikiCacheStore.java:436)
       [...]
        at org.xwiki.job.AbstractJob.run(AbstractJob.java:223)
        at java.base/java.lang.Thread.run(Thread.java:1474)
Caused by: com.xpn.xwiki.XWikiException: Error number 3301 in 3: Exception while initializing the database
        at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:772)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.beginTransaction(XWikiHibernateBaseStore.java:601)
        at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:1082)
        ... 39 common frames omitted
Caused by: com.xpn.xwiki.store.migration.DataMigrationException: Migration of database [xwiki] has failed, it could not be safely used! Database is currently in version [140401000] while the required version is [180100000].
        at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.preventAccessToOutdatedDb(AbstractDataMigrationManager.java:636)
        at com.xpn.xwiki.store.migration.AbstractDataMigrationManager.checkDatabase(AbstractDataMigrationManager.java:587)
        at com.xpn.xwiki.internal.store.hibernate.HibernateStore.beginTransaction(HibernateStore.java:770)
        ... 41 common frames omitted
Caused by: com.xpn.xwiki.store.migration.DataMigrationException: Data migration 140600000XWIKI19869 failed
        at com.xpn.xwiki.store.migration.hibernate.AbstractHibernateDataMigration.migrate(AbstractHibernateDataMigration.java:119)
        [...]
        at com.xpn.xwiki.XWiki.<init>(XWiki.java:1251)
        at com.xpn.xwiki.internal.XWikiInitializerJob.runInternal(XWikiInitializerJob.java:103)
        ... 3 common frames omitted
Caused by: com.xpn.xwiki.store.migration.DataMigrationException: Error while querying the list of users
        at com.xpn.xwiki.store.migration.hibernate.R140600000XWIKI19869DataMigration.getUsers(R140600000XWIKI19869DataMigration.java:213)
        at com.xpn.xwiki.store.migration.hibernate.R140600000XWIKI19869DataMigration.hibernateMigrate(R140600000XWIKI19869DataMigration.java:165)
        at com.xpn.xwiki.store.migration.hibernate.AbstractHibernateDataMigration.migrate(AbstractHibernateDataMigration.java:117)
        ... 27 common frames omitted
Caused by: org.xwiki.query.QueryException: Exception while executing query. Query statement = [ select distinct doc.fullName from XWikiDocument as doc , BaseObject as objUser , com.xpn.xwiki.objects.PasswordProperty as objUser_password1 where ( objUser_password1.value not like 'hash:%' and objUser_password1.value <> '' ) and doc.fullName=objUser.name and objUser.className='XWiki.XWikiUsers' and objUser_password1.id.id=objUser.id and objUser_password1.id.name='password' order by doc.fullName ]
        at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:219)
        at org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:72)
        at org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:306)
        at org.xwiki.query.xwql.internal.XWQLQueryExecutor.execute(XWQLQueryExecutor.java:117)
        at org.xwiki.query.internal.DefaultQueryExecutorManager.execute(DefaultQueryExecutorManager.java:72)
        at org.xwiki.query.internal.DefaultQuery.execute(DefaultQuery.java:306)
        at com.xpn.xwiki.store.migration.hibernate.R140600000XWIKI19869DataMigration.getUsers(R140600000XWIKI19869DataMigration.java:209)
        ... 29 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:860)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.executeRead(XWikiHibernateBaseStore.java:927)
        at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.execute(HqlQueryExecutor.java:208)
        ... 35 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:1626)
        at com.xpn.xwiki.store.hibernate.query.HqlQueryExecutor.lambda$execute$0(HqlQueryExecutor.java:211)
        at com.xpn.xwiki.store.XWikiHibernateBaseStore.execute(XWikiHibernateBaseStore.java:851)
        ... 37 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:37)
        [...]
        at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1617)
        ... 39 common frames omitted
Caused by: java.sql.SQLSyntaxErrorException: ORA-00932: tipuri de date inconsistente: se aştepta -, s-a primit CLOB

        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:630)
        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:564)
        at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1231)
        at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:772)
        at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299)
        at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:512)
        at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:163)
        at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:1010)
        at oracle.jdbc.driver.OracleStatement.prepareDefineBufferAndExecute(OracleStatement.java:1271)
        at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1149)
        at oracle.jdbc.driver.OracleStatement.executeSQLSelect(OracleStatement.java:1661)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1470)
        at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3761)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3936)
        at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1102)
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:123)
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:123)
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:123)
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57)
        ... 54 common frames omitted
Caused by: Error : 932, Position : 210, Sql = select distinct xwikidocum0_.XWD_FULLNAME as col_0_0_ from xwikidoc xwikidocum0_ cross join xwikiobjects baseobject1_ cross join xwikipasswords passwordpr2_ where (passwordpr2_.XWP_VALUE not like 'hash:%') and passwordpr2_.XWP_VALUE<>'' and xwikidocum0_.XWD_FULLNAME=baseobject1_.XWO_NAME and baseobject1_.XWO_CLASSNAME='XWiki.XWikiUsers' and passwordpr2_.XWP_ID=baseobject1_.XWO_ID and passwordpr2_.XWP_NAME='password' orderby xwikidocum0_.XWD_FULLNAME fetch first :1  rows only, OriginalSql = select distinct xwikidocum0_.XWD_FULLNAME as col_0_0_ from xwikidoc xwikidocum0_ cross join xwikiobjects baseobject1_ cross join xwikipasswords passwordpr2_ where (passwordpr2_.XWP_VALUE not like 'hash:%') and passwordpr2_.XWP_VALUE<>'' and xwikidocum0_.XWD_FULLNAME=baseobject1_.XWO_NAME and baseobject1_.XWO_CLASSNAME='XWiki.XWikiUsers' and passwordpr2_.XWP_ID=baseobject1_.XWO_ID and passwordpr2_.XWP_NAME='password' order by xwikidocum0_.XWD_FULLNAME fetch first ? rows only, Error Msg = ORA-00932: tipuri de date inconsistente: se aştepta -, s-a primit CLOB

        at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:637)
        ... 72 common frames omitted
2026-06-15 16:24:13,029 [XWiki initialization] ERROR PreferencesConfigurationSource - Failed to access configuration value for property [core.defaultDocumentSyntax]. Ignoring by returning null
com.xpn.xwiki.XWikiException: Error number 3202 in 3: Exception while reading document [xwiki:XWiki.XWikiPreferences()]
        at com.xpn.xwiki.store.XWikiHibernateStore.loadXWikiDoc(XWikiHibernateStore.java:1233)
        at com.xpn.xwiki.store.XWikiCacheStore.lambda$loadXWikiDoc$2(XWikiCacheStore.java:436)
        at org.xwiki.cache.internal.CacheLoader$LoaderEntry.lambda$new$0(CacheLoader.java:71)
        at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:328)
        [...]
        at org.xwiki.job.AbstractJob.run(AbstractJob.java:223)
        at java.base/java.lang.Thread.run(Thread.java:1474)

The error is:

ORA-00932: inconsistent datatypes: expected - got CLOB

 
The issue could be reproduced when upgrading starting with XWiki pre 13.10.x (worked when upgrading 13.10.11 to 18.4.0, but 13.9 to 18.4.0 failed) to XWiki post 18.0.0 (e.g. upgrading from 13.9 to 18.0.0 works, but 13.9 to 18.1.0 up to 18.4.0 included, failed).

The issue could not be reproduced when upgrading to XWiki 17.10.9.

I also tested by upgrading to XWiki 18.4.0 on MySQL 9.7, MariaDB 12.3 and PostgreSQL 17, but the issue didn't reproduce.

Please find the attached logs.
 
 

3 updates

 
cid:jira-generated-image-avatar-ba5d1f73-2910-4791-8716-fb6c28200a71 Changes by Ilie Andriuta on 15/Jun/26 19:52
 
Fix Version: 18.5.0-rc-1
Fix Version: 18.4.2
Labels: oracle regression
 
 
This message was sent by Atlassian Jira (v9.3.0#930000-sha1:287aeb6) Atlassian logo
If image attachments aren't displayed, see this article.