Hide Forgot
Created attachment 575083 [details] stack trace in the server log Description of problem: Running jbpm console test with DB2 9.7 resulted in: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, SQLERRMC=null, DRIVER=4.12.55 Could not synchronize database state with session org.hibernate.exception.DataException: could not update: [org.drools.persistence.info.SessionInfo#1] The sql code specifies that "DB2 received data that was invalid or too large to fit in the corresponding column of the table." http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=%2Fcom.ibm.db2z10.doc.codes%2Fsrc%2Ftpc%2Fn302.htm Version-Release number of selected component (if applicable): BRMS 5.3.0 ER5 Additional info: It is quite probable this is due to the attribute: @Lob private byte[] rulesByteArray of the class SessionInfo in org.drools.persistence.info, which does not specify the size of the column. It seems as if the DB2 database defaults to 1M, which might not be enough - see link below. https://hibernate.onjira.com/browse/HHH-2969
Should be fixed as a side effect of bug 807595 comment 5.
Update status to ON_QA. Please verify them against ER6.
I see no change. Lukas, you put it on MODIFIED about a month back, do you remember why?
(In reply to comment #6) > I see no change. > Lukas, you put it on MODIFIED about a month back, do you remember why? See comment 3.
Zuzana, It looks like this failed the QA tests? If you could post any stack traces, other info or any ideas why it failed, that would be great. Thanks.
(In reply to comment #8) > Zuzana, > > It looks like this failed the QA tests? If you could post any stack traces, > other info or any ideas why it failed, that would be great. > > Thanks. Here: https://hudson.qa.jboss.com/hudson/job/brms-jbpm_cons-db/25/DATABASE=db2-97,jdk=java16_default,label_exp=brFF&&%28RHEL5||RHEL6%29&&!dev82-rhel6-x86_64/artifact/artifacts/log/server.log is the whole server log of a recent run with ER6. Hope it helps. And sorry, I somehow didn't see the 3rd comment.
I hadn't modified the drools classes that had lob columns. I've just pushed a commit to the community drools 5.2.x branch that fixes this: https://github.com/droolsjbpm/drools/commit/bfc2007f61afcd8e676759045262821baa635658
Fixed string blobs as well, and pushed to community jbpm 5.2.x branch: https://github.com/droolsjbpm/jbpm/commit/813c38f9d1d0eaafe45ce29b9b7b191d96bef20b
The fixed for this issue should be included in ER7. Please do verification on it.