Question

2
Replies
395
Views
BinodG12 Member since 2017 8 posts
Members Equity Bank Pty Ltd
Posted: 1 year ago
Last activity: 1 year 9 months ago
Closed

Violation of PRIMARY KEY constraint 'pr4_rule_PK'

We are getting the below mentioned exception for number of rules while import. Can someone help understand why we are getting these issues.

Problem #1, SQLState 23000, Error code 2627: java.sql.BatchUpdateException: Violation of PRIMARY KEY constraint 'pr4_rule_PK'. Cannot insert duplicate key in object 'rules.pr4_rule'. The duplicate key value is (RULE-HTML-SECTION DATA-ADDRESS-POSTAL CAPTUREBUSINESSADDRESS #20181025T012903.313 GMT).
at com.pega.pegarules.data.internal.access.ExceptionInformation.createExceptionDueToDBFailure(ExceptionInformation.java:293)
at com.pega.pegarules.data.internal.access.ConnectionStatementStore.executeBatchForAllStatements(ConnectionStatementStore.java:200)
at com.pega.pegarules.data.internal.access.ThreadConnectionStoreImpl.executeOutstandingBatches(ThreadConnectionStoreImpl.java:269)
at com.pega.pegarules.data.internal.access.DatabaseImpl.attemptToProcessUpdates(DatabaseImpl.java:2676)
at com.pega.pegarules.data.internal.access.DatabaseImpl.processUpdates(DatabaseImpl.java:2322)
at com.pega.pegarules.data.internal.access.Saver.save(Saver.java:651)
at com.pega.pegarules.data.internal.access.DatabaseImpl.save(DatabaseImpl.java:5108)
at com.pega.pegarules.data.internal.access.DatabaseImpl.save(DatabaseImpl.java:5094)
at com.pega.pegarules.data.internal.access.DatabaseImpl.save(DatabaseImpl.java:5086)
at com.pega.pegarules.deploy.internal.loaders.SaverLoader.failoverCommit(SaverLoader.java:989)
at com.pega.pegarules.deploy.internal.loaders.SaverLoader.issueCommit(SaverLoader.java:834)
at com.pega.pegarules.deploy.internal.loaders.SaverLoader.importContents(SaverLoader.java:263)
at com.pega.pegarules.deploy.internal.util.ImportImpl.performImport(ImportImpl.java:889)
at com.pega.pegarules.deploy.internal.util.ImportImpl.performImport(ImportImpl.java:762)
at com.pega.pegarules.deploy.internal.util.ImportImpl.importArchive(ImportImpl.java:670)
at com.pega.pegarules.deploy.internal.util.ImportImpl.importPegaArchive(ImportImpl.java:739)
at com.pega.pegarules.deploy.internal.archive.PegaArchiveAbstract.doImport(PegaArchiveAbstract.java:362)
at com.pegarules.generated.pxImportArchive_071017_w7IoE2VtDRzvUs1h_YGZlQ.pxImportArchive07_10_17(pxImportArchive_071017_w7IoE2VtDRzvUs1h_YGZlQ.java:143)
at com.pegarules.generated.pxImportArchive_071017_w7IoE2VtDRzvUs1h_YGZlQ.invoke(pxImportArchive_071017_w7IoE2VtDRzvUs1h_YGZlQ.java:85)
at com.pega.pegarules.generation.internal.library.LibraryRuntime.resolveAndinvokeFunctionViaReflection(LibraryRuntime.java:133)
at com.pega.pegarules.generation.internal.library.LibraryRuntime.invokeLibraryRuntime(LibraryRuntime.java:110)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeLibraryRuntime(Executable.java:9000)
at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflection(LibrarySupport.java:181)
at com.pegarules.generated.pega_importexport_pximportexport.pxImportArchive(pega_importexport_pximportexport.java:310)
Pega Platform
Moderation Team has archived post
Share this page LinkedIn