ODF-0932: Widget doesn't exist

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

A user wanted to delete a widget from his custom view in MUX, but soemthing must have gone wrong.

The widget is not visible in the view any longer, but you can still see a shadow on the space the widget used to take.

If the user edits the by going to the canvas edit mode, he can see a grey box where the widget used to be. He can remove it and save the view, but it reappears again.

If the user tries to delete the view it throws an error

 

The app-ca.log file states:

ERROR 2024-06-18 00:53:14,480 [http-nio-1620-exec-425] ppm.rest (clarity:myuser:myusersession:PPM_REST_API) (c37f364e-ea41-4627-b104-25591d22f17e) 

com.ca.ppm.rest.exception.BadRequestException: ODF-0932: Widget doesn't exists.

at com.ca.platform.osf.object.rest.provider.ODFResourceProvider.handleODFException(ODFResourceProvider.java:3368)

at com.ca.platform.osf.object.rest.provider.ODFResourceProvider.deleteEntity(ODFResourceProvider.java:1423)

at com.ca.ppm.rest.resource.BaseResourceHandler.deleteResource(BaseResourceHandler.java:735)

at com.ca.ppm.rest.resource.BaseResourceHandler.deleteResource(BaseResourceHandler.java:701)

at com.ca.ppm.rest.resource.ResourceHandler.deleteResource(ResourceHandler.java:583)

at jdk.internal.reflect.GeneratedMethodAccessor2117.invoke(Unknown Source)

at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

at java.base/java.lang.reflect.Method.invoke(Method.java:568)

Cause

Something went wrong when the widget was deleted and orphan records were left on various DB tables

Resolution

1. Get the ID of the broken view, ie 5634144

2. select * from odf_canvas where ui_view_id= 5634144 (get the canvas_id)

3. select * from odf_canvas_elements where canvas_id = 5013021

4. Compare the number of widgets at DB level returned by the latest query and the ones displayed in the UI. The DB should still contain the reference of the widget that the user tried to delete

Please contact support for help with the delete statements required to remove the Orphan records.