Red Hat Bugzilla – Bug 1005674
Unable to delete workspace when using Microsoft SQL Server 2008 database
Last modified: 2014-08-06 16:09:20 EDT
Created attachment 795506 [details]
Server log with UNEXPECTED ERROR
Description of problem:
Similarly as in https://bugzilla.redhat.com/show_bug.cgi?id=1005555,
when you try to delete duplicated workspace while using Microsoft SQL Server 2008 R2 as an underlying data source, you get an UNEXPECTED ERROR and the duplicated workspace is note deleted.
The exception thrown is:
com.microsoft.sqlserver.jdbc.SQLServerException: The data types text and nvarchar are incompatible in the equal to operator.
Attaching server log with error.
Version-Release number of selected component (if applicable):
BPMS 6.0.0 ER2 deployed on EAP 6.1.0, configured with Microsoft SQL server 2008 R2
Steps to Reproduce:
are the same as for BZ 1005555 metnioned above, except for configuration of datasource - use Microsoft SQL Server 2008 R2
The unexpected error dialog appears with exception (see server.log attached), duplicated workspace is not deleted.
No exception is thrown, duplicated workspaces can be deleted successfully.
Is the same problem that was resolved in bug:
We have changed the check of if another panel has the kpi configured when a panel is deleted implementation, to avoid the query error with the comparison 'text and nvarchar are incompatible in the equal to operator'
The commits that resolve this issue are described in that bug report
Verified with BPMS 6.0.0 ER4 + MSSQL 2008 R2