Unique constraint violated during BIX Extract
When running multiple extracts using agents and pxExtractDataWithArgs at the same time, a unique constraint violation error is produced in the logs. Despite this error, the extract still seems to complete successfully.
2016-02-19 13:07:02,437 [.PegaWorkManager : 8] [ ] [Application:01.01.01] ( internal.access.ExtractImpl) ERROR - Error while getting the sequenceNumberORA-00001: unique constraint (PegaDataSchema.PR_LOG_PK) violated
Steps to Reproduce
Create agents that call pxExtractDataWithArgs at the same time, each running its own extract rule.
This occurs because the extracts are running at the same time and an entry is added to the pr_log table when each extract starts. The pzInsKey for two extracts that run at the same time is identical, thus leading to this error.
To avoid this, stagger the start times of the extracts.
0% found this useful