Hello,

while trying to import Word document (non trivial) I'm hitting an issue where underlaying PostgreSQL complains about value too long to be stored. The message (cut from the console) looks as:

SQL next exception = [org.postgresql.util.PSQLException: ERROR: value too long for type character varying(200000)]]

Actual exception looks like:

XWD_VERSION='2.1', XWD_CUSTOM_CLASS='', XWD_PARENT='', XWD_CLASS_XML='', XWD_ELEMENTS='0', XWD_DEFAULT_TEMPLATE='', XWD_VALIDATION_SCRIPT='', XWD_COMMENT='Created by office importer.', XWD_MINOREDIT='0', XWD_SYNTAX_ID='xwiki/2.0', XWD_HIDDEN='0' where XWD_ID='-408553786' was aborted. Call getNextException to see the cause. at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2598) ~[postgresql-9.0-801.jdbc4.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1836) ~[postgresql-9.0-801.jdbc4.jar:na] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:407) ~[postgresql-9.0-801.jdbc4.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2737) ~[postgresql-9.0-801.jdbc4.jar:na] at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[commons-dbcp-1.3.jar:1.3] at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[commons-dbcp-1.3.jar:1.3] at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297) ~[commons-dbcp-1.3.jar:1.3] at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48) ~[hibernate-3.2.6.ga.jar:3.2.6.ga] at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246) ~[hibernate-3.2.6.ga.jar:3.2.6.ga]
        ... 137 common frames omitted

this is XWiki 3.1 enterprise with few our custom patches but they are not related to the storage nor import functionality, so I guess we've not broken this ourself.

Do you have any idea how to workaround this issue or even how to properly fix it?

Thanks a lot!
Karel

_______________________________________________
devs mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/devs

Reply via email to