Support Article
InvalidReferenceException occurs though pc_work_fed col in FCMR
SA-102454
Summary
InvalidReferenceException is generated frequently in the Pega logs though the database schema has the DATA.pc_work_fed column in the Federated Case Management Repository (FCMR) database. This occurs when a custom report of Work-Federated is executed.
Error Messages
An error occurred during resolving the report definition - InvalidReferenceException .pxCreateOpName Unexposed properties cannot be selected for classes mapped to external tables
Steps to Reproduce
Create a report in the Work-Federated class that has references to the .pxCreateOpName property.
Root Cause
The user attempted to resave the Data-Admin-Database-Table (DADT) rule. As the report definition displays results and the exception only occurs while executing the report definition, this is a false exception. The code that determines if the property is exposed, is incorrect. This is because a call to the pr_read_from_stream out-of-the-box User Defined Function (UDF) must occur if the properties are unexposed, and which did not happen.
Resolution
Perform the following local-change:
Disable the 'Report on descendant classes' option.
Published June 12, 2020 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.