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 How reproducible: Always Steps to Reproduce: are the same as for BZ 1005555 metnioned above, except for configuration of datasource - use Microsoft SQL Server 2008 R2 Actual results: The unexpected error dialog appears with exception (see server.log attached), duplicated workspace is not deleted. Expected results: No exception is thrown, duplicated workspaces can be deleted successfully.
Is the same problem that was resolved in bug: https://bugzilla.redhat.com/show_bug.cgi?id=1005555 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