Bug 973132
Summary: | When BAM deployed with jBPM Console - tables bamtasksummary & processinstancelog not created | ||||||
---|---|---|---|---|---|---|---|
Product: | [Retired] JBoss BPMS Platform 6 | Reporter: | Jan Hrcek <jhrcek> | ||||
Component: | BAM | Assignee: | David Gutierrez <dgutierr> | ||||
Status: | CLOSED CURRENTRELEASE | QA Contact: | Jan Hrcek <jhrcek> | ||||
Severity: | medium | Docs Contact: | |||||
Priority: | medium | ||||||
Version: | 6.0.0 | CC: | lpetrovi, rzhang | ||||
Target Milestone: | ER2 | ||||||
Target Release: | 6.0.0 | ||||||
Hardware: | Unspecified | ||||||
OS: | Unspecified | ||||||
Whiteboard: | |||||||
Fixed In Version: | Doc Type: | Bug Fix | |||||
Doc Text: | Story Points: | --- | |||||
Clone Of: | Environment: | ||||||
Last Closed: | 2014-08-06 20:12:29 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: |
|
Description
Jan Hrcek
2013-06-11 10:53:45 UTC
Additional note - there is also mismatch in names of primary keys in processinstancelog tables. In H2 database: processinstancelog - primary key declared with name "pk" ProcessInstanceLog - primary key declared with name "id" See error in application log attached: Error executing CREATE INDEX idx_ps_pk on processinstancelog(pk): Column "PK" not found; SQL statement: ---------------- Also ProcessInstanceLog created by jBPM console has some extra columns not taken into account by BAM. This issue needs to be looked at complexly: - Dashbuilder is supposed to read data from jBPM. Why does it try to recreate jBPM tables from its own DDL files? - Is low-level DB access really the best way to expose the data? Exposing implementation to outside world is almnost always a bad idea. - If it absolutely must do the above, then we must make sure that it is always deployed after jBPM - so that jBPM tables never get changed. All that issues were caused by having the jBPM dashboard as part of the generic dashboard-builder project. The real problem is: 1.- When installed standalone (no kie-wb present) dashbuilder creates the jbpm history log tables needed by JBPM dashboard and everything works fine. 2.- But when was installed togheter with kie-wb we run into the issues you commented because jbpm tables are already created. What we've done is to move to a separated repo all the jBPM related stuff. This new repo https://github.com/droolsjbpm/jbpm-dashboard is used to generate the artifacts belonging to the BPMS stack whereas, now, the original dashboard-builder repo only contains the generic dashboard builder stuff. So to sum up, 1.- dashboard-builder project no longer contains jBPM related stuff. It's a generic project which in fact is being used by other projects like Teiid https://github.com/teiid/teiid-dashboard. 2.- jbpm-dashboard project is intented to be installed togheter with kie-wb or the jbpm console. If installed alone then the provided jBPM dashboard will fail because will not find the required jbpm history log tables. With this new approach all the issues reported no longer apply. Verified with BPMS 6.0.0 ER2 |