Question
ATOS Origin India PVT Ltd
IN
Last activity: 9 Aug 2018 15:06 EDT
Pega 7.4 installation with Postgress DB
Hi All,
During the installation of Pega 7.4 with Postgress 10.4 DB, while connecting to postgress 10.4 DB, getting error as "The rules schema 'PRPCRULES' was not found, or user 'Admin User' cannot access it".
Even though I can connect this DB and Schema from simple Java code.
any error in the provided installable?
JDBC Driver Class Name : org.postgresql.Driver
JDBC Driver Jar file : postgresql-42.2.4.jar
Database JDBC Url: jdbc:postgresql://localhost:5432/PEGA74DB
Database User Name: AdminUser
Databae Password: ****
Rules Schema: PRPCRULES
Data Schema: PRPCDATA
Help requested, as I need to install the server by this week itself.
Java Code:
Accepted Solution
ATOS Origin India PVT Ltd
IN
Reverted PostgressSQL 10 to 9,
You can use PostgressSQL versions as 9.3, 9.4, 9.5 or 9.6 for Pega 7.4.
The same way, use JDK 1.8. here initially I used JDK 1.10, then downgrade to JDK 1.8.
You should keep pljava.jar and pljava.dll from ResourceKit\PLJava folder to the installed PostgreSQL\9.6\lib\ folder. Then do the changes in PostgreSQL\9.6\data\postgresql.conf like follows: (location can be changed based on your installation)
pljava.classpath='C:\\Program Files\\PostgreSQL\\9.6\\lib\\pljava.jar'
pljava.vmoptions = '-Xms32M -Xmx64M -XX:ParallelGCThreads=2'
work_mem = 5MB
pljava.libjvm_location = 'C:\\Program Files\\Java\\jdk1.8.0_181\\jre\\bin\\server\\jvm.dll'
Execute vcredist-2013_x64.exe, which available on \ResourceKit\PLJava\9.6\Windows\
Restart the Postgress from the windows service.
Now create the DB, create your schema from PostgressSQL console.
Execute install.sql on the DB, which also available on the folder \ResourceKit\PLJava\9.6\Windows\.
After the successful execution of install.sql , you can perform the Pega 7.4 installation on PostgressSQL.
Hope this will help others.
Swedbank AB
SE
Hello,
Instead of localhost in the server name, try with "inbglmyxsrv5".
Also, try changing the values of the schema, user credentials etc to lower case.
Let us know if that helps to connect to the schema.
Thank you,
Pawan
Pegasystems Inc.
US
Hi,
I think PostgresSQL 10.4 version is not supported for Pega 7.4.
The latest version supported is PostgresSQL 9.6.x .
Please refer the Platform Support Guide for DB compatibility:
https://community.pega.com/system/files/media/pdf/2018-06/74_PlatformSupportGuide_June2018.pdf
ATOS Origin India PVT Ltd
IN
Hello All,
Thanks for your support, those issues got resolved. I have dropped the schema and created schemas from console. now it works.
But now getting error in different forms as follows:
Hello All,
Thanks for your support, those issues got resolved. I have dropped the schema and created schemas from console. now it works.
But now getting error in different forms as follows:
[java] Exception in thread "main" org.postgresql.util.PSQLException: ERROR: relation "sqlj.jar_repository" does not exist
[java] Position: 21
[java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
[java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
[java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
[java] at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
[java] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
[java] at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:150)
[java] at org.postgresql.jdbc.PgCallableStatement.executeWithFlags(PgCallableStatement.java:77)
[java] at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:113)
[java] at com.pega.pegarules.install.udf.loaders.PostgresUDFJarLoader.isJarLoadedPostgres(PostgresUDFJarLoader.java:161)
[java] at com.pega.pegarules.install.udf.loaders.PostgresUDFJarLoader.installJarOnPostgres(PostgresUDFJarLoader.java:122)
[java] at com.pega.pegarules.install.udf.loaders.PostgresUDFJarLoader.load(PostgresUDFJarLoader.java:89)
[java] at com.pega.pegarules.install.UDFManager$AbstractUDFExecutor.loadUDFJar(UDFManager.java:348)
[java] at com.pega.pegarules.install.UDFManager$ExecuteUDFWithOutTransaction.executeInner(UDFManager.java:293)
[java] at com.pega.pegarules.install.UDFManager$AbstractUDFExecutor.execute(UDFManager.java:357)
[java] at com.pega.pegarules.install.UDFManager.process(UDFManager.java:178)
[java] at com.pega.pegarules.install.UDFManager.main(UDFManager.java:129)
Pegasystems Inc.
IN
So glad to hear that the issue is resolved for you. Please let us know what helped you resolve. The steps might help others who face the same issue!
Regards,
Accepted Solution
ATOS Origin India PVT Ltd
IN
Reverted PostgressSQL 10 to 9,
You can use PostgressSQL versions as 9.3, 9.4, 9.5 or 9.6 for Pega 7.4.
The same way, use JDK 1.8. here initially I used JDK 1.10, then downgrade to JDK 1.8.
You should keep pljava.jar and pljava.dll from ResourceKit\PLJava folder to the installed PostgreSQL\9.6\lib\ folder. Then do the changes in PostgreSQL\9.6\data\postgresql.conf like follows: (location can be changed based on your installation)
pljava.classpath='C:\\Program Files\\PostgreSQL\\9.6\\lib\\pljava.jar'
pljava.vmoptions = '-Xms32M -Xmx64M -XX:ParallelGCThreads=2'
work_mem = 5MB
pljava.libjvm_location = 'C:\\Program Files\\Java\\jdk1.8.0_181\\jre\\bin\\server\\jvm.dll'
Execute vcredist-2013_x64.exe, which available on \ResourceKit\PLJava\9.6\Windows\
Restart the Postgress from the windows service.
Now create the DB, create your schema from PostgressSQL console.
Execute install.sql on the DB, which also available on the folder \ResourceKit\PLJava\9.6\Windows\.
After the successful execution of install.sql , you can perform the Pega 7.4 installation on PostgressSQL.
Hope this will help others.
Pegasystems Inc.
US
Thanks @SunnySureshM! You should definitely subscribe to our Installation category so that any time a post is written and tagged with that you'll get an email notification! You can set this up on our main page by clicking on Manage Subscriptions! :)