#314 Problem calculating rollups?

[Anonymous]

com.tuma_solutions.tpidw.pdash.service.PdashEtlException$Unexpected: org.hibernate.exception.DataException: could not execute batch
at com.tuma_solutions.tpidw.pdash.service.PdashEtlException.cast(PdashEtlException.java:66)
at com.tuma_solutions.tpidw.pdash.service.impl.StateFileImporterImplSimple.importTeamAndProjects(StateFileImporterImplSimple.java:65)
at com.tuma_solutions.tpidw.pdash.service.impl.DashboardDatasetImporterImpl.importDashboardDataset(DashboardDatasetImporterImpl.java:86)
at com.tuma_solutions.tpidw.client.addon.TpidwAddOnDataLoader$DatasetLoaderThread.loadDatasetRobustly(TpidwAddOnDataLoader.java:154)
at com.tuma_solutions.tpidw.client.addon.TpidwAddOnDataLoader$DatasetLoaderThread.loadDatasetImpl(TpidwAddOnDataLoader.java:134)
at com.tuma_solutions.tpidw.client.addon.TpidwAddOnDataLoader$DatasetLoaderThread.run(TpidwAddOnDataLoader.java:103)
Caused by: org.hibernate.exception.DataException: could not execute batch
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:135)
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:126)
at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:132)
at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:111)
at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:163)
at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.getBatch(JdbcCoordinatorImpl.java:215)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3102)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3581)
at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:104)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463)
at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:349)
at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:350)
at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)
at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1222)
at com.tuma_solutions.tpidw.etl.util.AbstractHibernateDao.batchSaveAll(AbstractHibernateDao.java:138)
at com.tuma_solutions.tpidw.etl.util.AbstractHibernateDao.batchSaveAll(AbstractHibernateDao.java:109)
at com.tuma_solutions.tpidw.etl.dao.impl.AttributeDaoImpl.save(AttributeDaoImpl.java:41)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy44.save(Unknown Source)
at com.tuma_solutions.tpidw.etl.service.impl.AttributeServiceImpl.loadOrSaveValues(AttributeServiceImpl.java:161)
at com.tuma_solutions.tpidw.etl.service.impl.AttributeServiceImpl.loadOrSaveValue(AttributeServiceImpl.java:133)
at com.tuma_solutions.tpidw.etl.service.impl.AttributeServiceImpl.storeUnvaryingValue(AttributeServiceImpl.java:279)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy51.storeUnvaryingValue(Unknown Source)
at com.tuma_solutions.tpidw.etl.service.impl.TeamServiceImpl.getTeam(TeamServiceImpl.java:49)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:98)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:262)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:95)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy60.getTeam(Unknown Source)
at com.tuma_solutions.tpidw.pdash.service.impl.StateFileImporterImplSimple$Worker.loadOrCreateTeam(StateFileImporterImplSimple.java:309)
at com.tuma_solutions.tpidw.pdash.service.impl.StateFileImporterImplSimple$Worker.run(StateFileImporterImplSimple.java:127)
at com.tuma_solutions.tpidw.pdash.service.impl.StateFileImporterImplSimple$Worker.access$000(StateFileImporterImplSimple.java:89)
at com.tuma_solutions.tpidw.pdash.service.impl.StateFileImporterImplSimple.importTeamAndProjects(StateFileImporterImplSimple.java:57)
... 4 more
Caused by: org.h2.jdbc.JdbcBatchUpdateException: Value too long for column "TEAM_NAME VARCHAR(255)": "'Team: Kurt Voutaz - WDl - MPH - (05-12-2016 Final 12-01-15 Announced)- 10-21-15 - NVME - VSL - SanDisk 06-16-14 - Rebase dai... (289)"; SQL statement:
insert into team (row_created_by_key, row_last_updated_by_key, team_name, team_key) values (?, ?, ?, ?) [22001-170]
at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1121)
at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:123)
... 65 more

[David Tuma]

In the Team Dashboard, the "Tools > Preferences > User Interface" page displays a "Window Title" field. Someone has entered an extremely long value into that field for the team in question, and the resulting value won't fit into the target column of the database. If you edit the "Window Title" for this Team Dashboard and choose a title that is less than 256 characters long, the error will go away.

If you are opening the live team data, just make the change in the "Tools > Preferences" window, then close and reopen the Team Dashboard.

If you are seeing this error when opening a data backup, you will have to (a) change the value in Tools > Preferences; (b) choose "File > Save Data Backup" to save that change into a new ZIP file; then (c) open that new ZIP file with the Quick Launcher.