In a project of 8.5.1 I have defined a number of data types and configured their local data sources as tables in the PegaDATA schema. I noted that all the properties I included in configuring the data source are exposed as columns in the underlying tables. However, all the access to the records of the data type, either via data page or activities, are still reading the pzpvstream despite the fact that all properties are already exposed columns. While this is functioning, it is causing poor performance. Is there a way to suppress the reading of pzpvstream in the sql generated for data type without the need of deleting the pzpvstream column and restarting the whole system?
***Edited by Moderator: Pooja Gadige to add platform capability tag***
Try creating a RD and fetch any of the exposed columns (for the same data class). Check from the tracer if the generated SQL query from the RD is still fetching BLOB . Sometime re-saving the Data-Admin-DB-Table instance of the corresponding class also fixes similar problem .