Question
Virtusa UK Ltd
GB
Last activity: 6 Sep 2017 0:55 EDT
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
Virtusa IT Consulting
AE
Hi Ganesh,
Please check If you have duplicate values in db table which you may be referring during the soap call.
Thanks,
Habeeb Baig
Virtusa UK Ltd
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
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 .
Virtusa UK Ltd
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