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

Atlassian JIRA | epohl | 7 years ago
  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 | 1 year 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 | 1 year 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 | 4 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