Specific tab in custom object instance throws Error 500

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

• Classic UI is under consideration
• A custom object is defined, with a sub object tied to it
• The portlet page tied to the custom object is configured to include a new tab
• This tab has a custom portlet that relies on the sub object as the Datasource
• Accessing this tab throws Error 500 - Internal Server Error in the UI
• app-ca.log has the following message:
  Caused by: com.niku.odf.griphendor.GriphendorException: com.niku.union.persistence.PersistenceException: 
SQL error code: 904
Error message: ORA-00904: "ODF_PARENT_ID"."custom_column": invalid identifier
• The custom_column is not present in the custom object, or its sub object

Environment

• Clarity 16.2.0

Cause

• Corrupted portlet

Resolution

• Create a new portlet using the same data source
• Display it in the custom tab
• It is not an issue creating a new portlet since the underlying data source remains the same.