Question
Truviq Systems
IN
Last activity: 1 Aug 2023 5:17 EDT
Pega 8.8 Installation using Postgres 9.6
Hello All,
We are currently trying to install 8.8.0 using postgres 9.6
We are facing issue while executing install.sql file in pgadmin 4, saying that pljava is not installed.
Attaching the screenshot below which we are facing.
Copied pljava.dll and pljava.jar files to C:\Program Files\PostgreSQL\9.6\lib from pega resource kit.
Can anyone please us help on this.
Regards,
Yaswanth
Accepted Solution
Updated: 1 Aug 2023 5:17 EDT
Pegasystems Inc.
US
@Yaswanth Manda I suggest to always follow the advice given here by Kevin:
UDF (which pljava supports) is never essential for Pega core features and should never be used in production
&
simply bypass the UDF installation all together to avoid the pain of having to build the pljava on your own.
Pegasystems Inc.
US
@YaswanthM4584
Please check with the Platform Support Guide you will find that PostgreSQL 9.6 is not supported for Pega Infinity 8.8. You should use PostgreSQL versions 11-14. Also notice that openjdk 8 is deprecated, supported versions are 11 & 17
Truviq Systems
IN
Tried installing pega 8.8 through postgreSQL13 still facing the same issue which mentioned above.
We are not able to execute pljava in postgreSql
Thanks,
Yaswanth
Accepted Solution
Updated: 1 Aug 2023 5:17 EDT
Pegasystems Inc.
US
@Yaswanth Manda I suggest to always follow the advice given here by Kevin:
UDF (which pljava supports) is never essential for Pega core features and should never be used in production
&
simply bypass the UDF installation all together to avoid the pain of having to build the pljava on your own.
Updated: 12 Jul 2023 9:09 EDT
Truviq Systems
IN
@PhilipShannon We Tried Using Postgres 13
Pega 8.8 got Installed but trying to import and start prweb in tomcat, facing below error
We gave correct Context Path, Still facing the below error
FAIL - Application at context path [/prweb] could not be started |
Can anyone please help us on this.
Updated: 12 Jul 2023 9:41 EDT
Pegasystems Inc.
GB
Did you follow the installation steps as per Install Pega Platform and Configure a Postgres database for an installation ?
One possible cause of the error "Application at context path [/prweb] could not be started" could be related to the PostgreSQL JDBC driver.
If the required driver is missing or not properly configured, it might prevent the application from starting. In the case mentioned in the reference, the issue was resolved by copying the correct PostgreSQL JDBC driver to the appropriate directory and adjusting the privileges for the user in the database schema.
🌕 FAIL - Application at context path [/prweb] could not be started
Did you follow the installation steps as per Install Pega Platform and Configure a Postgres database for an installation ?
One possible cause of the error "Application at context path [/prweb] could not be started" could be related to the PostgreSQL JDBC driver.
If the required driver is missing or not properly configured, it might prevent the application from starting. In the case mentioned in the reference, the issue was resolved by copying the correct PostgreSQL JDBC driver to the appropriate directory and adjusting the privileges for the user in the database schema.
🌕 FAIL - Application at context path [/prweb] could not be started
The same error has been known to happen if there were not enough resources. Please go through the Reviewing system and installation process requirements to check available RAM. Other clients found if the infrastructure was not available to run pega instance this error occurred
Also check Tomcat configuration . Do you see errors like:: Address already in use: bind at sun.nio.ch.Net.bind0(Native Method). This would mean the connector port 8080 is already in use, try to change the port no. from 8080 to some other port number. This would not be a Pega issue.
If you still encounter issues I suggest that you log a new PSC Question with the title clearly indicating the error and version of Postgres you are using.
In the new question please provide an extract of the full install and startup logs.