Red Hat Bugzilla – Bug 1005555
Unable to delete workspace when using Oracle database
Last modified: 2014-08-06 16:09:33 EDT
Created attachment 795319 [details]
Server log with UNEXPECTED ERROR
Description of problem:
When you use Orace as an underlying datasource, the application shows Unexpected error dialog (java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got BLOB) when you try to delete a workspace.
Version-Release number of selected component (if applicable):
BPMS 6.0.0 ER2 deployed on EAP 6.1; EAP configured to use Oracle version 11g R2 as a datasource.
Steps to Reproduce:
1. Configure EAP to use Oracle 11g R2 as datasource for dashbuilder
2. Login to dashbuilder application with root user
3. Select workspace Showcase and create duplicate of it using 'Duplicate workspace' button in the administrator bar.
4. Select duplicated workspace 'Copy of Showcase' and click 'Delete workspace' in the admin bar.
Unexpected error dialog appears displaying expection (see error log attached, search for UNEXPECTED ERROR), also the workspace is not deleted.
Deletion of workspace should be possible without exceptions
Marking this as test blocker, because our test suite relies heavily on Duplicate workspace functionality. To ensure test independence we must create and then delete workspaces. With this bug present we are unable to run more than 1/2 of our automated dashbuilder UI test suite.
The app throws this exception when a query over the database is executed to retrieve the panelInstances with an especiffic kpi configurated to check it it can be removed. This query fails on oracle because the restriction is over a field of type BLOB. We have changed the implementation to avoid this problem.
Now we do this check by software, iterating along the instances with kpi configurated.
This change encapsulates the modification in PanelsManagerImpl to be more easy to update when hibernate lets do the query ober blob files.
Verified with BPMS 6.0.0 ER4 + Oracle 11gR2