Unable to View Pages Due to DataIntegrityViolationException
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Symptoms
When trying to view a Confluence page, a system error is shown and the following appears in the atlassian-confluence.log:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
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
Was this helpful?