We get this error when running the report definitions:
** An error occured on executing the query for the report definition - There was a problem getting a list: code: 0 SQLState: XX000 Message: ERROR: java.lang.ClassNotFoundException: com.pega.pegarules.data.udf.directstreamreader.DirectStreamReaderPostgreSQL DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: java.lang.ClassNotFoundException: com.pega.pegarules.data.udf.directstreamreader.DirectStreamReaderPostgreSQL | SQL Code: 0 | SQL State: XX000
You can create multiple databases in Postgre sql and point the pega instances to the appropriate database. And this will work. When we run few report definitions it may use db UDF's like reading blob content etc., so try running the UDF's directly in DB and verify what the exact issue. We had similar issue with UDF's but that was on Oracle database, the issue was with the Java version mismatch on the server and DB Java version.
Report Definitions with references to unoptimized BLOB properties generate SQL statements that call built-in functions (known by Oracle and other database vendors as "user-defined functions", or UDFs) that open and access property values directly from the BLOBs stored in the DBMS.
These functions — written, tested, and fully supported by Pegasystems — are automatically installed in the DBMS as you install PRPCor when you upgrade from an earlier version.
For upgrades, some changes to DBMS permissions may be required to allow the UDFs to work. Check the Upgrade Guide for details.
Thanks for your reply! The UDF error is only on the second Pega Installation on the server. Both installations are the same (7.3.1) versions, we just migrated the application from first installation to the second.
Could please check which instruction you followed for installing (making accessible of) the UDF's for the other installation?