Bug 1005674

Summary: Unable to delete workspace when using Microsoft SQL Server 2008 database
Product: [Retired] JBoss BPMS Platform 6 Reporter: Jan Hrcek <jhrcek>
Component: BAMAssignee: Neus Miras <nmirasch>
Status: CLOSED CURRENTRELEASE QA Contact: Jan Hrcek <jhrcek>
Severity: high Docs Contact:
Priority: medium    
Version: 6.0.0CC: atangrin
Target Milestone: ER4Keywords: TestBlocker
Target Release: 6.0.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-08-06 20:09:20 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
Server log with UNEXPECTED ERROR none

Description Jan Hrcek 2013-09-09 06:50:53 UTC
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.

Comment 1 Neus Miras 2013-09-10 16:01:45 UTC
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

Comment 5 Jan Hrcek 2013-10-15 12:32:19 UTC
Verified with BPMS 6.0.0 ER4 + MSSQL 2008 R2