Question

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***

Comments

Keep up to date on this post and subscribe to comments

August 12, 2019 - 10:30pm

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