Question

10
Replies
2489
Views
SunnySureshM Member since 2017 3 posts
ATOS Origin India PVT Ltd
Posted: July 24, 2018
Last activity: August 9, 2018
Closed
Solved

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:

connection = DriverManager.getConnection("jdbc:postgresql://inbglmyxsrv5:5432/PEGA74DB", "AdminUser", "adminuser");
DatabaseMetaData dbMeta = connection.getMetaData();
ResultSet rs = dbMeta.getTables(null, "PRPCRULES", null, null);
while (rs.next()) {
System.out.println(rs.getString(3));
}
rs = dbMeta.getTables(null, "PRPCDATA", null, null);
while (rs.next()) {
System.out.println(rs.getString(3));
}
***Edited by Moderator Marissa to update platform capability tags***
Pega Platform Low-Code App Development Installation and Deployment
Moderation Team has archived post
Share this page LinkedIn