Is it possible to run multiple Pega instances on one Postgresql Database instance with separate Databases?
Currently we have a Linux server with a Postgresql database on it. We have two Pega installations on this server with each installation having it's own database.
After migration of our application from the first installation to the second installation we faced some UDF (user defined functions) related issues when running report definitions.
Question is: is this server setup possible with Pega?
p.s. UDF functions seems to be installed correctly on both databases.
Instellars
IN
Hi,
Yeah, this shouldn't be any problem. I have a single Postgres database instance with around 5-6 different databases hosting different Pega platforms.
Can you post what kind of errors you are observing?
Taxonic
NL
Thanks for the reply.
We get this error when running the report definitions:
Thanks for the reply.
We get this error when running the report definitions:
Coforge DPA
IN
Hi ,
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.
Singtel
IN
Hello,
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 PRPC or 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.
PEG
GB
My personal experience ( I would say last year on 7.3.1) is that I was unable to follow the installation guide for installing on UDF. It didn't work. A colleague of mine who also tried also failed.
We finally found somewhere a post with different set of instruction and it worked for both of us (I can't find it now)
The error you get definitely say UDF is not installed properly. Pega just doesn't finf d it.
Do you get the UDF error from both installation?
My first idea would be that UDF is only accessible for 1 of the installation and not the other.
Taxonic
NL
Hi Merlx,
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?
Thank you very much.
PEG
GB
Can you verify whether the UDFs were installed on both schemas (I believe this is needed for 7.3.1)
Was your newer user(s) granted the database privilege execute on function as well?
Taxonic
NL
UDF's are installed on both schema's. We also followed the instruction of pega and reinstalled the UDF's.
The DB users for both Pega installations have the same privileges and can read and execute functions.
Taxonic
NL
When we run the query in the database we get the following error:
ERROR: java.lang.ClassNotFoundException: com.pega.pegarules.data.udf.directstreamreader.DirectStreamReaderPostgreSQL SQL state: XX000