Question
1
Replies
531
Views
Posted: August 8, 2019
Last activity: June 5, 2020
Solved
Issues reading from the BLOB when running a report definition
I am currently working in an environment that is being run on the Pega Cloud.
I am unable to run a report definition on an unexposed column.
At the moment, there is no intention of exposing the said columns.
What would the necessary steps be for resolving this issue?
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_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: 8 DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: function pegadata.pr_read_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: 8 | SQL Code: 0 | SQL State: 42883
***Edited by Moderator: Lochan to update platform capability tags***
Hi
This is a valid scenario. On Cloud it may not allow you to run a report on unexposed columns as UDF functions may not be present.
You can raise an SR with Pega to get a confirmation.
If you need a report, either expose the columns on the same table or create an Index table or them. That is the best practice.
Regards
Bhavya