Uploaded image for project: 'Confluence Data Center'
  1. Confluence Data Center
  2. CONFSERVER-35669

Discrepancy between size of DESTPAGETITLE generated at word import and database contraints

    XMLWordPrintable

Details

    Description

      On attempted import of a word document with some very long section headings the following error appears in the log:

      2014-11-18 10:14:04,948 ERROR [ajp-bio-127.0.0.1-15279-exec-637] [sf.hibernate.impl.SessionImpl] execute Could not synchronize database state with session
      – url: /confluence/pages/worddav/doimportword.action | page: 18189078 | userName: xxxxx | referer: https://srv.example.com/confluence/pages/worddav/importword.action | action: doimportword
      2014-11-18 10:14:05,015 ERROR [ajp-bio-127.0.0.1-15279-exec-637] [atlassian.confluence.servlet.ConfluenceServletDispatcher] sendError Could not execute action
      – url: /confluence/pages/worddav/doimportword.action | userName: xxxxx | referer: https://srv.example.com/confluence/pages/worddav/importword.action
      org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: com.atlassian.confluence.links.OutgoingLink#19038545; uncategorized SQLException for SQL []; SQL state [72000]; error code [12899]; ORA-12899: value too large for column "DBUCONFLP01"."LINKS"."DESTPAGETITLE" (actual: 256, maximum: 255)
      ; nested exception is java.sql.SQLException: ORA-12899: value too large for column "DBUCONFLP01"."LINKS"."DESTPAGETITLE" (actual: 256, maximum: 255)

      at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
      at org.springframework.orm.hibernate.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:364)

      This looks to me like the import function allows one character more than the length the database field was configured for. Perhaps this is an unaccounted-for terminator such as a linefeed.

      Attachments

        Activity

          People

            Unassigned Unassigned
            053c5ed4dc5e Michael Ionescu
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: