Red Hat Bugzilla – Bug 1315242
DB2 9.7 Can't get metadata on specified data set: jbpmProcessInstances
Last modified: 2016-03-23 02:18:07 EDT
Created attachment 1133709 [details]
Description of problem:
Using process instance perspective with DB2 9.7 database fails on SqlSyntaxErrorException. This is the same bug as already reported here , but this is the first time it occured on 6.2 product.
We should decide if we want to backport fix from later versions or if we only document this for 6.2 and leave the fix for later.
Version-Release number of selected component (if applicable): 6.2.2.CR1
Neus, could you please take a look at this as you're most likely are more up to date with this part.
In the 6.3 version:
The queries over the console have been updated to work fine over all supported databases.
The dashbuilder have included the fix for this issue in the 0.4.x
And the jbpm-console-ng queries have been updated in this PR waiting to be merge
https://github.com/droolsjbpm/jbpm-console-ng/pull/353 at 6.4.x
In the previous version (6.2)
Now, we have to decide if the fix, have to be ported to 6.2. In that sense, David can answer better the question of if dashbuilder can take this fix for previous version of dashbuilder.
In jira it's reported at:
David can you take a look on the possibility to take the LIMIT issue fix to previous version?
Yes, I think the issue can be backported, Although I'd need look to into it thoroughly, to asses the impact.
@Tibor can you confirm a backport is needed?
After discussion with David - we agreed to backport this so we get rid of all DB2 issues related to this case and I agree with this.
The fix https://issues.jboss.org/browse/DASHBUILDE-96 has been backported to the 6.2 product branch (i.e: dashbuilder 0.3.x):
Working fine now. Verified with BPM Suite 6.2.2 CR2