Question
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
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
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 .
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
Hi Ganesh,
Please check If you have duplicate values in db table which you may be referring during the soap call.
Thanks,
Habeeb Baig