security.locks URL errors out due to a blueprint record

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

When accessing the security.locks URL we get an error.

The app-ca-log file shows the following exception:

ERROR 2023-01-26 11:41:25,354 [http-nio-80-exec-2] web.WebActionController (clarity:user:17783018__2F4375FB-2681-4769-8663-25D52AB26F7F:security.locks) 
com.niku.union.web.WebException: Service call failed for portlet: security.locks
    at com.niku.union.web.PortletController.processAuthorizedPortlet(PortletController.java:944)

...

Caused by: com.niku.union.web.WebException: WebServiceAdapter::processRequest -> failed to process service request
    at com.niku.union.web.WebServiceAdapter.processRequest(WebServiceAdapter.java:223)
    at com.niku.union.web.PortletController.processServiceRequest(PortletController.java:1431)
    at com.niku.union.web.PortletController.processAuthorizedPortlet(PortletController.java:914)
    ... 56 more
Caused by: com.niku.union.service.ServiceException: Service Exception
    at com.niku.odf.service.ODFActionService.processRequest(ODFActionService.java:166)
    at com.niku.union.service.binding.ServiceControlBindingJava.processRequest(ServiceControlBindingJava.java:58)
    at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:914)
    at com.niku.union.service.ServiceControlImpl.processRequest(ServiceControlImpl.java:212)
    at com.niku.union.web.WebServiceAdapter.processRequest(WebServiceAdapter.java:219)
    ... 58 more
Caused by: com.niku.union.persistence.PersistenceException: 
SQL error code: 207
Error message: Invalid column name 'name'.
Executed:
 select b.id, b.name + ' : ' + b.code unique_name
             from odf_blueprints b
             where b.id in (5006006) 

When looking at the DB side, the failing query returns data:

 select b.id, b.name + ' : ' + b.code unique_name
             from odf_blueprints b
             where b.id in (5006006) 

If we look at the prlock table, there is a lock on a blueprint

Resolution

Remove the entry from the prlock table.

Delete from prlock where prtablename = 'odf_blueprints'