Data truncation: Data too long for column 'cuids_in_study' at row 1

154 views
Skip to first unread message

o...@stanstrup.dk

unread,
Nov 22, 2018, 12:22:39 AM11/22/18
to dcm4che

I have one server which keeps giving this error:
Data truncation: Data too long for column 'cuids_in_study' at row 1

Tried to restart the dcm4chee service but it continues when started again.

Does anyone know how to fix this?

2018-11-22 06:19:26,255 ERROR -> (Thread-58) [org.jboss.ejb.plugins.LogInterceptor] TransactionRolledbackException in method: public abstract org.dcm4chex.ar
chive.common.SeriesStored org.dcm4chex.archive.ejb.interfaces.Storage.makeSeriesStored(java.lang.Long,java.sql.Timestamp) throws javax.ejb.FinderException,ja
va.rmi.RemoteException, causedBy:
javax.transaction.RollbackException: [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] [com.arjuna.ats.internal.jta.transaction.arjunaco
re.commitwhenaborted] Can't commit because the transaction is in aborted state
        at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commit(TransactionImple.java:255)
        at org.jboss.ejb.plugins.TxInterceptorCMT.endTransaction(TxInterceptorCMT.java:501)
        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:361)
        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)
        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
        at org.jboss.ejb.Container.invoke(Container.java:960)
        at sun.reflect.GeneratedMethodAccessor112.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:606)
        at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
        at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
        at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
        at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
        at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
        at org.jboss.invocation.local.LocalInvoker$MBeanServerAction.invoke(LocalInvoker.java:169)
        at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:118)
        at org.jboss.invocation.InvokerInterceptor.invokeLocal(InvokerInterceptor.java:209)
        at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:195)
        at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:61)
        at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:70)
        at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:112)
        at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:100)
        at com.sun.proxy.$Proxy259.makeSeriesStored(Unknown Source)
        at org.dcm4chex.archive.dcm.storescp.StoreScpService.checkPendingSeriesStored(StoreScpService.java:1018)
        at org.dcm4chex.archive.dcm.storescp.StoreScpService.access$300(StoreScpService.java:109)
        at org.dcm4chex.archive.dcm.storescp.StoreScpService$3$1.run(StoreScpService.java:150)
        at java.lang.Thread.run(Thread.java:724)
Caused by: javax.ejb.EJBException: Store failed
        at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.execute(JDBCStoreEntityCommand.java:158)
        at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.storeEntity(JDBCStoreManager.java:666)
        at org.jboss.ejb.plugins.CMPPersistenceManager.storeEntity(CMPPersistenceManager.java:428)
        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.storeEntity(CachedConnectionInterceptor.java:273)
        at org.jboss.ejb.EntityContainer.storeEntity(EntityContainer.java:756)
        at org.jboss.ejb.GlobalTxEntityMap$2.synchronize(GlobalTxEntityMap.java:149)
        at org.jboss.ejb.GlobalTxEntityMap$GlobalTxSynchronization.synchronize(GlobalTxEntityMap.java:314)
        at org.jboss.ejb.GlobalTxEntityMap$GlobalTxSynchronization.beforeCompletion(GlobalTxEntityMap.java:364)
        at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:114)
        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:247)
        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:86)
        at com.arjuna.ats.arjuna.AtomicAction.end(AtomicAction.java:216)
        at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commit(TransactionImple.java:240)
        ... 29 more
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'cuids_in_study' at row 1
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2939)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1623)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1715)
        at com.mysql.jdbc.Connection.execSQL(Connection.java:3249)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1268)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1541)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1455)
        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1440)
        at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:365)
        at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreEntityCommand.execute(JDBCStoreEntityCommand.java:150)
        ... 41 more
2018-11-22 06:19:26,255 WARN  -> (Thread-58) [org.dcm4chex.archive.dcm.storescp.StoreScpService] makeSeriesStored for series(pk=640786) failed! Ignored! Reason:org.jboss.tm.JBossTransactionRolledbackException: null; nested exception is:
        javax.transaction.RollbackException: [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] Can't commit because the transaction is in aborted state; - nested throwable: (javax.transaction.RollbackException: [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] [com.arjuna.ats.internal.jta.transaction.arjunacore.commitwhenaborted] Can't commit because the transaction is in aborted state)

Arnold Maderthaner

unread,
Dec 13, 2018, 5:43:18 AM12/13/18
to dcm4che
Whats the column length? Maybe you need to extend it

o...@stanstrup.dk

unread,
Dec 13, 2018, 6:09:58 AM12/13/18
to dcm4che
cuids_in_study is set to VARCHAR with lenght 250

Arnold Maderthaner

unread,
Dec 13, 2018, 12:15:08 PM12/13/18
to dcm4che
could you try to extend it and check if it makes a difference ?

Am Donnerstag, 13. Dezember 2018 12:09:58 UTC+1 schrieb 
Reply all
Reply to author
Forward
0 new messages