Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 15:39:09.103 [pool-1-thread-1] WARN o.h.util.JDBCExceptionReporter - SQL Error: 90005, SQLState: 90005
- 15:39:09.103 [pool-1-thread-1] ERROR o.h.util.JDBCExceptionReporter - Value too long for column "ORIGINAL_SENDER_ID VARCHAR(20)": "'eSteuer-ZH-ZH-T962031' (21)"; SQL statement:
- insert into MESSAGEHEADER (version, ACTION, COMMENTS, EVENT_DATE, EVENT_DATE_1, eventPeriod, INITIAL_MSG_DATE, LOCAL_REFERENCE, MOD_DATE, MSG_CLASS, MSG_DATE, MSG_ID, MSG_PRIO, MSG_TYPE, ORIGINAL_SENDER_ID, OUR_BUSINESS_REF_ID, PART_ACTUAL_PACKAGES, PART_ID_BC, PART_NUM_PACKAGES, RECIPIENT_ID, REF_MSG_ID, SCHEMA_VERSION, SENDER_APP_MANUF, SENDER_APP_PROD, SENDER_APP_VERSION, SENDER_ID, SUB_MSG_TYPE, SUBJECT, TEST_DELIVERY, YOUR_BUSINESS_REF_ID, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [90005-140]
- 15:39:09.103 [pool-1-thread-1] WARN o.h.util.JDBCExceptionReporter - SQL Error: 90005, SQLState: 90005
- 15:39:09.103 [pool-1-thread-1] ERROR o.h.util.JDBCExceptionReporter - Value too long for column "ORIGINAL_SENDER_ID VARCHAR(20)": "'eSteuer-ZH-ZH-T962031' (21)"; SQL statement:
- insert into MESSAGEHEADER (version, ACTION, COMMENTS, EVENT_DATE, EVENT_DATE_1, eventPeriod, INITIAL_MSG_DATE, LOCAL_REFERENCE, MOD_DATE, MSG_CLASS, MSG_DATE, MSG_ID, MSG_PRIO, MSG_TYPE, ORIGINAL_SENDER_ID, OUR_BUSINESS_REF_ID, PART_ACTUAL_PACKAGES, PART_ID_BC, PART_NUM_PACKAGES, RECIPIENT_ID, REF_MSG_ID, SCHEMA_VERSION, SENDER_APP_MANUF, SENDER_APP_PROD, SENDER_APP_VERSION, SENDER_ID, SUB_MSG_TYPE, SUBJECT, TEST_DELIVERY, YOUR_BUSINESS_REF_ID, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [90005-140]
- 15:39:09.118 [pool-1-thread-1] ERROR o.h.e.d.AbstractFlushingEventListener - Could not synchronize database state with session
- org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
- at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140) ~[fabric34830057533788277829.jar:3.5.3-Final]
- at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128) ~[fabric34830057533788277829.jar:3.5.3-Final]
- at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66) ~[fabric34830057533788277829.jar:3.5.3-Final]
- at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275) ~[fabric34830057533788277829.jar:3.5.3-Final]
- at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114) ~[fabric34830057533788277829.jar:3.5.3-Final]
- at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109) ~[fabric34830057533788277829.jar:3.5.3-Final]
- at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2403) ~[fabric34830057533788277829.jar:3.5.3-Final]
- at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2858) ~[fabric34830057533788277829.jar:3.5.3-Final]
- at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79) ~[fabric34830057533788277829.jar:3.5.3-Final]
- at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:268) ~[fabric34830057533788277829.jar:3.5.3-Final]
- at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:260) ~[fabric34830057533788277829.jar:3.5.3-Final]
- at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:179) ~[fabric34830057533788277829.jar:3.5.3-Final]
- at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321) ~[fabric34830057533788277829.jar:3.5.3-Final]
- at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51) [fabric34830057533788277829.jar:3.5.3-Final]
- at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1206) [fabric34830057533788277829.jar:3.5.3-Final]
- at org.fabric3.jpa.runtime.proxy.MultiThreadedSessionProxy.flush(MultiThreadedSessionProxy.java:90) [fabric3-jpa-hibernate-1.9.5-SNAPSHOT.jar:na]
- at com.carecon.aams.zh.ksta.store.HibernateStoreService.store(HibernateStoreService.java:26) [module-zh-ksta-processing-business-logic-1.0.0-SNAPSHOT.jar:na]
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_17]
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ~[na:1.6.0_17]
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0_17]
- at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_17]
- at org.fabric3.implementation.pojo.component.InvokerInterceptor.invoke(InvokerInterceptor.java:134) [fabric3-pojo-1.9.5-SNAPSHOT.jar:na]
- at org.fabric3.implementation.pojo.component.InvokerInterceptor.invoke(InvokerInterceptor.java:110) [fabric3-pojo-1.9.5-SNAPSHOT.jar:na]
- at org.fabric3.tx.TxInterceptor.invoke(TxInterceptor.java:80) [fabric3-tx-1.9.5-SNAPSHOT.jar:na]
- at org.fabric3.implementation.proxy.jdk.JDKInvocationHandler.invoke(JDKInvocationHandler.java:119) [fabric3-jdk-proxy-1.9.5-SNAPSHOT.jar:na]
- at $Proxy269.store(Unknown Source) [na:na]
- at com.carecon.aams.zh.ksta.processor.AHV101MessageProcessor$1.execute(AHV101MessageProcessor.java:78) [module-zh-ksta-processing-business-logic-1.0.0-SNAPSHOT.jar:na]
- at com.carecon.aams.foundation.work.TransactionalDelegateImpl.execute(TransactionalDelegateImpl.java:15) [foundation-services-1.0.0-SNAPSHOT.jar:na]
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_17]
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ~[na:1.6.0_17]
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0_17]
- at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_17]
- at org.fabric3.implementation.pojo.component.InvokerInterceptor.invoke(InvokerInterceptor.java:134) [fabric3-pojo-1.9.5-SNAPSHOT.jar:na]
- at org.fabric3.implementation.pojo.component.InvokerInterceptor.invoke(InvokerInterceptor.java:110) [fabric3-pojo-1.9.5-SNAPSHOT.jar:na]
- at org.fabric3.tx.TxInterceptor.invoke(TxInterceptor.java:80) [fabric3-tx-1.9.5-SNAPSHOT.jar:na]
- at org.fabric3.implementation.proxy.jdk.JDKInvocationHandler.invoke(JDKInvocationHandler.java:119) [fabric3-jdk-proxy-1.9.5-SNAPSHOT.jar:na]
- at $Proxy249.execute(Unknown Source) [na:na]
- at com.carecon.aams.foundation.work.AtomicWorkServiceImpl.execute(AtomicWorkServiceImpl.java:25) [foundation-services-1.0.0-SNAPSHOT.jar:na]
- at com.carecon.aams.zh.ksta.processor.AHV101MessageProcessor.record(AHV101MessageProcessor.java:70) [module-zh-ksta-processing-business-logic-1.0.0-SNAPSHOT.jar:na]
- at com.carecon.aams.zh.ksta.processor.AHV101MessageProcessor.process(AHV101MessageProcessor.java:58) [module-zh-ksta-processing-business-logic-1.0.0-SNAPSHOT.jar:na]
- at com.carecon.aams.foundation.gateway.ECHGatewayServiceImpl.process(ECHGatewayServiceImpl.java:58) [foundation-gateway-1.0.0-SNAPSHOT.jar:na]
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.6.0_17]
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) ~[na:1.6.0_17]
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) ~[na:1.6.0_17]
- at java.lang.reflect.Method.invoke(Method.java:597) ~[na:1.6.0_17]
- at org.fabric3.implementation.pojo.component.InvokerInterceptor.invoke(InvokerInterceptor.java:139) [fabric3-pojo-1.9.5-SNAPSHOT.jar:na]
- at org.fabric3.implementation.pojo.component.InvokerInterceptor.invoke(InvokerInterceptor.java:110) [fabric3-pojo-1.9.5-SNAPSHOT.jar:na]
- at org.fabric3.binding.file.runtime.receiver.PassThroughInterceptor.invoke(PassThroughInterceptor.java:52) [fabric3-binding-file-1.9.5-SNAPSHOT.jar:na]
- at org.fabric3.binding.file.runtime.receiver.FileSystemReceiver.dispatch(FileSystemReceiver.java:245) [fabric3-binding-file-1.9.5-SNAPSHOT.jar:na]
- at org.fabric3.binding.file.runtime.receiver.FileSystemReceiver.processFile(FileSystemReceiver.java:216) [fabric3-binding-file-1.9.5-SNAPSHOT.jar:na]
- at org.fabric3.binding.file.runtime.receiver.FileSystemReceiver.processFiles(FileSystemReceiver.java:168) [fabric3-binding-file-1.9.5-SNAPSHOT.jar:na]
- at org.fabric3.binding.file.runtime.receiver.FileSystemReceiver.run(FileSystemReceiver.java:139) [fabric3-binding-file-1.9.5-SNAPSHOT.jar:na]
- at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [na:1.6.0_17]
- at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317) [na:1.6.0_17]
- at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150) [na:1.6.0_17]
- at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98) [na:1.6.0_17]
- at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:181) [na:1.6.0_17]
- at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205) [na:1.6.0_17]
- at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [na:1.6.0_17]
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [na:1.6.0_17]
- at java.lang.Thread.run(Thread.java:637) [na:1.6.0_17]
- Caused by: org.h2.jdbc.JdbcBatchUpdateException: Value too long for column "ORIGINAL_SENDER_ID VARCHAR(20)": "'eSteuer-ZH-ZH-T962031' (21)"; SQL statement:
- insert into MESSAGEHEADER (version, ACTION, COMMENTS, EVENT_DATE, EVENT_DATE_1, eventPeriod, INITIAL_MSG_DATE, LOCAL_REFERENCE, MOD_DATE, MSG_CLASS, MSG_DATE, MSG_ID, MSG_PRIO, MSG_TYPE, ORIGINAL_SENDER_ID, OUR_BUSINESS_REF_ID, PART_ACTUAL_PACKAGES, PART_ID_BC, PART_NUM_PACKAGES, RECIPIENT_ID, REF_MSG_ID, SCHEMA_VERSION, SENDER_APP_MANUF, SENDER_APP_PROD, SENDER_APP_VERSION, SENDER_ID, SUB_MSG_TYPE, SUBJECT, TEST_DELIVERY, YOUR_BUSINESS_REF_ID, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [90005-140]
- at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1098) ~[h2-1.2.140.jar:1.2.140]
- at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70) ~[fabric34830057533788277829.jar:3.5.3-Final]
- at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268) ~[fabric34830057533788277829.jar:3.5.3-Final]
- ... 57 common frames omitted
- [WARNING] Transaction rolled back [pool-1-thread-1]
- [ERROR] Error processing file: envl_01.xml
- org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
- at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
- at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
- at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
- at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
- at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:114)
- at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:109)
- at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2403)
- at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2858)
- at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
- at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:268)
- at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:260)
- at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:179)
- at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
- at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
- at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1206)
- at org.fabric3.jpa.runtime.proxy.MultiThreadedSessionProxy.flush(MultiThreadedSessionProxy.java:90)
- at com.carecon.aams.zh.ksta.store.HibernateStoreService.store(HibernateStoreService.java:26)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
- at java.lang.reflect.Method.invoke(Method.java:597)
- at org.fabric3.implementation.pojo.component.InvokerInterceptor.invoke(InvokerInterceptor.java:134)
- at org.fabric3.implementation.pojo.component.InvokerInterceptor.invoke(InvokerInterceptor.java:110)
- at org.fabric3.tx.TxInterceptor.invoke(TxInterceptor.java:80)
- at org.fabric3.implementation.proxy.jdk.JDKInvocationHandler.invoke(JDKInvocationHandler.java:119)
- at $Proxy269.store(Unknown Source)
- at com.carecon.aams.zh.ksta.processor.AHV101MessageProcessor$1.execute(AHV101MessageProcessor.java:78)
- at com.carecon.aams.foundation.work.TransactionalDelegateImpl.execute(TransactionalDelegateImpl.java:15)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
- at java.lang.reflect.Method.invoke(Method.java:597)
- at org.fabric3.implementation.pojo.component.InvokerInterceptor.invoke(InvokerInterceptor.java:134)
- at org.fabric3.implementation.pojo.component.InvokerInterceptor.invoke(InvokerInterceptor.java:110)
- at org.fabric3.tx.TxInterceptor.invoke(TxInterceptor.java:80)
- at org.fabric3.implementation.proxy.jdk.JDKInvocationHandler.invoke(JDKInvocationHandler.java:119)
- at $Proxy249.execute(Unknown Source)
- at com.carecon.aams.foundation.work.AtomicWorkServiceImpl.execute(AtomicWorkServiceImpl.java:25)
- at com.carecon.aams.zh.ksta.processor.AHV101MessageProcessor.record(AHV101MessageProcessor.java:70)
- at com.carecon.aams.zh.ksta.processor.AHV101MessageProcessor.process(AHV101MessageProcessor.java:58)
- at com.carecon.aams.foundation.gateway.ECHGatewayServiceImpl.process(ECHGatewayServiceImpl.java:58)
- at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
- at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
- at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
- at java.lang.reflect.Method.invoke(Method.java:597)
- at org.fabric3.implementation.pojo.component.InvokerInterceptor.invoke(InvokerInterceptor.java:139)
- at org.fabric3.implementation.pojo.component.InvokerInterceptor.invoke(InvokerInterceptor.java:110)
- at org.fabric3.binding.file.runtime.receiver.PassThroughInterceptor.invoke(PassThroughInterceptor.java:52)
- at org.fabric3.binding.file.runtime.receiver.FileSystemReceiver.dispatch(FileSystemReceiver.java:245)
- at org.fabric3.binding.file.runtime.receiver.FileSystemReceiver.processFile(FileSystemReceiver.java:216)
- at org.fabric3.binding.file.runtime.receiver.FileSystemReceiver.processFiles(FileSystemReceiver.java:168)
- at org.fabric3.binding.file.runtime.receiver.FileSystemReceiver.run(FileSystemReceiver.java:139)
- at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)
- at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)
- at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)
- at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)
- at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:181)
- at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205)
- at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
- at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
- at java.lang.Thread.run(Thread.java:637)
- Caused by: org.h2.jdbc.JdbcBatchUpdateException: Value too long for column "ORIGINAL_SENDER_ID VARCHAR(20)": "'eSteuer-ZH-ZH-T962031' (21)"; SQL statement:
- insert into MESSAGEHEADER (version, ACTION, COMMENTS, EVENT_DATE, EVENT_DATE_1, eventPeriod, INITIAL_MSG_DATE, LOCAL_REFERENCE, MOD_DATE, MSG_CLASS, MSG_DATE, MSG_ID, MSG_PRIO, MSG_TYPE, ORIGINAL_SENDER_ID, OUR_BUSINESS_REF_ID, PART_ACTUAL_PACKAGES, PART_ID_BC, PART_NUM_PACKAGES, RECIPIENT_ID, REF_MSG_ID, SCHEMA_VERSION, SENDER_APP_MANUF, SENDER_APP_PROD, SENDER_APP_VERSION, SENDER_ID, SUB_MSG_TYPE, SUBJECT, TEST_DELIVERY, YOUR_BUSINESS_REF_ID, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) [90005-140]
- at org.h2.jdbc.JdbcPreparedStatement.executeBatch(JdbcPreparedStatement.java:1098)
- at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
- at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
- ... 57 more
Add Comment
Please, Sign In to add comment