Bug 1135453
| Summary: | Business Central cluster fails to execute deadlines and timers due to error when storing quartz job details into DB2 database | ||||||
|---|---|---|---|---|---|---|---|
| Product: | [Retired] JBoss BPMS Platform 6 | Reporter: | Radovan Synek <rsynek> | ||||
| Component: | Business Central | Assignee: | Marco Rietveld <mrietvel> | ||||
| Status: | CLOSED EOL | QA Contact: | Radovan Synek <rsynek> | ||||
| Severity: | high | Docs Contact: | Dawn Eisner <deisner> | ||||
| Priority: | high | ||||||
| Version: | 6.0.2 | CC: | kverlaen, rrajasek, rzhang | ||||
| Target Milestone: | DR3 | ||||||
| Target Release: | 6.1.0 | ||||||
| Hardware: | Unspecified | ||||||
| OS: | Unspecified | ||||||
| Whiteboard: | |||||||
| Fixed In Version: | Doc Type: | Bug Fix | |||||
| Doc Text: | Story Points: | --- | |||||
| Clone Of: | |||||||
| : | 1189381 (view as bug list) | Environment: | |||||
| Last Closed: | 2020-03-27 20:10:28 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: |
|
||||||
DDL for DB2 fixed on master jbpm master https://github.com/droolsjbpm/jbpm/commit/8e5ddcb7c24b3feccc053e8825924f6aa19ebc2b if that shall be back ported please reassign it back to me Maciej, could you please back port it, as jboss-bpms-6.0.3 flag has been set? backported to 6.0.x branch jbpm 6.0.x: https://github.com/droolsjbpm/jbpm/commit/0dcd8e515bdf08d97c4e2d60fadc1d92867a588d After discussion with Rajesh, I have documented this as a warning in the setup of quartz in the Installation Guide here [1]. Please read and verify it accurately covers the issue. [1] http://documentation-devel.engineering.redhat.com/site/documentation/en-US/Red_Hat_JBoss_BPM_Suite/6.0/html-single/Installation_Guide/index.html#Setting_up_Quartz Verified with BPMS-6.1.0.DR3 |
Created attachment 932624 [details] error stacktrace Description of problem: Having a BPMS cluster with two EAP 6 nodes and DB2 database as persistence storage, any process dealing with timers or deadlines fails with error (see attachment for details) saying that: org.jbpm.workflow.instance.WorkflowRuntimeException: [clustering.TimerDuration:5 - :2] -- org.quartz.JobPersistenceException: Couldn't store job: DB2 SQL Error: SQLCODE=-302, SQLSTATE=22001, The reason is probably column job_data in table qrtz_job_details, which is of type blob(2000). Removing the capacity restrictions (i.e. just "blob") fixed the issue for me. Comparing DDL for other DBs, there is always some kind of "blob" type without any explicit limitations for this column. Version-Release number of selected component (if applicable): 6.0.3.ER1 How reproducible: always Steps to Reproduce: 1. configure BPMS cluster to use DB2 database 2. use any timer scenario, e.g. start->timer(1s)->end 3. deploy & run this process, watch for errors in server logs