fail to push the studies to dcm4chee server

625 views
Skip to first unread message

fahad...@manchester.ac.uk

unread,
Jan 8, 2013, 9:20:59 AM1/8/13
to dcm...@googlegroups.com
While pushing the studies from Philip scanner to DCM4CHEE sever on some studies the process failed. I can see the following 02 error entries int server.log file, can somebody help in understanding the issue and possible solution to it

"
inst: 1.3.46.670589.11.22117.5.20.1.1.7708.2013010811465693934/?
status: 110
error comment: org.dcm4che.net.DcmServiceException: javax.ejb.CreateException:
2013-01-08 11:52:47,612 INFO WMICMR1->DCM4CHEE (TCPServer-1) http://org.dcm4cheri.net.FsmImpl received A-ABORT
source=0 - service-user
reason=0 - reason-not-specified
2013-01-08 11:52:47,612 INFO WMICMR1->DCM4CHEE (TCPServer-1) http://org.dcm4cheri.net.FsmImpl closing connection - Socketaddr=port=,localport="


"ERROR WMICMR1->DCM4CHEE (TCPServer-1) http://org.jboss.ejb.plugins.cmp.jdbc.keygen.JDBCMySQLCreateCommand.Instance Could not create entity
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'xml_data' at row 1"


With regards

Fahad

Arnold Maderthaner

unread,
Jan 8, 2013, 10:03:56 AM1/8/13
to dcm...@googlegroups.com
Seams that an exception happens already before that (CreateException). Can you search the logfile for that Exception ?

Fahad Anwar

unread,
Jan 8, 2013, 10:48:38 AM1/8/13
to dcm...@googlegroups.com

Thanks for looking into it; I can find following exceptions (multiple times)

 

(TCPServer-1-3) [org.dcm4chex.archive.dcm.storescp.StoreScpService] failed to update DB with entries for received 2013/1/8/15/2CC6F44F/0A92E9DC/450424CC - retry

org.dcm4che.net.DcmServiceException: javax.ejb.CreateException: Could not create entity:com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'trigger_time' at row 1

                at org.dcm4chex.archive.ejb.session.StorageBean.store(StorageBean.java:228)

                at sun.reflect.GeneratedMethodAccessor262.invoke(Unknown Source)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

                at java.lang.reflect.Method.invoke(Method.java:597)

                at org.jboss.invocation.Invocation.performCall(Invocation.java:359)

                at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)

                at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)

                at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)

                at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)

                at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)

                at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)

                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.GeneratedMethodAccessor130.invoke(Unknown Source)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

                at java.lang.reflect.Method.invoke(Method.java:597)

                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 $Proxy222.store(Unknown Source)

                at org.dcm4chex.archive.dcm.storescp.StoreScp.updateDB(StoreScp.java:976)

                at org.dcm4chex.archive.dcm.storescp.StoreScp.doActualCStore(StoreScp.java:678)

                at org.dcm4chex.archive.dcm.storescp.StoreScp.doCStore(StoreScp.java:449)

                at org.dcm4che.net.DcmServiceBase.c_store(DcmServiceBase.java:116)

                at org.dcm4cheri.net.ActiveAssociationImpl.run(ActiveAssociationImpl.java:226)

                at org.dcm4cheri.util.LF_ThreadPool.join(LF_ThreadPool.java:174)

                at org.dcm4cheri.net.ActiveAssociationImpl.run(ActiveAssociationImpl.java:157)

                at org.dcm4cheri.server.DcmHandlerImpl.handle(DcmHandlerImpl.java:249)

                at org.dcm4cheri.server.ServerImpl.run(ServerImpl.java:279)

                at org.dcm4cheri.util.LF_ThreadPool.join(LF_ThreadPool.java:174)

                at org.dcm4cheri.util.LF_ThreadPool$1.run(LF_ThreadPool.java:221)

                at java.lang.Thread.run(Thread.java:619)

Caused by: javax.ejb.CreateException: Could not create entity:com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'trigger_time' at row 1

                at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.performInsert(JDBCAbstractCreateCommand.java:340)

                at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.execute(JDBCAbstractCreateCommand.java:151)

                at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.createEntity(JDBCStoreManager.java:587)

                at org.jboss.ejb.plugins.CMPPersistenceManager.createEntity(CMPPersistenceManager.java:237)

                at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.createEntity(CachedConnectionInterceptor.java:225)

                at org.jboss.ejb.EntityContainer.createLocalHome(EntityContainer.java:625)

                at sun.reflect.GeneratedMethodAccessor186.invoke(Unknown Source)

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

                at java.lang.reflect.Method.invoke(Method.java:597)

                at org.jboss.invocation.Invocation.performCall(Invocation.java:359)

                at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1126)

                at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:105)

                at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:203)

                at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:189)

                at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:105)

                at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:136)

                at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:76)

                at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:45)

                at org.jboss.ejb.plugins.CallValidationInterceptor.invokeHome(CallValidationInterceptor.java:56)

                at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:125)

                at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)

                at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:161)

                at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:145)

                at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:132)

                at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invokeHome(ProxyFactoryFinderInterceptor.java:107)

                at org.jboss.ejb.EntityContainer.internalInvokeHome(EntityContainer.java:521)

                at org.jboss.ejb.Container.invoke(Container.java:981)

                at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invokeHome(BaseLocalProxyFactory.java:359)

                at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:133)

                at $Proxy123.create(Unknown Source)

                at org.dcm4chex.archive.ejb.session.StorageBean.store(StorageBean.java:200)

                ... 45 more

Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'trigger_time' 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.keygen.JDBCMySQLCreateCommand.executeInsert(JDBCMySQLCreateCommand.java:107)

                at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractCreateCommand.performInsert(JDBCAbstractCreateCommand.java:321)

                ... 75 more

--
You received this message because you are subscribed to the Google Groups "dcm4che" group.
To post to this group, send email to dcm...@googlegroups.com.
To unsubscribe from this group, send email to dcm4che+u...@googlegroups.com.
Visit this group at http://groups.google.com/group/dcm4che?hl=en.
 
 

Damien Evans

unread,
Jan 8, 2013, 4:03:30 PM1/8/13
to dcm...@googlegroups.com
Can you send me a sample image at dev...@dcm4che.com, and let me know what version of MySQL you are using, and what platform (e.g. Linux or Windows)?

In googling this error, it seems that it can be caused in a lot of different ways and it is difficult to help you solve it without being able to reproduce it and troubleshoot.

 -- Damien

Arnold Maderthaner

unread,
Jan 9, 2013, 9:15:45 AM1/9/13
to dcm...@googlegroups.com
which version of mysql are you using ?

To unsubscribe from this group, send email to dcm4che+unsubscribe@googlegroups.com.

Reply all
Reply to author
Forward
0 new messages