java.sql.SQLException: String or binary data would be truncated.

Atlassian JIRA | Philip Harling | 1 decade ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Insert the text into a new page: [http://epm.ge.gto.cib.intranet.db.com/pmo/pmo_event_results.jsp?program=3642&program=2030&program=4124&program=3653&program=3658&program=2029&program=2038&program=3652&projectID=0&region=0&strategic=0&milestoneType=0&milestoneStatus=0&category=12&startDate=01+Jul+2004&endDate=31+Dec+2004&groupcode=EQP] and then hit Update. The following exception is generated: Cause: org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: String or binary data would be truncated. Stack Trace: [hide] org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: String or binary data would be truncated. java.sql.SQLException: String or binary data would be truncated. at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:392) at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:91) at net.sourceforge.jtds.jdbc.Tds.goToNextResult(Tds.java:752) at net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:710) at net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:302) at net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:282) at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:136) at net.sourceforge.jtds.jdbc.PreparedStatement_base.executeUpdate(PreparedStatement_base.java:290) at com.mchange.v2.sql.filter.FilterPreparedStatement.executeUpdate(FilterPreparedStatement.java:71) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:468) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2414) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2367) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2236) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:386) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:316) at com.atlassian.confluence.util.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:124) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:179) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:72) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.user.actions.AuthenticatedUserInterceptor.intercept(AuthenticatedUserInterceptor.java:67) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:133) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:278) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:248) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:145) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:148) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:168) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:117) at bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:30) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:26) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666) at java.lang.Thread.run(Thread.java:534) Referer URL: http://sunseeker.uk.db.com/pages/editpage.action?pageId=84883 Build Information: Uptime: 18 days, 14 minutes, 43 seconds Version: 1.2 Build Number: 58 Server Information: Application Server: Apache Tomcat/4.1.29 Servlet Version: 2.3 Database Dialect: net.sf.hibernate.dialect.SQLServerDialect Memory Information: Total Memory: 208 MB Free Memory: 72 MB Used Memory: 136 MB System Information: System Date: Tuesday, 05 Oct 2004 System Time: 16:07:28 System Favourite Colour: Jet Black Java Version: 1.4.2_05 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2_05-b04 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: SYSTEM User Timezone: Europe/London Operating System: Windows 2003 5.2 OS Architecture: x86 Request Information: URL: http://sunseeker.uk.db.com/pages/doeditpage.action - Scheme: http - Server: sunseeker.uk.db.com - Port: 80 - URI: /500page.jsp - - Context Path: - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: pageId=84883 Attributes: - com.atlassian.confluence.setup.SpringSessionInViewFilter.sessionFactory : true - javax.servlet.error.message : - javax.servlet.error.exception : java.lang.IllegalStateException: ClobStringType requires active transaction synchronization - os_securityfilter_already_filtered : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - javax.servlet.error.request_uri : /pages/doeditpage.action - javax.servlet.error.status_code : 500 - __sitemesh__filterapplied : true - javax.servlet.error.servlet_name : action - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@1e01391 - atlassian.core.seraph.original.url : /pages/doeditpage.action?pageId=84883 - loginfilter.already.filtered : true - javax.servlet.jsp.jspException : org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: String or binary data would be truncated. Parameters: - selectedText = [http://epm.ge.gto.cib.intranet.db.com/pmo/pmo_event_results.jsp?program=3642&program=2030&program=4124&program=3653&program=3658&program=2029&program=2038&program=3652&projectID=0&region=0&strategic=0&milestoneType=0&milestoneStatus=0&category=12&startDate=01+Jul+2004&endDate=31+Dec+2004&groupcode=EQP] - confirm = Update - content = [http://epm.ge.gto.cib.intranet.db.com/pmo/pmo_event_results.jsp?program=3642&program=2030&program=4124&program=3653&program=3658&program=2029&program=2038&program=3652&projectID=0&region=0&strategic=0&milestoneType=0&milestoneStatus=0&category=12&startDate=01+Jul+2004&endDate=31+Dec+2004&groupcode=EQP] - originalVersion = 1 - sel2 = - sel1 = - parentPageTitle = - pageId = 84883

    Atlassian JIRA | 1 decade ago | Philip Harling
    java.sql.SQLException: String or binary data would be truncated.
  2. 0

    Insert the text into a new page: [http://epm.ge.gto.cib.intranet.db.com/pmo/pmo_event_results.jsp?program=3642&program=2030&program=4124&program=3653&program=3658&program=2029&program=2038&program=3652&projectID=0&region=0&strategic=0&milestoneType=0&milestoneStatus=0&category=12&startDate=01+Jul+2004&endDate=31+Dec+2004&groupcode=EQP] and then hit Update. The following exception is generated: Cause: org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: String or binary data would be truncated. Stack Trace: [hide] org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: String or binary data would be truncated. java.sql.SQLException: String or binary data would be truncated. at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:392) at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:91) at net.sourceforge.jtds.jdbc.Tds.goToNextResult(Tds.java:752) at net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:710) at net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:302) at net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:282) at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:136) at net.sourceforge.jtds.jdbc.PreparedStatement_base.executeUpdate(PreparedStatement_base.java:290) at com.mchange.v2.sql.filter.FilterPreparedStatement.executeUpdate(FilterPreparedStatement.java:71) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:468) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2414) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2367) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2236) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:386) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:316) at com.atlassian.confluence.util.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:124) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:179) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:72) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.user.actions.AuthenticatedUserInterceptor.intercept(AuthenticatedUserInterceptor.java:67) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:133) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:278) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:248) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:145) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:148) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:168) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:117) at bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:30) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:26) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666) at java.lang.Thread.run(Thread.java:534) Referer URL: http://sunseeker.uk.db.com/pages/editpage.action?pageId=84883 Build Information: Uptime: 18 days, 14 minutes, 43 seconds Version: 1.2 Build Number: 58 Server Information: Application Server: Apache Tomcat/4.1.29 Servlet Version: 2.3 Database Dialect: net.sf.hibernate.dialect.SQLServerDialect Memory Information: Total Memory: 208 MB Free Memory: 72 MB Used Memory: 136 MB System Information: System Date: Tuesday, 05 Oct 2004 System Time: 16:07:28 System Favourite Colour: Jet Black Java Version: 1.4.2_05 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2_05-b04 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: SYSTEM User Timezone: Europe/London Operating System: Windows 2003 5.2 OS Architecture: x86 Request Information: URL: http://sunseeker.uk.db.com/pages/doeditpage.action - Scheme: http - Server: sunseeker.uk.db.com - Port: 80 - URI: /500page.jsp - - Context Path: - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: pageId=84883 Attributes: - com.atlassian.confluence.setup.SpringSessionInViewFilter.sessionFactory : true - javax.servlet.error.message : - javax.servlet.error.exception : java.lang.IllegalStateException: ClobStringType requires active transaction synchronization - os_securityfilter_already_filtered : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - javax.servlet.error.request_uri : /pages/doeditpage.action - javax.servlet.error.status_code : 500 - __sitemesh__filterapplied : true - javax.servlet.error.servlet_name : action - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@1e01391 - atlassian.core.seraph.original.url : /pages/doeditpage.action?pageId=84883 - loginfilter.already.filtered : true - javax.servlet.jsp.jspException : org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: String or binary data would be truncated. Parameters: - selectedText = [http://epm.ge.gto.cib.intranet.db.com/pmo/pmo_event_results.jsp?program=3642&program=2030&program=4124&program=3653&program=3658&program=2029&program=2038&program=3652&projectID=0&region=0&strategic=0&milestoneType=0&milestoneStatus=0&category=12&startDate=01+Jul+2004&endDate=31+Dec+2004&groupcode=EQP] - confirm = Update - content = [http://epm.ge.gto.cib.intranet.db.com/pmo/pmo_event_results.jsp?program=3642&program=2030&program=4124&program=3653&program=3658&program=2029&program=2038&program=3652&projectID=0&region=0&strategic=0&milestoneType=0&milestoneStatus=0&category=12&startDate=01+Jul+2004&endDate=31+Dec+2004&groupcode=EQP] - originalVersion = 1 - sel2 = - sel1 = - parentPageTitle = - pageId = 84883

    Atlassian JIRA | 1 decade ago | Philip Harling
    java.sql.SQLException: String or binary data would be truncated.
  3. 0

    [CONF-3563] Failed to restore from backup version 1.3.2 - Atlassian JIRA

    atlassian.com | 1 year ago
    java.sql.SQLException: String or binary data would be truncated.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Cause: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. Stack Trace: [hide] (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. Referer URL: http://ahf-web/confluence/setup/setup-restore-local.action Build Information: Uptime: 4 minutes, 53 seconds Version: 1.4.2 Build Number: 214 Server Information: Application Server: Orion/2.0.5 Servlet Version: 2.3 Database Dialect: net.sf.hibernate.dialect.SQLServerDialect Memory Information: Total Memory: 254 MB Free Memory: 18 MB Used Memory: 236 MB System Information: System Date: ???????, 14 ??? 2005 System Time: 11:31:09 System Favourite Colour: Lime Java Version: 1.4.2_08 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2_08-b03 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: SYSTEM User Timezone: Asia/Novosibirsk Operating System: Windows 2000 5.0 OS Architecture: x86 Request Information: URL: http://ahf-web/confluence/500page.jsp - Scheme: http - Server: ahf-web - Port: 80 - URI: /confluence/500page.jsp - - Context Path: /confluence - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: null Attributes: - javax.servlet.error.servlet_name : action - javax.servlet.error.message : (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. - javax.servlet.error.exception : org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@1f75107 - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - javax.servlet.error.request_uri : /confluence/setup/setup-restore-local.action - javax.servlet.jsp.jspException : org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. - javax.servlet.error.status_code : 500 - __sitemesh__filterapplied : true - sessioninview.FILTERED : true - com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true Parameters: - localFileName = daily-backup-14???2005.zip - buildIndex = true Logging: 8 log statements generated by this request: [ERROR] Thu Jul 14 11:30:44 NOVST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] String or binary data would be truncated. [ERROR] Thu Jul 14 11:30:44 NOVST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Unspecified error returned. [ERROR] Thu Jul 14 11:30:44 NOVST 2005 [net.sf.hibernate.impl.SessionImpl] Could not synchronize database state with session [ERROR] Thu Jul 14 11:30:44 NOVST 2005 [com.atlassian.confluence.importexport.impl.BackupImporter] Error while upgrading imported data (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.SQLException: String or binary data would be truncated. Throwable: org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.SQLException: String or binary data would be truncated. java.sql.SQLException: String or binary data would be truncated. at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:392) at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:91) at net.sourceforge.jtds.jdbc.Tds.goToNextResult(Tds.java:750) at net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:710) at net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:302) at net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:282) at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:136) at net.sourceforge.jtds.jdbc.PreparedStatement_base.executeUpdate(PreparedStatement_base.java:290) 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.findBySQL(SessionImpl.java:3863) at net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52) [ERROR] Thu Jul 14 11:30:48 NOVST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. [ERROR] Thu Jul 14 11:30:48 NOVST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Unspecified error returned. [ERROR] Thu Jul 14 11:30:48 NOVST 2005 [net.sf.hibernate.impl.SessionImpl] Could not synchronize database state with session [ERROR] Thu Jul 14 11:31:08 NOVST 2005 [com.opensymphony.webwork.dispatcher.ServletDispatcher] Could not execute action Throwable: org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:392) at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:91) at net.sourceforge.jtds.jdbc.Tds.goToNextResult(Tds.java:750) at net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:710) at net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:302) at net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:282) at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:136) at net.sourceforge.jtds.jdbc.PreparedStatement_base.executeUpdate(PreparedStatement_base.java:290) 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.flush(SessionImpl.java:2261) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:463)

    Atlassian JIRA | 1 decade ago | Rashit A. Fakhreyev
    java.sql.SQLException: String or binary data would be truncated.
  6. 0

    Cause: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. Stack Trace: [hide] (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. Referer URL: http://ahf-web/confluence/setup/setup-restore-local.action Build Information: Uptime: 4 minutes, 53 seconds Version: 1.4.2 Build Number: 214 Server Information: Application Server: Orion/2.0.5 Servlet Version: 2.3 Database Dialect: net.sf.hibernate.dialect.SQLServerDialect Memory Information: Total Memory: 254 MB Free Memory: 18 MB Used Memory: 236 MB System Information: System Date: ???????, 14 ??? 2005 System Time: 11:31:09 System Favourite Colour: Lime Java Version: 1.4.2_08 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2_08-b03 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: SYSTEM User Timezone: Asia/Novosibirsk Operating System: Windows 2000 5.0 OS Architecture: x86 Request Information: URL: http://ahf-web/confluence/500page.jsp - Scheme: http - Server: ahf-web - Port: 80 - URI: /confluence/500page.jsp - - Context Path: /confluence - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: null Attributes: - javax.servlet.error.servlet_name : action - javax.servlet.error.message : (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. - javax.servlet.error.exception : org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@1f75107 - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - javax.servlet.error.request_uri : /confluence/setup/setup-restore-local.action - javax.servlet.jsp.jspException : org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. - javax.servlet.error.status_code : 500 - __sitemesh__filterapplied : true - sessioninview.FILTERED : true - com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true Parameters: - localFileName = daily-backup-14???2005.zip - buildIndex = true Logging: 8 log statements generated by this request: [ERROR] Thu Jul 14 11:30:44 NOVST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] String or binary data would be truncated. [ERROR] Thu Jul 14 11:30:44 NOVST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Unspecified error returned. [ERROR] Thu Jul 14 11:30:44 NOVST 2005 [net.sf.hibernate.impl.SessionImpl] Could not synchronize database state with session [ERROR] Thu Jul 14 11:30:44 NOVST 2005 [com.atlassian.confluence.importexport.impl.BackupImporter] Error while upgrading imported data (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.SQLException: String or binary data would be truncated. Throwable: org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.SQLException: String or binary data would be truncated. java.sql.SQLException: String or binary data would be truncated. at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:392) at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:91) at net.sourceforge.jtds.jdbc.Tds.goToNextResult(Tds.java:750) at net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:710) at net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:302) at net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:282) at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:136) at net.sourceforge.jtds.jdbc.PreparedStatement_base.executeUpdate(PreparedStatement_base.java:290) 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.findBySQL(SessionImpl.java:3863) at net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52) [ERROR] Thu Jul 14 11:30:48 NOVST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. [ERROR] Thu Jul 14 11:30:48 NOVST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Unspecified error returned. [ERROR] Thu Jul 14 11:30:48 NOVST 2005 [net.sf.hibernate.impl.SessionImpl] Could not synchronize database state with session [ERROR] Thu Jul 14 11:31:08 NOVST 2005 [com.opensymphony.webwork.dispatcher.ServletDispatcher] Could not execute action Throwable: org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:392) at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:91) at net.sourceforge.jtds.jdbc.Tds.goToNextResult(Tds.java:750) at net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:710) at net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:302) at net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:282) at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:136) at net.sourceforge.jtds.jdbc.PreparedStatement_base.executeUpdate(PreparedStatement_base.java:290) 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.flush(SessionImpl.java:2261) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:463)

    Atlassian JIRA | 1 decade ago | Rashit A. Fakhreyev
    java.sql.SQLException: String or binary data would be truncated.

    Root Cause Analysis

    1. java.sql.SQLException

      String or binary data would be truncated.

      at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException()
    2. jTDS
      PreparedStatement_base.executeUpdate
      1. net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:392)
      2. net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:91)
      3. net.sourceforge.jtds.jdbc.Tds.goToNextResult(Tds.java:752)
      4. net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:710)
      5. net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:302)
      6. net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:282)
      7. net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:136)
      8. net.sourceforge.jtds.jdbc.PreparedStatement_base.executeUpdate(PreparedStatement_base.java:290)
      8 frames
    3. c3p0:JDBC DataSources/Resource Pools
      FilterPreparedStatement.executeUpdate
      1. com.mchange.v2.sql.filter.FilterPreparedStatement.executeUpdate(FilterPreparedStatement.java:71)
      1 frame
    4. net.sf.hibernate
      JDBCTransaction.commit
      1. net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
      2. net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:468)
      3. net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442)
      4. net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29)
      5. net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2414)
      6. net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2367)
      7. net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2236)
      8. net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
      8 frames
    5. Hibernate
      HibernateTransactionManager.doCommit
      1. org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:386)
      1 frame
    6. Spring Tx
      AbstractPlatformTransactionManager.commit
      1. org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:316)
      1 frame
    7. com.atlassian.confluence
      XWorkTransactionInterceptor$1.beforeResult
      1. com.atlassian.confluence.util.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:124)
      1 frame
    8. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:179)
      1 frame
    9. com.opensymphony.xwork
      AroundInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      1 frame
    10. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      1 frame
    11. com.opensymphony.xwork
      DefaultWorkflowInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55)
      1 frame
    12. com.atlassian.confluence
      ConfluenceWorkflowInterceptor.intercept
      1. com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33)
      1 frame
    13. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      1 frame
    14. com.opensymphony.xwork
      AroundInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      1 frame
    15. com.atlassian.confluence
      ConfluenceValidationInterceptor.intercept
      1. com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16)
      1 frame
    16. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      1 frame
    17. com.opensymphony.xwork
      AroundInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      1 frame
    18. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      1 frame
    19. com.atlassian.confluence
      PermissionCheckInterceptor.intercept
      1. com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40)
      1 frame
    20. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      1 frame
    21. com.atlassian.confluence
      PageAwareInterceptor.intercept
      1. com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:72)
      1 frame
    22. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      1 frame
    23. com.opensymphony.xwork
      AroundInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      1 frame
    24. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      1 frame
    25. com.opensymphony.xwork
      AroundInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      1 frame
    26. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      1 frame
    27. com.atlassian.confluence
      ConfluenceAutowireInterceptor.intercept
      1. com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25)
      1 frame
    28. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      1 frame
    29. com.opensymphony.xwork
      AroundInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      1 frame
    30. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      1 frame
    31. com.opensymphony.xwork
      AroundInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      1 frame
    32. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      1 frame
    33. com.atlassian.confluence
      AuthenticatedUserInterceptor.intercept
      1. com.atlassian.confluence.user.actions.AuthenticatedUserInterceptor.intercept(AuthenticatedUserInterceptor.java:67)
      1 frame
    34. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      1 frame
    35. com.atlassian.confluence
      XWorkTransactionInterceptor.intercept
      1. com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:133)
      1 frame
    36. XWork Tiger Extensions
      DefaultActionInvocation.invoke
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      1 frame
    37. com.opensymphony.xwork
      AroundInterceptor.intercept
      1. com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34)
      1 frame
    38. XWork Tiger Extensions
      DefaultActionProxy.execute
      1. com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163)
      2. com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115)
      2 frames
    39. WebWork
      ServletDispatcher.service
      1. com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:278)
      2. com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:248)
      2 frames
    40. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      1 frame
    41. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      2 frames
    42. Sitemesh
      PageFilter.parsePage
      1. com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:145)
      1 frame
    43. com.atlassian.confluence
      ProfilingPageFilter.parsePage
      1. com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:148)
      1 frame
    44. Sitemesh
      PageFilter.doFilter
      1. com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61)
      1 frame
    45. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      2 frames
    46. com.atlassian.seraph
      SecurityFilter.doFilter
      1. com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:168)
      1 frame
    47. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      2 frames
    48. com.atlassian.seraph
      LoginFilter.doFilter
      1. com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181)
      1 frame
    49. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      2 frames
    50. com.atlassian.johnson
      JohnsonFilter.doFilter
      1. com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96)
      1 frame
    51. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      2 frames
    52. Hibernate
      OpenSessionInViewFilter.doFilterInternal
      1. org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:117)
      1 frame
    53. bucket.custom
      FlushingSpringSessionInViewFilter.doFilterInternal
      1. bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:30)
      1 frame
    54. Spring
      OncePerRequestFilter.doFilter
      1. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73)
      1 frame
    55. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      2 frames
    56. com.atlassian.util
      ProfilingFilter.doFilter
      1. com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132)
      1 frame
    57. com.atlassian.confluence
      ProfilingAndErrorFilter.doFilter
      1. com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:26)
      1 frame
    58. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      2 frames
    59. com.atlassian.core
      AbstractEncodingFilter.doFilter
      1. com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36)
      1 frame
    60. Glassfish Core
      ContainerBase.invoke
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256)
      4. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      5. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      6. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      7. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      8. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      9. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      10. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      11. org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417)
      12. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
      13. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      14. org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171)
      15. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      16. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
      17. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      18. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      19. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      20. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174)
      21. org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      22. org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      23. org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      23 frames
    61. org.apache.coyote
      CoyoteAdapter.service
      1. org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193)
      1 frame
    62. Grizzly HTTP
      TcpWorkerThread.runIt
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781)
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549)
      3. org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589)
      3 frames
    63. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666)
      1 frame
    64. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:534)
      1 frame