Bug 1067317
| Summary: | DB2-97 - short columns for bpel engine data | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Product: | [JBoss] JBoss Fuse Service Works 6 | Reporter: | Jiri Sedlacek <jsedlace> | ||||||||||||||
| Component: | BPEL Integration | Assignee: | Václav Chalupa <vchalupa> | ||||||||||||||
| Status: | CLOSED DEFERRED | QA Contact: | Martin Basovník <mbasovni> | ||||||||||||||
| Severity: | urgent | Docs Contact: | |||||||||||||||
| Priority: | unspecified | ||||||||||||||||
| Version: | 6.0.0 GA | CC: | ganandan, ldimaggi, mbasovni, mvecera, oskutka, soa-p-jira, stejohns, tsykora | ||||||||||||||
| Target Milestone: | CR1 | ||||||||||||||||
| Target Release: | 6.1.0 | ||||||||||||||||
| Hardware: | Unspecified | ||||||||||||||||
| OS: | Unspecified | ||||||||||||||||
| Whiteboard: | |||||||||||||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||||||||||||
| Doc Text: | Story Points: | --- | |||||||||||||||
| Clone Of: | Environment: | ||||||||||||||||
| Last Closed: | 2015-09-18 09:55:42 UTC | Type: | Bug | ||||||||||||||
| Regression: | --- | Mount Type: | --- | ||||||||||||||
| Documentation: | --- | CRM: | |||||||||||||||
| Verified Versions: | Category: | --- | |||||||||||||||
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||||||||||||
| Cloudforms Team: | --- | Target Upstream Version: | |||||||||||||||
| Embargoed: | |||||||||||||||||
| Attachments: |
|
||||||||||||||||
Martin Basovnik (QE) will attempt to recreate the issue. I can confirm this bug is reproducible. Version-Release number of selected component (if applicable): FSW 6.0.0.GA How reproducible: 100% Steps to Reproduce: The same as in bug description. Environment: OS: Linux 64bit Java: OpenJDK 1.7.0_55 DB: db2-97 (from dbAllocator) Reproduced using dballo05. Investigating further. Martin - can you attach the SQL logs for the test too? Thanks! Created attachment 902538 [details]
JDBC log files from FSW installation
Created attachment 902539 [details]
JDBC log from test deployment
Created attachment 902540 [details]
error in server log
Created attachment 902553 [details]
JDBC log from test deployment
Created attachment 902554 [details]
JDBC log files from FSW start
Created attachment 902555 [details]
JDBC log files from FSW install
It looks like the following SQL statement fails with too large a value bound to the "VALUE" column insert into BPAF_EVENT_DATA (TID, EVENT_ID, NAME, VALUE) values (default, ?, ?, ?), 1) Will look at the java persistence annotation to see if it can be fixed at that level without disruption to the other databases. Tracked here: https://issues.jboss.org/browse/ENTESB-3982 |
I've installed FSW6 with DB2-97, deployed bpel say-hello QS, run it, following exception was thrown. It seems some column is too short for inserted data. 20:32:17,709 INFO [org.apache.ode.utils.WatchDog] (http-localhost/127.0.0.1:8080-12) [Endpoint files for {DeploymentUnit switchyard-quickstart-bpel-service-say-hello_SayHello-0}] updated 20:32:24,844 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ODEServer-1) SQL Error: -302, SQLState: 22001 20:32:24,848 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ODEServer-1) DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.14.122 20:32:24,852 ERROR [org.jboss.soa.bpel.console.bpaf.JDBCPersistenceStrategy] (ODEServer-1) Error persisting event: javax.persistence.PersistenceException: org.hibernate.exception.DataException: could not execute statement at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387) [hibernate-entitymanager-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310) [hibernate-entitymanager-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1316) [hibernate-entitymanager-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:881) [hibernate-entitymanager-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.jboss.soa.bpel.console.bpaf.JDBCPersistenceStrategy.persist(JDBCPersistenceStrategy.java:55) [riftsaw-bpaf-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.jboss.soa.bpel.console.bpaf.BPAFLogAdapter.onEvent(BPAFLogAdapter.java:39) [riftsaw-bpaf-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.bpel.engine.BpelEngineImpl.fireEvent(BpelEngineImpl.java:538) [riftsaw-bpel-runtime-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.bpel.engine.BpelProcess.saveEvent(BpelProcess.java:723) [riftsaw-bpel-runtime-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.sendEvent(BpelRuntimeContextImpl.java:1298) [riftsaw-bpel-runtime-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.bpel.runtime.ACTIVITY.sendEvent(ACTIVITY.java:97) [riftsaw-bpel-runtime-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.bpel.runtime.ACTIVITY.sendEvent(ACTIVITY.java:88) [riftsaw-bpel-runtime-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.bpel.runtime.ACTIVITYGUARD.run(ACTIVITYGUARD.java:88) [riftsaw-bpel-runtime-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_40] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) [rt.jar:1.7.0_40] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.7.0_40] at java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_40] at org.apache.ode.jacob.vpu.JacobVPU$JacobThreadImpl.run(JacobVPU.java:451) [riftsaw-jacob-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.jacob.vpu.JacobVPU.execute(JacobVPU.java:139) [riftsaw-jacob-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.bpel.engine.BpelRuntimeContextImpl.execute(BpelRuntimeContextImpl.java:1089) [riftsaw-bpel-runtime-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.bpel.engine.PartnerLinkMyRoleImpl.invokeNewInstance(PartnerLinkMyRoleImpl.java:208) [riftsaw-bpel-runtime-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.bpel.engine.BpelProcess$1.invoke(BpelProcess.java:302) [riftsaw-bpel-runtime-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:255) [riftsaw-bpel-runtime-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.bpel.engine.BpelProcess.invokeProcess(BpelProcess.java:298) [riftsaw-bpel-runtime-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.bpel.engine.BpelProcess.handleJobDetails(BpelProcess.java:457) [riftsaw-bpel-runtime-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:478) [riftsaw-bpel-runtime-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.bpel.engine.BpelEngineImpl.onScheduledJob(BpelEngineImpl.java:417) [riftsaw-bpel-runtime-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.bpel.engine.BpelServerImpl.onScheduledJob(BpelServerImpl.java:455) [riftsaw-bpel-runtime-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable$1.call(SimpleScheduler.java:576) [riftsaw-scheduler-simple-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable$1.call(SimpleScheduler.java:566) [riftsaw-scheduler-simple-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:294) [riftsaw-scheduler-simple-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.scheduler.simple.SimpleScheduler.execTransaction(SimpleScheduler.java:251) [riftsaw-scheduler-simple-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.processInTransactionContext(SimpleScheduler.java:566) [riftsaw-scheduler-simple-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.call(SimpleScheduler.java:546) [riftsaw-scheduler-simple-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at org.apache.ode.scheduler.simple.SimpleScheduler$RunJobCallable.call(SimpleScheduler.java:533) [riftsaw-scheduler-simple-3.0.0.Final-redhat-8.jar:3.0.0.Final-redhat-8] at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_40] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_40] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_40] at java.lang.Thread.run(Thread.java:724) [rt.jar:1.7.0_40] Caused by: org.hibernate.exception.DataException: could not execute statement at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:71) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:136) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.id.IdentityGenerator$GetGeneratedKeysDelegate.executeAndExtract(IdentityGenerator.java:96) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:58) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2966) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3477) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.action.internal.EntityIdentityInsertAction.execute(EntityIdentityInsertAction.java:81) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.engine.spi.ActionQueue.addResolvedEntityInsertAction(ActionQueue.java:203) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:183) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:167) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:321) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:286) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:192) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78) [hibernate-entitymanager-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:843) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:836) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.ejb.engine.spi.EJB3CascadingAction$1.cascade(EJB3CascadingAction.java:53) [hibernate-entitymanager-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.engine.internal.Cascade.cascadeToOne(Cascade.java:387) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.engine.internal.Cascade.cascadeAssociation(Cascade.java:330) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.engine.internal.Cascade.cascadeProperty(Cascade.java:208) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.engine.internal.Cascade.cascadeCollectionElements(Cascade.java:416) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.engine.internal.Cascade.cascadeCollection(Cascade.java:357) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.engine.internal.Cascade.cascadeAssociation(Cascade.java:333) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.engine.internal.Cascade.cascadeProperty(Cascade.java:208) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.engine.internal.Cascade.cascade(Cascade.java:165) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.event.internal.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:449) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:292) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:192) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:125) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78) [hibernate-entitymanager-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:853) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:827) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.internal.SessionImpl.persist(SessionImpl.java:831) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:875) [hibernate-entitymanager-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] ... 34 more Caused by: com.ibm.db2.jcc.am.SqlDataException: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.14.122 at com.ibm.db2.jcc.am.ed.a(ed.java:669) at com.ibm.db2.jcc.am.ed.a(ed.java:60) at com.ibm.db2.jcc.am.ed.a(ed.java:127) at com.ibm.db2.jcc.am.oo.c(oo.java:2715) at com.ibm.db2.jcc.am.oo.a(oo.java:2163) at com.ibm.db2.jcc.t4.ab.o(ab.java:849) at com.ibm.db2.jcc.t4.ab.j(ab.java:267) at com.ibm.db2.jcc.t4.ab.d(ab.java:55) at com.ibm.db2.jcc.t4.p.c(p.java:44) at com.ibm.db2.jcc.t4.qb.j(qb.java:147) at com.ibm.db2.jcc.am.oo.kb(oo.java:2158) at com.ibm.db2.jcc.am.po.b(po.java:4452) at com.ibm.db2.jcc.am.po.ic(po.java:799) at com.ibm.db2.jcc.am.po.executeUpdate(po.java:777) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493) at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:133) [hibernate-core-4.2.0.SP1-redhat-1.jar:4.2.0.SP1-redhat-1] ... 73 more