Skip to main content
Contact a Moderator

Question

5
Replies
1439
Views
 Ganesh Kumar C V (Ganesh3185)
Asurion

Asurion
GB
Ganesh3185 Member since 2017 22 posts
Asurion
Posted: August 17, 2017
Last activity: September 6, 2017
Posted: 17 Aug 2017 1:13 EDT
Last activity: 6 Sep 2017 0:55 EDT
Closed

ORA-00001: unique constraint (PEGASA.PR_SYS_RULE_IMPL_PK)

Hi

I am seeing an error ORA-00001: unique constraint (PEGASA.PR_SYS_RULE_IMPL_PK) after a connect-soap call fired though a datapage. Can anyone please help to understand why this error occurs?

Version - 7.1.9

Thanks

Ganesh

Data Integration
Moderation Team has archived post, 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.
Posted: 4 years ago
Posted: 17 Aug 2017 6:46 EDT
Habeeb Baig (HabeebBaig)
PEGA
Technical Solutions Engineer
Pegasystems Inc.
IN

Hi Ganesh,


Please check If you have duplicate values in db table which you may be referring during the soap call.


Thanks,


Habeeb Baig
Posted: 4 years ago
Posted: 4 Sep 2017 5:31 EDT
Ganesh Kumar C V (Ganesh3185)
Asurion

Asurion
GB

Hi Habeeb - Thanks for the response. Above is a pega internal caching table.I think this error occurs when the data page results are attempted to cached. Its still happening sporadically.


 


Thanks


Ganesh
Posted: 4 years ago
Posted: 4 Sep 2017 8:36 EDT
Abhinav Gupta (Abhinav7)
PEGA
Principal Technical Solutions Engineer
Pegasystems Inc.
IN

Hi Ganesh,


Could you please provide complete stack of the error.


The root cause of this error is below


"pzInsKey" is a primary key column of table "pr_sys_rule_impl",During execution of this connect soap call It is trying to insert a value which is already present in this column as a result this issue is reported.


Please share the complete stack trace so that we can verify  the existence of value in DB .


 
Posted: 4 years ago
Posted: 6 Sep 2017 0:55 EDT
Ganesh Kumar C V (Ganesh3185)
Asurion

Asurion
GB

Hi - For the past two days, I could not locate this error again. For now, please consider this as closed and I will re-post it with full trace once i am able to find it again. Thanks for the help.


 


Thanks


Ganesh

Related content:

Question

ORA-00001: unique constraint PR_SYS_RULESET_INDEX_PK violated

Question Solved

Getting ORA-00001: unique constraint violated when running install.sh

Discussion

java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (ABC_RULES . PR_INDEX_REFERENCE_PK ) violated

Question

pyCommitError: ORA-00001: unique constraint (DATAPEGA.PC_ASM_COBA83_WORK_PK) violated

Question

pyCommitError: ORA-00001: unique constraint (DATAPEGA.PC_ASM_COBA83_WORK_PK) violated

Question Solved

Pega 7.3 Ignite : java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (DATA_SCHEMA_USER.PRPC_IGNITE_SERVER_ADDR_PK)

Discussion

ORA-02443: Cannot drop constraint - nonexistent constraint

Question

unique constraint PEGA_RULES.PR_ASSEMBLEDCLASSES_PK violation error

Discussion

java.sql.SQLException: ORA-02443: Cannot drop constraint - nonexistent constraint

Question Solved

MARKETING DIRECTOR - segment creation is causing unique constraint violation in table STORED_FLD_TEMPL

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice