Support Article
Cannot Expose Base Property
SA-21483
Summary
In Pega 7.1.7 with PCS for Healthcare 7.1.3, a property shows as exposed in the database, but it is throwing guardrail warnings that indicate the column is not exposed.
Error Messages
These properties are not optimized: .CAParentID. Displaying them may result in poor performance. Consult your system administrator about optimizing properties for reporting.
Steps to Reproduce
Report on CAParentID in the implementation layer of a CPM instance.
Root Cause
The issue is related to the SQL Server case sensitivity on “CAParentID” vs. “CAPARENTID”.
Resolution
Perform the following two local-changes:
1. Alter the column name to CAParentID
2. Switch the collation as case insensitive in MS-SQL database. (SQL server determines case sensitivity by COLLATION)
Published April 8, 2016 - 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.