Not able to access Confluence page with the error: 'ORA-12899: value too large for column "CONFDB"."LINKS"."DESTPAGETITLE"'
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
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
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
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
- 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
Last modified on Nov 2, 2018
Powered by Confluence and Scroll Viewport.