Support Article
Duplicate key value violates constraint pr_sys_ruleset_index_pk
SA-106313
Summary
When installing Pega Platform 8.4 on PostgreSQL, Constraint errors occur on the pr_sys_ruleset_index_pk.
Error Messages
[java] Caused by: org.postgresql.util.PSQLException: 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"
[java] Detail: Key (pzinskey)=(SYSTEM-RULESET-INDEX C5F8D11E1C6712B822BE592273FD678F!PEGA-PROCESSCOMMANDER) already exists.>>
[java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2209)
[java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:331)
[java] at org.postgresql.jdbc.PgConnection.executeTransactionCommand(PgConnection.java:833)
[java] at org.postgresql.jdbc.PgConnection.commit(PgConnection.java:855)
[java] at com.zaxxer.hikari.pool.ProxyConnection.commit(ProxyConnection.java:352)
[java] at com.zaxxer.hikari.pool.HikariProxyConnection.commit(HikariProxyConnection.java)
[java] at com.pega.pegarules.data.internal.store.DatabaseConnectionImpl.commit(DatabaseConnectionImpl.java:872)
[java] at com.pega.pegarules.data.internal.store.ManagedTransaction.commit(ManagedTransaction.java:393)
[java] ... 38 more
Steps to Reproduce
Execute the Install script.
Root Cause
A defect or configuration issue in the operating environment.
The PostgreSQL JDBC 42.2.11 driver has a change in behavior which results in the Constraint error with the Installation script.
Resolution
Make the following change to the operating environment:
Use the PostgreSQL JDBC 42.2.6 driver.
Published April 14, 2020 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.