29 Nov
2011
29 Nov
'11
2:15 p.m.
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