Question

7
Replies
318
Views
Close popover
Kensho Tsuchihashi (KenshoTsuchihashi)
PEGA
Project Delivery Leader
Pegasystems Inc.
JP
KenshoTsuchihashi Member since 2010 137 posts
PEGA
Posted: March 25, 2020
Last activity: March 22, 2021
Closed
Solved

The latest PostgreSQL JDBC Driver with Pega Platform 8.4

Hi,

 

Customer has reported that the latest PostgreSQL JDBC Driver, "postgresql-42.2.11.jar" won't work with Pega Platform. When they try to start Pega Platform, it throws an error below:

ERROR - There was a problem committing a transaction on database pegarules com.pega.pegarules.pub.database.DatabaseException: Database-General There was a problem committing a transaction on database pegarules 0 25P02 The database returned ROLLBACK, so the transaction cannot be committed. Transaction failure cause is <<ERROR: duplicate key value violates unique constraint "pr_sys_ruleset_index_pk"...

However when I replace the JDBC driver with old one, such as "postgresql-42.2.9.jar", Pega Platform starts without a problem. I am now positive that this issue is being caused by JDBC driver. Since this new driver was just released this month, I was unable to find any reference information on web, or Platform Support Guide. Anyone faces the same issue?

 

Thanks,

***Edited by Moderator: Pallavi to update SR Details***  

Pega Platform 8.4 System Administration Support Case Created
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.