Not able to access Confluence page with the error: 'ORA-12899: value too large for column "CONFDB"."LINKS"."DESTPAGETITLE"'

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

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

Workaround

  1. 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
  2. Check on the all ServiceRocket linking macro inside a page for links that has character more than 255
  3. Save the page

 

Last modified on Nov 2, 2018

Was this helpful?

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