Custom Report Failing With Generic Server Error

Document ID : KB000122701
Last Modified Date : 06/12/2018
Show Technical Document Details
Issue:
A custom report fails with a generic server error "The server has encountered an error. Please execute the inconvenience."
 
The server has encountered an error screenshot
 
In the jasperserver.log, an error containing the following can be found:

Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "PRJLN"."CUSTOM_ATTRIBUTE_ID": invalid identifier 
Cause:
The custom attribute corresponding to the attribute ID referenced in the error message is not included in the Data Warehouse. 
Resolution:
The option to include this custom attribute in the Data Warehouse needs to be checked, followed by a Full Load instance of the Load Data Warehouse job.