Question

10
Replies
2537
Views
Close popover
Sunny Suresh M (SunnySureshM)
ATOS Origin India PVT Ltd
Project Manager
ATOS Origin India PVT Ltd
IN
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 System Administration Installation and Deployment
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.