Unable to View Pages Due to DataIntegrityViolationException

Still need help?

The Atlassian Community is here for you.

Ask the community

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:

  1. There is a known bug occurs in a page which contains a colon positioned after 256 characters within square brackets
  2. 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

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.