A Clarity portlet was working previously and is now throwing error on filter

Products

• Clarity PPM SaaS

Issue/Introduction

The error in UI is ERRORError 500 - Internal Server Error. The server could not retrieve the document due to server-configuration or other technical problems. Contact your site administrator.
The app-ca.log shows:
[http-nio-8080-exec-922] dal.NSQLClient (:npt.gridFilter) Unable to retrieve NSQL cube. NSQLException was thrown. com.niku.union.persistence.nsql.NSQLException: com.niku.union.persistence.PersistenceApplicationException

The underlying query works fine.
The portlet has been stripped and removed everything except one table and still get the error.

Environment

Clarity

Cause

The @filter@ was within the NSQL subquery.

(Select distinct full_name from srm_resources where srm_resources.user_id= inv.manager_id) mname from inv_investments inv where inv.is_active =1 and @filter@)Query

Resolution

Remove the @filter@ from the subquery and try the portlet again.