#308 Exception thrown starting up process dashboard.

[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)": "'Kurt Voutaz - 12/01/15 - Western Digital (tentative - 2nd quarter 2016)- 10-21-15 -SanDisk 06-16-14 (f.k.a. Fusion-io - 05-12... (261)"; 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]

Thank you for reporting this! I will get it fixed soon.

In the meantime, you can work around this defect by renaming this dashboard/file. Examine the error message above and look about four rows from the end. You will see a name that you should recognize. As it happens, the name in question was too long, causing an overflow in a database column that only expected 255 characters. Shortening that name will resolve the error for you.

• If this error occurred while you were opening a data backup in the Quick Launcher, that name is coming from the filename of the data backup you opened. Rename that file on your hard drive to be shorter, then try opening the file again.
• If this error occurred while you were opening a "live" Team Dashboard, that name is coming from the "Window Title" that you configured on the "Tools > Preferences > User Interface" page. Shorten that window title, save the change, then close and reopen the Team Dashboard.

[David Tuma]

Fixed in Process Dashboard version 2.7