Details
-
Bug
-
Resolution: Timed out
-
Low
-
None
-
5.4
-
Java Version 1.7.0_45
SuSE 11
Oracle 11g
-
1
-
Severity 3 - Minor
-
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.