java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'.

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

    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: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'.
  2. 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: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'.
  3. 0

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

    atlassian.com | 1 year ago
    java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK_ _690797E6'. Cannot insert duplicate key in object 'os_group'.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 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.
  6. 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.

    Root Cause Analysis

    1. 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()
    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:750)
      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. net.sf.hibernate
      JDBCTransaction.commit
      1. net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
      2. net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
      3. net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436)
      4. net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37)
      5. net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449)
      6. net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435)
      7. net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392)
      8. net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261)
      9. net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
      9 frames
    4. Hibernate
      HibernateTransactionManager.doCommit
      1. org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:463)
      1 frame