Hello to everyone, I have a report on a Work class, with sub reports in Work-A and Work-B so I use .pzInsKey to join in Data Access, but pega gives me this warning:
"These properties are not optimized, and using them to join a sub report will result in very poor performance: .pzInsKey. Consult your system administrator about optimizing properties for reporting."
I understand that the property pzInsKey doesn't need to optimize but when I run the report y returns me this fail:
Step Status Info
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.
Has anyone had the same problem?
***Edited by Moderator Marije to change type from General to Product***
Could you please let me know what is the Pega version that you are using? It seems the data from the blob is fetched using the User Defined Function (pr_read_from_stream). This function should be present at the DB level. Could you please check if this function is there at the DB level?