Not able to access Confluence page with the error: 'ORA-12899: value too large for column "CONFDB"."LINKS"."DESTPAGETITLE"'
Platform Notice: Data Center Only - This article only applies to Atlassian apps 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
Summary
Problem
Users are not able to access a Confluence page with the error: value too large for column "CONFLUENCE"."LINKS"."DESTPAGETITLE"
The following appears in the atlassian-confluence.log
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: com.atlassian.confluence.links.OutgoingLink#82706958; uncategorized SQLException for SQL []; SQL state [72000]; error code [12899]; ORA-12899: value too large for column "CONFLUENCE"."LINKS"."DESTPAGETITLE" (actual: 348, maximum: 255) ; nested exception is java.sql.SQLException: ORA-12899: value too large for column "CONFLUENCE"."LINKS"."DESTPAGETITLE" (actual: 348, maximum: 255)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
caused by: java.sql.SQLException: ORA-12899: value too large for column "CONFLUENCE"."LINKS"."DESTPAGETITLE" (actual: 348, maximum: 255)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)
Diagnosis
Diagnostic Steps
There are Linking Plugin by ServiceRocket plugin links inside the page
Cause
One of the links (from the Linking Plugin) in the page contained more than 255 characters
It is a known bug/limitation from the plugin itself. See: System error with URLs longer than 255 signs and the specific usage of link-window macro
Solution
Workaround
Edit the page using the following documentation as a guide (Editing or Deleting a Page That Won't Render)
Enter the following URL: <baseurl>/pages/editpage.action?spaceKey=<spaceKey>&title=pageName (replacing spacekey and pagename with the space key and the page title of the problematic page) to access the edit page
Check on the all ServiceRocket linking macro inside a page for links that has character more than 255
Save the page
Was this helpful?