com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TITLE' at row 1

Atlassian JIRA | epohl | 7 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

    When I try to import a Word doc in basic mode, it works fine. When I click Advanced and try to split the doc at either heading level 1 or 2, an error is returned as follows: Cause org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.pages.Page#7176732]; SQL []; Data truncation: Data too long for column 'TITLE' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TITLE' at row 1 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:110) caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TITLE' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2973) Stack Trace:[hide] org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.pages.Page#7176732]; SQL []; Data truncation: Data too long for column 'TITLE' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TITLE' at row 1 Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TITLE' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2973) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1129) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:681) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1368) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1283) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1268) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392) at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1821) at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1578) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1543) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49) at com.atlassian.hibernate.HibernateObjectDao$5.doInHibernate(HibernateObjectDao.java:374) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370) at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:341) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:341) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:296) at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.getPage(HibernatePageDao.java:89) at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.getPage(HibernatePageDao.java:104) at com.atlassian.confluence.pages.persistence.dao.hibernate.CachingPageDao$1.getBySpaceAndTitle(CachingPageDao.java:41) at com.atlassian.confluence.pages.persistence.dao.hibernate.CachingPageDao.loadPage(CachingPageDao.java:72) at com.atlassian.confluence.pages.persistence.dao.hibernate.CachingPageDao.getPage(CachingPageDao.java:32) at com.atlassian.confluence.pages.DefaultPageManager.getPage(DefaultPageManager.java:126) at com.atlassian.confluence.pages.DefaultPageManager.throwIfDuplicateAbstractPageTitle(DefaultPageManager.java:820) at com.atlassian.confluence.pages.DefaultPageManager.saveContentEntity(DefaultPageManager.java:722) at sun.reflect.GeneratedMethodAccessor6937.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at com.atlassian.spring.interceptors.SpringProfilingInterceptor.invoke(SpringProfilingInterceptor.java:16) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy34.saveContentEntity(Unknown Source) at com.benryan.dom.DefaultSplitImportContext.splitPage(DefaultSplitImportContext.java:81) at com.benryan.dom.DocSplitter.handleParagraphStyle(DocSplitter.java:100) at com.benryan.dom.Doc2Wiki.visitParagraphStart(Doc2Wiki.java:471) at com.aspose.words.Paragraph.accept(Unknown Source) at com.aspose.words.CompositeNode.acceptChildren(Unknown Source) at com.aspose.words.Body.accept(Unknown Source) at com.aspose.words.CompositeNode.acceptChildren(Unknown Source) at com.aspose.words.Section.accept(Unknown Source) at com.aspose.words.CompositeNode.acceptChildren(Unknown Source) at com.aspose.words.Document.accept(Unknown Source) at com.benryan.webwork.WordImportAction.doFileImport(WordImportAction.java:383) at com.benryan.webwork.WordImportAction.executeFileImport(WordImportAction.java:158) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:302) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:170) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.xwork.interceptors.XsrfTokenInterceptor.intercept(XsrfTokenInterceptor.java:100) at com.atlassian.confluence.xwork.ConfluenceXsrfTokenInterceptor.intercept(ConfluenceXsrfTokenInterceptor.java:18) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.security.interceptors.CaptchaInterceptor.intercept(CaptchaInterceptor.java:46) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.util.LoggingContextInterceptor.intercept(LoggingContextInterceptor.java:49) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.core.CancellingInterceptor.intercept(CancellingInterceptor.java:23) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:57) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.setup.webwork.BootstrapAwareInterceptor.intercept(BootstrapAwareInterceptor.java:26) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.user.actions.UserAwareInterceptor.intercept(UserAwareInterceptor.java:58) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.pages.actions.CommentAwareInterceptor.intercept(CommentAwareInterceptor.java:44) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:110) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.spaces.actions.SpaceAwareInterceptor.intercept(SpaceAwareInterceptor.java:68) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.core.actions.LastModifiedInterceptor.intercept(LastModifiedInterceptor.java:38) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:38) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.xwork.interceptors.TransactionalInvocation.invokeAndHandleExceptions(TransactionalInvocation.java:72) at com.atlassian.xwork.interceptors.TransactionalInvocation.invokeInTransaction(TransactionalInvocation.java:59) at com.atlassian.xwork.interceptors.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:56) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.atlassian.confluence.xwork.SetupIncompleteInterceptor.intercept(SetupIncompleteInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115) at com.atlassian.confluence.servlet.ConfluenceServletDispatcher.serviceAction(ConfluenceServletDispatcher.java:53) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:199) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:84) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:54) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.jmx.JmxFilter.doFilter(JmxFilter.java:106) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.ServletContextThreadLocalFilter.doFilter(ServletContextThreadLocalFilter.java:19) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.LoggingContextFilter.doFilter(LoggingContextFilter.java:47) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.web.filter.ThreadLocalCacheFilter.doFilter(ThreadLocalCacheFilter.java:22) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.UserThreadLocalFilter.doFilter(UserThreadLocalFilter.java:44) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:206) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98) at com.atlassian.confluence.util.AbstractBootstrapHotSwappingFilter.doFilter(AbstractBootstrapHotSwappingFilter.java:30) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:131) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:69) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.ClusterHeaderFilter.doFilter(ClusterHeaderFilter.java:35) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:170) at com.atlassian.spring.filter.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:29) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.ConfluenceErrorFilter.doFilter(ConfluenceErrorFilter.java:22) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.core.datetime.RequestTimeThreadLocalFilter.doFilter(RequestTimeThreadLocalFilter.java:34) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.confluence.util.RequestCacheThreadLocalFilter.doFilter(RequestCacheThreadLocalFilter.java:25) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:81) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:33) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66) at com.atlassian.confluence.extra.webdav.servlet.filter.ReverseProxyFilter.doFilter(ReverseProxyFilter.java:427) at com.atlassian.confluence.extra.webdav.servlet.filter.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:34) at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74) at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:55) at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:41) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41) at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:44) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:619) Referer URL https://docs.saxotech.com/pages/worddav/importword.action Confluence Application Information Build Information baseUrl: https://docs.saxotech.com home: /pack/confluence-data buildNumber: 1722 upTime: 1 month, 5 days, 7 hours, 1 minute, 31 seconds devMode: false serverId: A90K-A3SV-AL7K-0X5G supportEntitlementNumber: 582650 version: 3.1 Unique ID: 6eef5cc9-aaad-4fe6-a047-38a3d1e3ae10 Server information Application Server: Apache Tomcat/6.0.14 Servlet Version: 2.5 Database Dialect: com.atlassian.hibernate.dialect.MySQLDialect Database Driver Name: com.mysql.jdbc.Driver Memory Information Maximum Heap: 1012 MB Allocated Heap: 1012 MB Used Memory: 680 MB Unused Allocated Memory: 331 MB Available Memory: 331 MB Maximum Permgen: 256 MB Used Permgen: 93 MB System Information favouriteColour: Heliotrope javaRuntime: Diablo Java(TM) SE Runtime Environment operatingSystem: FreeBSD 7.0-RELEASE-p11 jvmVersion: 1.0 fileSystemEncoding: ISO8859-1 javaVm: Diablo Java HotSpot(TM) Server VM javaVendor: The FreeBSD Foundation jvmImplementationVersion: 10.0-b23 systemTimezone: Europe/Copenhagen appServer: Apache Tomcat tempDirectory: /pack/confluence/temp date: Tuesday, 23 Mar 2010 jvmInputArguments: -Xms256m -Xmx1024m -XX:MaxPermSize=256m -Djava.awt.headless=true -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=/pack/confluence/conf/logging.properties -Djava.endorsed.dirs=/pack/confluence/endorsed -Dcatalina.base=/pack/confluence -Dcatalina.home=/pack/confluence -Djava.io.tmpdir=/pack/confluence/temp time: 16:24:05 jvmVendor: Sun Microsystems Inc. userName: root javaVersion: 1.6.0_07 systemLanguage: en operatingSystemArchitecture: i386 workingDirectory: /service/confluence Cluster Information Not clustered. Plugins * Adaptavist Content Formatting Macros (com.adaptavist.confluence.contentFormattingMacros, Version: 1.6.12, Installed: Dec 28, 2009) * Add Content Menu Sections (confluence.menu.add, Version: 1.0, Installed: bundled) * Admin Sections (confluence.sections.admin, Version: 1.0, Installed: bundled) * Advanced Macros (confluence.macros.advanced, Version: 1.6.8, Installed: Mar 31, 2009) * Apache HttpClient OSGi bundle (org.apache.httpcomponents.httpclient-4.0, Version: 4.0, Installed: bundled) * Apache HttpCore OSGi bundle (org.apache.httpcomponents.httpcore-4.0, Version: 4.0, Installed: bundled) * Atlassian Gadgets API (com.atlassian.gadgets.atlassian-gadgets-api-2.0.2, Version: 2.0.2, Installed: bundled) * Atlassian Gadgets OAuth Service Provider Plugin (com.atlassian.gadgets.oauth.serviceprovider, Version: 2.0.2, Installed: bundled) * Atlassian Gadgets SPI (com.atlassian.gadgets.atlassian-gadgets-spi-2.0.2, Version: 2.0.2, Installed: bundled) * Atlassian OAuth API (com.atlassian.oauth.atlassian-oauth-api-1.0.12, Version: 1.0.12, Installed: bundled) * Atlassian OAuth Admin Plugin (com.atlassian.oauth.admin, Version: 1.0.12, Installed: bundled) * Atlassian OAuth Consumer Plugin (com.atlassian.oauth.consumer, Version: 1.0.12, Installed: bundled) * Atlassian OAuth Consumer SAL SPI Implementation (com.atlassian.oauth.consumer.sal, Version: 1.0.12, Installed: bundled) * Atlassian OAuth Consumer SPI (com.atlassian.oauth.atlassian-oauth-consumer-spi-1.0.12, Version: 1.0.12, Installed: bundled) * Atlassian OAuth Service Provider Plugin (com.atlassian.oauth.serviceprovider, Version: 1.0.12, Installed: bundled) * Atlassian OAuth Service Provider SAL SPI Implementation (com.atlassian.oauth.serviceprovider.sal, Version: 1.0.12, Installed: bundled) * Atlassian OAuth Service Provider SPI (com.atlassian.oauth.atlassian-oauth-service-provider-spi-1.0.12, Version: 1.0.12, Installed: bundled) * Atlassian REST - Module Types (com.atlassian.plugins.rest.atlassian-rest-module, Version: 1.1.0.beta2, Installed: bundled) * Atlassian Template Renderer API (com.atlassian.templaterenderer.api, Version: 1.0.3, Installed: bundled) * Atlassian Template Renderer Velocity 1.6 Plugin (com.atlassian.templaterenderer.atlassian-template-renderer-velocity1.6-plugin, Version: 1.0.3, Installed: bundled) * Atlassian UI Plugin (com.atlassian.auiplugin, Version: 2.0.2.1, Installed: bundled) * Attachment Actions (confluence.sections.attachments, Version: 1.0, Installed: bundled) * Attachment Extractors (com.atlassian.confluence.plugins.attachmentExtractors, Version: 1.1, Installed: bundled) * BND Library (biz.aQute.bndlib-0.0.255, Version: 0.0.255, Installed: bundled) * Basic Macros (confluence.macros.basic, Version: 1.4, Installed: bundled) * Browse Menu Items (confluence.sections.browse, Version: 1.0, Installed: bundled) * Chart Plugin (confluence.extra.chart, Version: 1.15, Installed: bundled) * Clickr Theme (com.atlassian.confluence.themes.clickr, Version: 2.6, Installed: bundled) * Code Macro (confluence.macros.code, Version: 1.5, Installed: bundled) * Comment Action Sections (confluence.comment.action, Version: 1.0, Installed: bundled) * Confluence Activity Stream Plugin (com.atlassian.streams.confluence, Version: 3.1, Installed: bundled) * Confluence Atlassian Plugin Repository (confluence.repository.client, Version: 2.1.6, Installed: bundled) * Confluence Attachments Plugin (confluence.extra.attachments, Version: 2.17, Installed: bundled) * Confluence Blogging RPC Plugin (com.atlassian.confluence.plugins.xmlrpc.bloggingrpc, Version: 1.2.4, Installed: bundled) * Confluence Contributors Plugin (com.atlassian.confluence.contributors, Version: 1.2.3, Installed: bundled) * Confluence Drag and Drop Plugin (com.atlassian.confluence.plugins.drag-and-drop, Version: 1.0.3, Installed: bundled) * Confluence HTML Macros (confluence.macros.html, Version: 1.8, Installed: bundled) * Confluence Legacy Web Resources (legacy.confluence.web.resources, Version: 1.0, Installed: bundled) * Confluence PDF Export (com.atlassian.confluence.extra.flyingpdf, Version: 1.3, Installed: bundled) * Confluence REST API (com.atlassian.confluence.restplugin, Version: 3.1, Installed: bundled) * Confluence Remote API (confluence.extra.confluencerpc, Version: 3.1, Installed: bundled) * Confluence Thread Dump Plugin (com.atlassian.confluence.plugin.threaddump, Version: 1.2.1, Installed: bundled) * Confluence Usage Stats (com.atlassian.confluence.ext.usage, Version: 0.12, Installed: bundled) * Content Action Menu Sections (confluence.content.action.menu, Version: 1.0, Installed: bundled) * Content Buttons (confluence.sections.page.temp, Version: 1.0, Installed: bundled) * Content Metadata (confluence.sections.content.metadata, Version: 1.0, Installed: bundled) * Core Extractors (confluence.extractors.core, Version: 1.4, Installed: bundled) * Core Listeners (confluence.listeners.core, Version: 1.3, Installed: bundled) * Core Path Converters (confluence.converters.core, Version: 1.0, Installed: bundled) * Core Startup and Shutdown (confluence.lifecycle.core, Version: 1, Installed: bundled) * Dashboard Actions (com.atlassian.confluence.plugins.dashboard-actions, Version: 1.7, Installed: bundled) * Dashboard Macros (confluence.macros.dashboard, Version: 1.13, Installed: bundled) * Default Macro Metadata Provider (confluence.macro.metadata.provider, Version: 1.0, Installed: bundled) * Default Theme (com.atlassian.confluence.themes.default, Version: 1.0, Installed: bundled) * Did You Mean Index Building Interface (confluence.sections.admin.indexing, Version: 1.0, Installed: bundled) * Documentation Theme (com.atlassian.confluence.plugins.doctheme, Version: 1.0.1, Installed: Dec 22, 2009) * Dynamic Task List 2 Plugin (confluence.extra.dynamictasklist2, Version: 3.2.5.1, Installed: Dec 21, 2009) * Edit Settings Sections (confluence.sections.settings.edit, Version: 1.0, Installed: bundled) * Editor Actions (confluence.editor.actions, Version: 1.0, Installed: bundled) * EhCache Plugins (confluence.cache.ehcache, Version: 3.0, Installed: bundled) * Embedded Gadgets Plugin (com.atlassian.gadgets.embedded, Version: 2.0.2, Installed: bundled) * Follow list resources (confluence.sections.user.follow.list, Version: 1.0, Installed: bundled) * French language pack (confluence.languages.fr_FR, Version: 1.18, Installed: bundled) * Gadget Directory Plugin (com.atlassian.gadgets.directory, Version: 2.0.2, Installed: bundled) * Gadget Spec Publisher Plugin (com.atlassian.gadgets.publisher, Version: 2.0.2, Installed: bundled) * Gadgets Plugin (com.atlassian.confluence.plugins.gadgets, Version: 1.0.3, Installed: bundled) * German language pack (confluence.languages.de_DE, Version: 1.12, Installed: bundled) * Global Dashboard Actions (confluence.sections.dashboard.global, Version: 1.0, Installed: bundled) * Global Labels Sections (confluence.sections.labels, Version: 1.0, Installed: bundled) * Google Analytics Macro (me.davidsimpson.confluence.plugins.googleanalytics, Version: 1.1, Installed: Dec 28, 2009) * Google Collections Bundle (com.atlassian.bundles.google-collections-1.0.0.rc1, Version: 1.0.0.rc1, Installed: bundled) * ICU4J (com.atlassian.bundles.icu4j-3.8.0.1, Version: 3.8.0.1, Installed: bundled) * IM Presence NG Plugin (confluence.extra.impresence2, Version: 2.6, Installed: bundled) * Information Macros (confluence.extra.information, Version: 1.3, Installed: bundled) * JDOM DOM Processor (com.springsource.org.jdom-1.0.0, Version: 1.0.0, Installed: bundled) * JIRA Macros (confluence.extra.jira, Version: 2.8.15, Installed: bundled) * JSON Library (com.atlassian.bundles.json-20070829.0.0.1, Version: 20070829.0.0.1, Installed: bundled) * JSR 305 Annotations (com.atlassian.bundles.jsr305-1.0, Version: 1.0, Installed: bundled) * Java Concurrency in Practice Annotations (com.springsource.net.jcip.annotations-1.0.0, Version: 1.0.0, Installed: bundled) * Layout Macros (confluence.extra.layout, Version: 1.3, Installed: Mar 31, 2009) * Left Navigation Theme (com.atlassian.confluence.themes.leftnavigation, Version: 2.9, Installed: Mar 31, 2009) * Live Search Macros (confluence.extra.livesearch, Version: 2.11, Installed: bundled) * Lucene Boosting Strategies (confluence.search.lucene.boosting, Version: 1.0, Installed: bundled) * News Tabs (confluence.sections.news, Version: 1.0, Installed: bundled) * Office Connector plugin (com.atlassian.confluence.extra.officeconnector, Version: 1.6, Installed: Mar 31, 2009) * OpenSearch Plugin (com.atlassian.plugins.search.opensearch-plugin, Version: 1.0.2, Installed: Dec 22, 2009) * Opensocial Plugin (com.atlassian.gadgets.opensocial, Version: 2.0.2, Installed: bundled) * Page Information Tools (com.adaptavist.confluence.pageinfo, Version: 1.2.9, Installed: Oct 6, 2009) * Page Operations (confluence.sections.page.operations, Version: 1.0, Installed: bundled) * Page Tabs (confluence.search.mappers.lucene, Version: 1.0, Installed: bundled) * Page Tabs (confluence.sections.page, Version: 1.0, Installed: bundled) * Page Tree (com.atlassian.confluence.plugins.pagetree, Version: 1.15, Installed: Dec 21, 2009) * Page View Links (confluence.sections.page.actions, Version: 1.0, Installed: bundled) * Profile Macros (confluence.macros.profile, Version: 1.0, Installed: bundled) * Profile Tabs (confluence.sections.profile, Version: 1.0, Installed: bundled) * ROME, RSS and atOM utilitiEs for Java (rome.rome-1.0, Version: 1.0, Installed: bundled) * Search Web Interface (confluence.sections.admin.generalconfig, Version: 1.0, Installed: bundled) * Search Web Interface (confluence.sections.search.view, Version: 1.0, Installed: bundled) * Shared Application Access Layer API (com.atlassian.sal.sal-api-2.0.15, Version: 2.0.15, Installed: bundled) * Shared Application Access Layer Confluence Plugin (com.atlassian.sal.confluence, Version: 2.0.15, Installed: bundled) * Social Bookmarking Plugin (com.atlassian.confluence.plugins.socialbookmarking, Version: 1.3.1, Installed: bundled) * Space Actions Sections (confluence.sections.space.actions, Version: 1.0, Installed: bundled) * Space Admin Sections (confluence.sections.space.admin, Version: 1.0, Installed: bundled) * Space Advanced Sections (confluence.sections.space.advanced, Version: 1.0, Installed: bundled) * Space Browse Sections (confluence.sections.space.browse, Version: 1.0, Installed: bundled) * Space Export Web Interface (confluence.sections.space.export.view, Version: 1.0, Installed: bundled) * Space Item Tabs (confluence.sections.space, Version: 1.0, Installed: bundled) * Space Labels Sections (confluence.sections.space.labels, Version: 1.0, Installed: bundled) * Space Pages Sections (confluence.sections.space.pages, Version: 1.0, Installed: bundled) * System Web Resources (confluence.web.resources, Version: 1.0, Installed: bundled) * Table Plugin (org.swift.confluence.table, Version: 3.4.0, Installed: Dec 22, 2009) * Table of Contents Plugin (org.randombits.confluence.toc, Version: 2.4.11, Installed: Mar 31, 2009) * Tabular Metadata (confluence.extra.masterdetail, Version: 2.9, Installed: bundled) * TinyMCE Editor Plugin (com.atlassian.confluence.tinymceplugin, Version: 3.1, Installed: bundled) * UWC Importer Admin Panel (com.atlassian.confluence.plugins.uwc.uwcimporter-adminpanel, Version: 1.2.1, Installed: bundled) * User Administration (confluence.admin.user, Version: 1.0, Installed: bundled) * User Hover Menu Sections (confluence.user.hover.menu, Version: 1.0, Installed: bundled) * User Lister (confluence.extra.userlister, Version: 2.4.4, Installed: bundled) * User Menu Sections (confluence.user.menu.concise, Version: 1.0, Installed: bundled) * User Menu Sections (confluence.user.menu, Version: 1.0, Installed: bundled) * User Status (confluence.userstatus, Version: 1.0, Installed: bundled) * View Changes in Draft (confluence-draft-changes, Version: 1.0, Installed: bundled) * View Profile Web Interface (confluence.sections.profile.view, Version: 1.0, Installed: bundled) * View follow resources (confluence.sections.user.view.follow, Version: 1.0, Installed: bundled) * WebDAV Plugin (confluence.extra.webdav, Version: 2.4, Installed: Mar 31, 2009) * Widget Connector (com.atlassian.confluence.extra.widgetconnector, Version: 1.3.2, Installed: Mar 31, 2009) * Wiki Renderer Components (confluence.renderer.components, Version: 1.0, Installed: bundled) Request Information URL https://docs.saxotech.com/500page.jsp URI /500page.jsp Context Path Servlet Path /500page.jsp Headers (Limited subset) host docs.saxotech.com user-agent Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6 keep-alive 115 connection keep-alive Attributes javax.servlet.forward.request_uri /pages/worddav/doimportword.action javax.servlet.forward.context_path javax.servlet.forward.servlet_path /pages/worddav/doimportword.action javax.servlet.forward.path_info /500page.jsp os_securityfilter_already_filtered true javax.servlet.jsp.jspException org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.pages.Page#7176732]; SQL []; Data truncation: Data too long for column 'TITLE' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TITLE' at row 1 atlassian.core.seraph.original.url /pages/worddav/doimportword.action javax.servlet.error.status_code 500 javax.servlet.error.servlet_name action __sitemesh__using_stream false com.atlassian.gzipfilter.GzipFilter_already_filtered true loginfilter.already.filtered true com.atlassian.confluence.web.ConfluenceJohnsonFilter_already_filtered true Confluence-Request-Time 1269357845257 javax.servlet.error.message com.atlassian.core.filters.HeaderSanitisingFilter_already_filtered true webwork.valueStack com.opensymphony.xwork.util.OgnlValueStack@19a14c3 sessioninview.FILTERED true __sitemesh__filterapplied true javax.servlet.error.exception org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.pages.Page#7176732]; SQL []; Data truncation: Data too long for column 'TITLE' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TITLE' at row 1 javax.servlet.error.request_uri /pages/worddav/doimportword.action Parameters (Limited subset) lvl 1 submit importSpace false pageId 4882802 docTitle Control Center advanced true conflict 1 treeDepth 2 Confluence User epohl Logging: 6 log statements generated by this request: [ERROR] Tue Mar 23 16:24:05 CET 2010 [net.sf.hibernate.util.JDBCExceptionReporter] Data truncation: Data too long for column 'TITLE' at row 1 [ERROR] Tue Mar 23 16:24:05 CET 2010 [net.sf.hibernate.impl.SessionImpl] Could not synchronize database state with session [ERROR] Tue Mar 23 16:24:05 CET 2010 [com.atlassian.confluence.ext.usage.event.UsageEventListener] Error creating task to index for event:com.atlassian.confluence.event.events.content.page.PageCreateEvent[source=com.atlassian.confluence.pages.DefaultPageManager@7d1859] : org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.pages.Page#7176732]; SQL []; Data truncation: Data too long for column 'TITLE' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TITLE' at row 1 Throwable: org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.pages.Page#7176732]; SQL []; Data truncation: Data too long for column 'TITLE' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TITLE' at row 1 Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TITLE' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2973) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1129) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:681) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1368) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1283) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1268) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392) at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1821) at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1578) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1543) [ERROR] Tue Mar 23 16:24:05 CET 2010 [net.sf.hibernate.util.JDBCExceptionReporter] Data truncation: Data too long for column 'TITLE' at row 1 [ERROR] Tue Mar 23 16:24:05 CET 2010 [net.sf.hibernate.impl.SessionImpl] Could not synchronize database state with session [ERROR] Tue Mar 23 16:24:05 CET 2010 [com.atlassian.confluence.servlet.ConfluenceServletDispatcher] Could not execute action Throwable: org.springframework.dao.DataIntegrityViolationException: Hibernate operation: could not insert: [com.atlassian.confluence.pages.Page#7176732]; SQL []; Data truncation: Data too long for column 'TITLE' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TITLE' at row 1 Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TITLE' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2973) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600) at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1129) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:681) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1368) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1283) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1268) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392) at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1821) at net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1578) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1543)

    Atlassian JIRA | 7 years ago | epohl
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TITLE' at row 1
  2. 0

    h3. Summary Importing a word file with more than 255 characters in its heading will cause HibernateSystemException ERROR h3. Steps to reproduce # Create a word file with multiple headings. One of the headings contains a sentence that is more than 255 characters # Select the "Import Word Document" and select the word document that was just created # Select {{Level 3 Headings}} for {{Split by heading:}} # It will throw an ERROR h3. Expected Results Confluence should throw an INFO/WARNING saying that one of the headings contains more than 255 characters. As such, it cannot complete the import h3. Actual Results It will throw the following ERROR {noformat} Cause org.springframework.orm.hibernate.HibernateSystemException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280]; nested exception is net.sf.hibernate.HibernateException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280] at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:597) caused by: net.sf.hibernate.HibernateException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280] at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:475) caused by: net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90) caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'TITLE' at row 1 at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2055) caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TITLE' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4235) Stack Trace:[hide] org.springframework.orm.hibernate.HibernateSystemException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280]; nested exception is net.sf.hibernate.HibernateException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280] at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:597) at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:353) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375) at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:341) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:477) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:378) at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.getPage(HibernatePageDao.java:146) at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.getPage(HibernatePageDao.java:173) at com.atlassian.confluence.pages.persistence.dao.hibernate.CachingPageDao$1.getBySpaceAndTitle(CachingPageDao.ja ... {noformat} h3.Workaround Modify the sentence to be less than 255 characters

    Atlassian JIRA | 2 years ago | Immanuel Siagian [Atlassian]
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TITLE' at row 1
  3. 0

    h3. Summary Importing a word file with more than 255 characters in its heading will cause HibernateSystemException ERROR h3. Steps to reproduce # Create a word file with multiple headings. One of the headings contains a sentence that is more than 255 characters # Select the "Import Word Document" and select the word document that was just created # Select {{Level 3 Headings}} for {{Split by heading:}} # It will throw an ERROR h3. Expected Results Confluence should throw an INFO/WARNING saying that one of the headings contains more than 255 characters. As such, it cannot complete the import h3. Actual Results It will throw the following ERROR {noformat} Cause org.springframework.orm.hibernate.HibernateSystemException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280]; nested exception is net.sf.hibernate.HibernateException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280] at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:597) caused by: net.sf.hibernate.HibernateException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280] at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:475) caused by: net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90) caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'TITLE' at row 1 at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2055) caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TITLE' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4235) Stack Trace:[hide] org.springframework.orm.hibernate.HibernateSystemException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280]; nested exception is net.sf.hibernate.HibernateException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280] at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:597) at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:353) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375) at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:341) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:477) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:378) at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.getPage(HibernatePageDao.java:146) at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.getPage(HibernatePageDao.java:173) at com.atlassian.confluence.pages.persistence.dao.hibernate.CachingPageDao$1.getBySpaceAndTitle(CachingPageDao.ja ... {noformat} h3.Workaround Modify the sentence to be less than 255 characters

    Atlassian JIRA | 2 years ago | Immanuel Siagian [Atlassian]
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TITLE' at row 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Criteria.list() ending with BatchUpdateException: Data truncation

    Stack Overflow | 2 years ago
    java.sql.BatchUpdateException: Data truncation: Data too long for column 'COMMUNE' at row 1
  6. 0

    SphinxQL Data too long for column

    Stack Overflow | 5 years ago | Colin Pickard
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'title' at row 1

    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. com.mysql.jdbc.MysqlDataTruncation

      Data truncation: Data too long for column 'TITLE' at row 1

      at com.mysql.jdbc.MysqlIO.checkErrorPacket()
    2. MySQL jdbc
      MysqlIO.checkErrorPacket
      1. com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2973)
      1 frame