There are 3 comments.
 
 
XWiki Platform / cid:jira-generated-image-avatar-004e7cea-72f8-4c21-bf99-7b722a82e072 XWIKI-16535 Open

Excel not imported properly, cells aren't in the right columns
 
View issue   ยท   Add comment
 

3 comments

 
cid:jira-generated-image-avatar-044f2ac5-cfeb-49e2-8127-004442b66eec Vincent Massol on 16/Jul/26 17:20
 

So I've tried to reproduce and for now the issue is in saving the import. It fails with:

Caused by: org.hibernate.exception.DataException: could not execute statement
        at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:52)
        at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37)
        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.executeUpdate(ResultSetReturnImpl.java:200)
        at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:46)
        at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3571) 
        at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3438)
        at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3870) 
        at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:202)
        at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
        at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
        at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:986)
        at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
        at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344)
        at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40)
        at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107)
        at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1407)
        ... 273 common frames omitted
Caused by: java.sql.SQLDataException: data exception: string data, right truncation
        at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
        at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source)
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:137)
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:137)
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197)
        ... 286 common frames omitted
Caused by: org.hsqldb.HsqlException: data exception: string data, right truncation
        at org.hsqldb.error.Error.error(Unknown Source) 
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.types.CharacterType.castOrConvertToType(Unknown Source)
        at org.hsqldb.types.CharacterType.convertToType(Unknown Source)
        at org.hsqldb.StatementDML.getUpdatedData(Unknown Source)
        at org.hsqldb.StatementDML.executeUpdateStatement(Unknown Source)
        at org.hsqldb.StatementDML.getResult(Unknown Source)
        at org.hsqldb.StatementDMQL.execute(Unknown Source)
        at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
        at org.hsqldb.Session.execute(Unknown Source)

After putting some debugging log, the issue is that hsqldb can't save the XWD_CONTENT as it's too large.

2026-07-16 17:13:17,958 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] DEBUG o.h.SQL                        - update xwikidoc set XWD_FULLNAME=?, XWD_NAME=?, XWD_TITLE=?, XWD_LANGUAGE=?, XWD_DEFAULT_LANGUAGE=?, XWD_TRANSLATION=?, XWD_DATE=?, XWD_CONTENT_UPDATE_DATE=?, XWD_CREATION_DATE=?, XWD_AUTHOR=?, XWD_CONTENT_AUTHOR=?, XWD_CREATOR=?, XWD_WEB=?, XWD_CONTENT=?, XWD_VERSION=?, XWD_CUSTOM_CLASS=?, XWD_PARENT=?, XWD_CLASS_XML=?, XWD_ELEMENTS=?, XWD_DEFAULT_TEMPLATE=?, XWD_VALIDATION_SCRIPT=?, XWD_COMMENT=?, XWD_MINOREDIT=?, XWD_SYNTAX_ID=?, XWD_HIDDEN=?, XWD_ORIGINAL_METADATA_AUTHOR=?, XWD_ENFORCE_REQUIRED_RIGHTS=? where XWD_ID=?
2026-07-16 17:13:17,959 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [1] as [VARCHAR] - [xxx5.WebHome]
2026-07-16 17:13:17,959 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [2] as [VARCHAR] - [WebHome]
2026-07-16 17:13:17,959 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [3] as [VARCHAR] - []
2026-07-16 17:13:17,959 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [4] as [VARCHAR] - []
2026-07-16 17:13:17,959 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [5] as [VARCHAR] - []
2026-07-16 17:13:17,959 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [6] as [INTEGER] - [0]
2026-07-16 17:13:17,962 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [7] as [TIMESTAMP] - [Thu Jul 16 17:13:10 CEST 2026]
2026-07-16 17:13:17,962 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [8] as [TIMESTAMP] - [Thu Jul 16 17:13:10 CEST 2026]
2026-07-16 17:13:17,962 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [9] as [TIMESTAMP] - [Thu Jul 16 17:13:06 CEST 2026]
2026-07-16 17:13:17,962 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [10] as [VARCHAR] - [XWiki.Admin]
2026-07-16 17:13:17,962 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [11] as [VARCHAR] - [XWiki.Admin]
2026-07-16 17:13:17,962 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [12] as [VARCHAR] - [XWiki.Admin]
2026-07-16 17:13:17,962 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [13] as [VARCHAR] - [xxx5]
2026-07-16 17:13:18,027 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [14] as [LONGVARCHAR] - [... very large text here...]
2026-07-16 17:13:20,987 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [15] as [VARCHAR] - [2.1]
2026-07-16 17:13:20,989 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [16] as [VARCHAR] - []
2026-07-16 17:13:20,989 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [17] as [VARCHAR] - []
2026-07-16 17:13:20,989 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [18] as [LONGVARCHAR] - []
2026-07-16 17:13:20,989 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [19] as [INTEGER] - [0]
2026-07-16 17:13:20,990 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [20] as [VARCHAR] - []
2026-07-16 17:13:20,998 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [21] as [VARCHAR] - []
2026-07-16 17:13:20,998 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [22] as [VARCHAR] - [Created by office importer.]
2026-07-16 17:13:20,999 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [23] as [BOOLEAN] - [false]
2026-07-16 17:13:20,999 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [24] as [VARCHAR] - [xwiki/2.1]
2026-07-16 17:13:20,999 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [25] as [BOOLEAN] - [false]
2026-07-16 17:13:20,999 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [26] as [VARCHAR] - [XWiki.Admin]
2026-07-16 17:13:21,013 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [27] as [BOOLEAN] - [false]
2026-07-16 17:13:21,014 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [28] as [BIGINT] - [-7356002035525458629]
2026-07-16 17:13:21,050 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: -3401, SQLState: 22001
2026-07-16 17:13:21,050 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] ERROR o.h.e.j.s.SqlExceptionHelper   - data exception: string data, right truncation
2026-07-16 17:13:21,082 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] ERROR .s.OfficeImporterScriptService - Error while saving document [xwiki:xxx5.WebHome].
 
cid:jira-generated-image-avatar-044f2ac5-cfeb-49e2-8127-004442b66eec Vincent Massol on 16/Jul/26 17:21
 
So I've tried to reproduce and for now the issue is in saving the import. It fails with:

{noformat}
Caused by: org.hibernate.exception.DataException: could not execute statement
        at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:52)
        at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37)
        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.executeUpdate(ResultSetReturnImpl.java:200)
        at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:46)
        at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3571)
        at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3438)
        at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3870)
        at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:202)
        at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
        at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
        at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:986)
        at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
        at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344)
        at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40)
        at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107)
        at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1407)
        ... 273 common frames omitted
Caused by: java.sql.SQLDataException: data exception: string data, right truncation
        at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
        at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source)
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:137)
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:137)
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197)
        ... 286 common frames omitted
Caused by: org.hsqldb.HsqlException: data exception: string data, right truncation
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.types.CharacterType.castOrConvertToType(Unknown Source)
        at org.hsqldb.types.CharacterType.convertToType(Unknown Source)
        at org.hsqldb.StatementDML.getUpdatedData(Unknown Source)
        at org.hsqldb.StatementDML.executeUpdateStatement(Unknown Source)
        at org.hsqldb.StatementDML.getResult(Unknown Source)
        at org.hsqldb.StatementDMQL.execute(Unknown Source)
        at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
        at org.hsqldb.Session.execute(Unknown Source)
{noformat}

After putting some debugging log, the issue is that hsqldb can't save the XWD_CONTENT as it's too large.

{noformat}
2026-07-16 17:13:17,958 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] DEBUG o.h.SQL                     - update xwikidoc set XWD_FULLNAME=?, XWD_NAME=?, XWD_TITLE=?, XWD_LANGUAGE=?, XWD_DEFAULT_LANGUAGE=?, XWD_TRANSLATION=?, XWD_DATE=?, XWD_CONTENT_UPDATE_DATE=?, XWD_CREATION_DATE=?, XWD_AUTHOR=?, XWD_CONTENT_AUTHOR=?, XWD_CREATOR=?, XWD_WEB=?, XWD_CONTENT=?, XWD_VERSION=?, XWD_CUSTOM_CLASS=?, XWD_PARENT=?, XWD_CLASS_XML=?, XWD_ELEMENTS=?, XWD_DEFAULT_TEMPLATE=?, XWD_VALIDATION_SCRIPT=?, XWD_COMMENT=?, XWD_MINOREDIT=?, XWD_SYNTAX_ID=?, XWD_HIDDEN=?, XWD_ORIGINAL_METADATA_AUTHOR=?, XWD_ENFORCE_REQUIRED_RIGHTS=? where XWD_ID=?
2026-07-16 17:13:17,959 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [1] as [VARCHAR] - [xxx5.WebHome]
2026-07-16 17:13:17,959 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [2] as [VARCHAR] - [WebHome]
2026-07-16 17:13:17,959 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [3] as [VARCHAR] - []
2026-07-16 17:13:17,959 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [4] as [VARCHAR] - []
2026-07-16 17:13:17,959 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [5] as [VARCHAR] - []
2026-07-16 17:13:17,959 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [6] as [INTEGER] - [0]
2026-07-16 17:13:17,962 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [7] as [TIMESTAMP] - [Thu Jul 16 17:13:10 CEST 2026]
2026-07-16 17:13:17,962 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [8] as [TIMESTAMP] - [Thu Jul 16 17:13:10 CEST 2026]
2026-07-16 17:13:17,962 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [9] as [TIMESTAMP] - [Thu Jul 16 17:13:06 CEST 2026]
2026-07-16 17:13:17,962 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [10] as [VARCHAR] - [XWiki.Admin]
2026-07-16 17:13:17,962 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [11] as [VARCHAR] - [XWiki.Admin]
2026-07-16 17:13:17,962 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [12] as [VARCHAR] - [XWiki.Admin]
2026-07-16 17:13:17,962 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [13] as [VARCHAR] - [xxx5]
2026-07-16 17:13:18,027 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [14] as [LONGVARCHAR] - [... very large text here...]
2026-07-16 17:13:20,987 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [15] as [VARCHAR] - [2.1]
2026-07-16 17:13:20,989 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [16] as [VARCHAR] - []
2026-07-16 17:13:20,989 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [17] as [VARCHAR] - []
2026-07-16 17:13:20,989 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [18] as [LONGVARCHAR] - []
2026-07-16 17:13:20,989 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [19] as [INTEGER] - [0]
2026-07-16 17:13:20,990 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [20] as [VARCHAR] - []
2026-07-16 17:13:20,998 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [21] as [VARCHAR] - []
2026-07-16 17:13:20,998 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [22] as [VARCHAR] - [Created by office importer.]
2026-07-16 17:13:20,999 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [23] as [BOOLEAN] - [false]
2026-07-16 17:13:20,999 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [24] as [VARCHAR] - [xwiki/2.1]
2026-07-16 17:13:20,999 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [25] as [BOOLEAN] - [false]
2026-07-16 17:13:20,999 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [26] as [VARCHAR] - [XWiki.Admin]
2026-07-16 17:13:21,013 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [27] as [BOOLEAN] - [false]
2026-07-16 17:13:21,014 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [28] as [BIGINT] - [-7356002035525458629]
2026-07-16 17:13:21,050 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: -3401, SQLState: 22001
2026-07-16 17:13:21,050 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] ERROR o.h.e.j.s.SqlExceptionHelper   - data exception: string data, right truncation
2026-07-16 17:13:21,082 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] ERROR .s.OfficeImporterScriptService - Error while saving document [xwiki:xxx5.WebHome].
{noformat}
For ref the logs I've configured were:

{noformat}
<logger name="org.hibernate.SQL" level="DEBUG"/>                    
<logger name="org.hibernate.type.descriptor.sql.BasicBinder" level="TRACE"/>   
{noformat}
 
cid:jira-generated-image-avatar-044f2ac5-cfeb-49e2-8127-004442b66eec Vincent Massol on 16/Jul/26 17:22
 
So I've tried to reproduce and for now the issue is in saving the import. It fails with:

{noformat}
Caused by: org.hibernate.exception.DataException: could not execute statement
        at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:52)
        at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37)
        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.executeUpdate(ResultSetReturnImpl.java:200)
        at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:46)
        at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3571)
        at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3438)
        at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3870)
        at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:202)
        at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)
        at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
        at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:986)
        at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
        at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344)
        at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40)
        at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107)
        at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1407)
        ... 273 common frames omitted
Caused by: java.sql.SQLDataException: data exception: string data, right truncation
        at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
        at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
        at org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source)
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:137)
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:137)
        at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:197)
        ... 286 common frames omitted
Caused by: org.hsqldb.HsqlException: data exception: string data, right truncation
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.error.Error.error(Unknown Source)
        at org.hsqldb.types.CharacterType.castOrConvertToType(Unknown Source)
        at org.hsqldb.types.CharacterType.convertToType(Unknown Source)
        at org.hsqldb.StatementDML.getUpdatedData(Unknown Source)
        at org.hsqldb.StatementDML.executeUpdateStatement(Unknown Source)
        at org.hsqldb.StatementDML.getResult(Unknown Source)
        at org.hsqldb.StatementDMQL.execute(Unknown Source)
        at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
        at org.hsqldb.Session.execute(Unknown Source)
{noformat}

After putting some debugging log, the issue is that hsqldb can't save the XWD_CONTENT as it's too large.

{noformat}
2026-07-16 17:13:17,958 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] DEBUG o.h.SQL                     - update xwikidoc set XWD_FULLNAME=?, XWD_NAME=?, XWD_TITLE=?, XWD_LANGUAGE=?, XWD_DEFAULT_LANGUAGE=?, XWD_TRANSLATION=?, XWD_DATE=?, XWD_CONTENT_UPDATE_DATE=?, XWD_CREATION_DATE=?, XWD_AUTHOR=?, XWD_CONTENT_AUTHOR=?, XWD_CREATOR=?, XWD_WEB=?, XWD_CONTENT=?, XWD_VERSION=?, XWD_CUSTOM_CLASS=?, XWD_PARENT=?, XWD_CLASS_XML=?, XWD_ELEMENTS=?, XWD_DEFAULT_TEMPLATE=?, XWD_VALIDATION_SCRIPT=?, XWD_COMMENT=?, XWD_MINOREDIT=?, XWD_SYNTAX_ID=?, XWD_HIDDEN=?, XWD_ORIGINAL_METADATA_AUTHOR=?, XWD_ENFORCE_REQUIRED_RIGHTS=? where XWD_ID=?
2026-07-16 17:13:17,959 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [1] as [VARCHAR] - [xxx5.WebHome]
2026-07-16 17:13:17,959 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [2] as [VARCHAR] - [WebHome]
2026-07-16 17:13:17,959 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [3] as [VARCHAR] - []
2026-07-16 17:13:17,959 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [4] as [VARCHAR] - []
2026-07-16 17:13:17,959 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [5] as [VARCHAR] - []
2026-07-16 17:13:17,959 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [6] as [INTEGER] - [0]
2026-07-16 17:13:17,962 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [7] as [TIMESTAMP] - [Thu Jul 16 17:13:10 CEST 2026]
2026-07-16 17:13:17,962 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [8] as [TIMESTAMP] - [Thu Jul 16 17:13:10 CEST 2026]
2026-07-16 17:13:17,962 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [9] as [TIMESTAMP] - [Thu Jul 16 17:13:06 CEST 2026]
2026-07-16 17:13:17,962 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [10] as [VARCHAR] - [XWiki.Admin]
2026-07-16 17:13:17,962 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [11] as [VARCHAR] - [XWiki.Admin]
2026-07-16 17:13:17,962 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [12] as [VARCHAR] - [XWiki.Admin]
2026-07-16 17:13:17,962 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [13] as [VARCHAR] - [xxx5]
2026-07-16 17:13:18,027 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [14] as [LONGVARCHAR] - [... very large text here...]
2026-07-16 17:13:20,987 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [15] as [VARCHAR] - [2.1]
2026-07-16 17:13:20,989 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [16] as [VARCHAR] - []
2026-07-16 17:13:20,989 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [17] as [VARCHAR] - []
2026-07-16 17:13:20,989 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [18] as [LONGVARCHAR] - []
2026-07-16 17:13:20,989 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [19] as [INTEGER] - [0]
2026-07-16 17:13:20,990 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [20] as [VARCHAR] - []
2026-07-16 17:13:20,998 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [21] as [VARCHAR] - []
2026-07-16 17:13:20,998 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [22] as [VARCHAR] - [Created by office importer.]
2026-07-16 17:13:20,999 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [23] as [BOOLEAN] - [false]
2026-07-16 17:13:20,999 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [24] as [VARCHAR] - [xwiki/2.1]
2026-07-16 17:13:20,999 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [25] as [BOOLEAN] - [false]
2026-07-16 17:13:20,999 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [26] as [VARCHAR] - [XWiki.Admin]
2026-07-16 17:13:21,013 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [27] as [BOOLEAN] - [false]
2026-07-16 17:13:21,014 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] TRACE o.h.t.d.s.BasicBinder          - binding parameter [28] as [BIGINT] - [-7356002035525458629]
2026-07-16 17:13:21,050 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] WARN  o.h.e.j.s.SqlExceptionHelper   - SQL Error: -3401, SQLState: 22001
2026-07-16 17:13:21,050 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] ERROR o.h.e.j.s.SqlExceptionHelper   - data exception: string data, right truncation
2026-07-16 17:13:21,082 [qtp226744878-34 - http://localhost:8080/xwiki/bin/get/XWiki/OfficeImporterResults] ERROR .s.OfficeImporterScriptService - Error while saving document [xwiki:xxx5.WebHome].
{noformat}

For ref the logs I've configured were:

{noformat}
<logger name="org.hibernate.SQL" level="DEBUG"/>                    
<logger name="org.hibernate.type.descriptor.sql.BasicBinder" level="TRACE"/>   
{noformat}

The content is limited to 200000:

{noformat}
<property name="content" type="text" column="XWD_CONTENT" length="200000" not-null="true" />
{noformat}
 
 
This message was sent by Atlassian Jira (v9.3.0#930000-sha1:287aeb6) Atlassian logo
If image attachments aren't displayed, see this article.