- Red Hat JBoss BPM Suite
We applied the latest patch for BPM Suite 6.4.6 and we started seeing the following errors continuously:
ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (EJB default - 1) ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.
- Upgrade to BPM Suite 6.4.111 in order to use
- In BPM Suite 6.4.6, 6.4.7 and 6.4.8 it is required to use
In BPMS 6.4.6, a new column
priority has been added to the
RequestInfo table to allow prioritization of asynchronous tasks.1 This results in a query syntax that is unsupported by Oracle when using
Note that dialect should be configured in 2 places:
- system property "org.kie.server.persistence.dialect" (e.g. in standalone.xml)
As the default Oracle dialect can potentially lead to a job getting executed by multiple job executor threads, a fix for the failing query has been provided to support the
org.jbpm.persistence.jpa.hibernate.DisabledFollowOnLockOracle10gDialect in BPMS 6.4.9 again.2 Another fix in this code has been provided in BPMS 188.8.131.52
This solution is part of Red Hat’s fast-track publication program, providing a huge library of solutions that Red Hat engineers have created while supporting our customers. To give you the knowledge you need the instant it becomes available, these articles may be presented in a raw and unedited form.