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?
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***
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
About Pegasystems
Pegasystems is the leader in cloud software for customer engagement and operational excellence. If you’ve driven a car, used a credit card, called a company for service, opened an account, flown on a plane, submitted a claim, or performed countless other everyday tasks, chances are you’ve interacted with Pega. For the past 30 years, our technology – CRM, digital process automation, robotics, AI, and more – has empowered the world’s leading companies to achieve breakthrough results.
