Portlet using 'Action Item System Data Provider' errors out

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Grid portlet using System Provider - "Action Item System Data Provider" errors out with the following. 'System error. Contact system administrator'

Steps To Reproduce:

1. Create a Grid Portlet using System Provider - "Action Item System Data Provider"
2. In Clarity Classic 'Overview: General' page, Configure 'General' tab and add the portlet created in step one to this page.
3. Return back to 'Overview: General' page.

Expected:
Portlet to display page without error

Actual:
Portlet displays Error 'System error. Contact system administrator'

Environment

Clarity: 16.2.1, 16.2.2, 16.2.3

Cause

DE152843

Resolution

Clarity 16.3.0

Additional Information

In Oracle - Portlet throws "System error. Contact system administrator" whereas in PostgreSQL portlet throws "Sorting by the column specified is not allowed."