java.sql.SQLException: ORA-12899: value too large for column "DBUCONFLP01"."LINKS"."DESTPAGETITLE" (actual: 256, maximum: 255)

Atlassian JIRA | Michael Ionescu | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    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.

    Atlassian JIRA | 2 years ago | Michael Ionescu
    java.sql.SQLException: ORA-12899: value too large for column "DBUCONFLP01"."LINKS"."DESTPAGETITLE" (actual: 256, maximum: 255)
  2. 0

    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.

    Atlassian JIRA | 2 years ago | Michael Ionescu
    java.sql.SQLException: ORA-12899: value too large for column "DBUCONFLP01"."LINKS"."DESTPAGETITLE" (actual: 256, maximum: 255)
  3. 0

    MySQL lock table size Exception

    novell.com | 1 year ago
    java.sql.SQLException: The total number of locks exceeds the lock table size
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    친애하는 꽃난에게♡ :: '개발관련/Database' 카테고리의 글 목록

    tistory.com | 9 months ago
    java.sql.SQLException: 부적합한 열 유형: 1111
  6. 0

    GitHub comment 944#247921465

    GitHub | 7 months ago | zouguobing
    java.sql.SQLException: connection holder is null

  1. Piz 6 times, last 8 months ago
  2. kid 1 times, last 11 months ago
1 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLException

    ORA-12899: value too large for column "DBUCONFLP01"."LINKS"."DESTPAGETITLE" (actual: 256, maximum: 255)

    at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate()
  2. Spring Framework
    AbstractFallbackSQLExceptionTranslator.translate
    1. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
    1 frame
  3. Hibernate
    HibernateAccessor.convertJdbcAccessException
    1. org.springframework.orm.hibernate.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:364)
    1 frame