Question

Pegasystems Inc.
JP
Last activity: 22 Mar 2021 19:25 EDT
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***