Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

BIX extract to DB schema results in PR_LOG_PK Violation

SA-40196

Summary



PR_LOG_PK Violation error occurs on Business Intelligence Exchange (BIX) extract to a database schema.



Error Messages



ORA-00001: unique constraint (PEGA7_DATA.PR_LOG_PK) violated



Steps to Reproduce

  1. Run the extract rule manually
  2. View the PegaBix.log file



Root Cause



Primary key violation exception occurs because BIX writes one entry for each descendant class in the pr_log table when -c cmd line arg is selected.



Resolution

Apply HFix-34993

Tags:

Pega Business Intelligence Exchange Pega Business Intelligence Exchange 7.2.2 Data Integration

Published September 1, 2017 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Visit the Collaboration Center

Did you find this content helpful?

Yes
No

Want to help us improve this content?
Suggest an edit

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

Pega Community 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
Contact us