Report Definition asking to optimize .pzInsKey
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:
| 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. Position: 30023 |
Has anyone had the same problem? Greetings, Manuel
***Edited by Moderator Marije to change type from General to Product***
Infosys Limited
IN
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?