Subobject of investments is not loading in Adhoc View

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

There is a sub-object of the Investment object that is included in the Data Warehouse. When a field from this sub-object is attempted to be used in an Adhoc View, it throws an error. The message that is logged in the jasperserver.log is provided below.

Error message in jasperserver.log:

2024-06-13T19:30:17,704 ERROR AdhocAjaxController,http-nio-8081-exec-1575:1039 [] - ad hoc controller exception: An error occurred while performing the previous request.
java.lang.IllegalArgumentException: could not find resource for parentName='DWH_ODF_custom_sub-object', for variable with fullName='DWH_ODF_custom_sub-object.INV_KEY'

Resolution

1. Unmark the sub-object from being loaded into the DWH
2. Run a full load of the 'Load Data Warehouse' job
3. Mark the sub-object for the DWH again.