Details
-
Fix
-
Status: Approved (View Workflow)
-
Medium
-
Resolution: Fixed
-
2.7.1
-
None
Description
Current Situation
When using the Advanced Search in the Workflows View it is not possible to search for workflow tags. This applies to use of the Oracle DBMS with JOC Cockpit.
The following error is raised:
DBInvalidDataException: JDBC exception executing SQL [select ddc1_0."PATH",ddc1_0."NAME",ddc1_0."TITLE",ddc1_0."CONTENT",ddc1_0."COMMIT_ID",ddc1_0."CREATED",1 from DEP_CONFIGURATIONS ddc1_0 left join INV_TAGGINGS dit1_0 on dit1_0."CID"=ddc1_0."INV_CID" left join INV_TAGS dit2_0 on dit2_0."ID"=dit1_0."TAG_ID" where ddc1_0."CONTROLLER_ID"=? and ddc1_0."TYPE"=? and dit2_0."NAME"=? group by ddc1_0."PATH",ddc1_0."NAME",ddc1_0."TITLE",ddc1_0."CONTENT",ddc1_0."COMMIT_ID",ddc1_0."CREATED"] [ORA-00932: inconsistent datatypes: expected - got NCLOB ] [n/a]: 932 ORA-00932: inconsistent datatypes: expected - got NCLOB
Desired Behavior
The Advanced Search by workflow tags in the Workflows view should work with the Oracle DBMS.
The SQL code for the Oracle DBMS is wrong: NCLOB data types cannot be used for grouping.
Patch
- patch for 2.7.1 is available
