MUX - Cannot Remove Widgets from Canvas

Products

• Clarity PPM On Premise

Issue/Introduction

Users can add widgets to a canvas on projects and hierarchies, but users cannot remove the added widgets and receive the error message "com.niku.union.sevice.ServiceException: Service Exception". 

STEPS TO REPRODUCE:
1. Login to MUX.
2. Go to Administration->Blueprint.
3. Open and Edit one of the project blueprints.
4. Click on New Canvas to add it to the blueprint and publish it.
5. Go to Projects and ensure to change to the updated blueprint
6. Click on one of those projects and go to the Canvas module added in step 4.
7. Click on Configure and add widgets.
8. Attempt to remove one or more of those widgets and users are getting an error message "com.niku.union.sevice.ServiceException: Service Exception".

Expected Results: It is supposed to allow user to remove widget.

Actual Results: it is not allowing user to remove widget.

Environment

16.1.3 on Oracle 19c.

Cause

Caused by: Error : 1722, Position : 91, Sql = select count(id) current_count from odf_canvas_elements where source_type = 'widget' and source_ref_id = :1    and id != :2 , OriginalSql = select count(id) current_count from odf_canvas_elements where source_type = 'widget' and source_ref_id = ?   and id != ?, Error Msg = ORA-01722: invalid number

Resolution

DE78961, Fixed in 16.2.1