Unable to View Pages Due to DataIntegrityViolationException
Symptoms
When trying to view a Confluence page, a system error is shown and the following appears in the atlassian-confluence.log
:
2012-10-29 09:36:11,459 ERROR [http-8080-13] [atlassian.confluence.servlet.ConfluenceServletDispatcher] sendError Could not execute action
-- url: /display/TEST/Testing | userName: admin
org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.links.OutgoingLink#139527563]; SQL []; Data truncation; nested exception is java.sql.DataTruncation: Data truncation
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:100)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.orm.hibernate.HibernateTransactionManager.convertJdbcAccessException(HibernateTransactionManager.java:619)
at org.springframework.orm.hibernate.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:605)
at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:518)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701)
....
at net.customware.confluence.plugin.redirection.RedirectFilter.doFilterVerified(RedirectFilter.java:68)
at net.customware.confluence.plugin.redirection.license.LicensedConfluenceFilter.doFilter(LicensedConfluenceFilter.java:38)
....
Caused by: java.sql.DataTruncation: Data truncation
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:382)
....
caused by:
java.sql.SQLException: String or binary data would be truncated.
at net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:368)
at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2816)
at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2254)
....
Cause
There are two different causes why this error appears:
- There is a known bug occurs in a page which contains a colon positioned after 256 characters within square brackets
- The page contains
{link-window
} macro of ServiceRocket Linking Plugin, which can cause the page to be not viewable
Resolution
For cause 2, please disable the CustomWare Linking Plugin from Confluence Admin > Manage Plugins or remove any references to {link-window
} macro
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.