Question
UMKC
US
Last activity: 27 May 2024 1:13 EDT
Report Definition Error for Unoptimized property
I'm used an unoptimized property in a report definition, it did not throw any error when I saved the rule.
When I run the report definition rule, I'm getting this error:
"An error occured on executing the query for the report definition - There was a problem getting a list: code: 0 SQLState: 42883 Message: ERROR: function pegadata.pr_read_int_from_stream(unknown, character varying, bytea) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 160 DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: function pegadata.pr_read_int_from_stream(unknown, character varying, bytea) does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 160 | SQL Code: 0 | SQL State: 42883"
while I understand that its not recommended to use unoptimized properties in report definitions, Can someone help me understand what this error is trying to say
CollabPartnerz
IN
To remove above Error, you just have to optimize the property and run the report again.
and as for those errors they are from UDF's (blob readers) to understand more about Optimizing and reports I suggest follow up below link.
Understanding Pega Blob and UDF | Support Center
Eclatprime Digital Private Limited
IN
@KevinR17115962 To solve this issue , a user need to do the optimization. What is optimization here let me explain. What is Optimization ???
-
You can improve reporting and search performance in your Pega application by optimizing (exposing) Single Value properties as distinct columns .By default, your Pega database stores property values in a Storage Stream column called pzPvStream, using a Binary Large Object (BLOB) database type. You cannot retrieve the data for these properties without first decompressing the column data, which can significantly slow down data retrieval and processing in other operations.
-
How to do Optimizations ??
- Property Optimization Tool — Accessed from the Designer Studio, exposes columns and populates them with values. It is available on development systems and is appropriate for ad-hoc changes when you only have a few
Single Value, top-level properties to expose. For aggregate and embedded property values, this feature provides an alternative to the Declarative Index wizard.
