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

Issue Running Extracts at same time via pxExtractDataWithArgs

SA-20515

Summary



Agents are scheduled to run different Extracts using the pxExtractDataWithArgs activity at the same time. When this is done, not all of the extract manifest files are produced as expected. There are also unique constraint errors seen in the logs.

Error Messages



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 (YourDataSchema.PR_LOG_PK) violated

Steps to Reproduce



Create multiple Extract rules.
Schedule agents to run these extracts at the same time using the pxExtractDataWithArgs activity.

Root Cause



A defect in Pegasystems’ code or rules causes this issue. The use of static variables in the code resulted in the unexpected behavior.

Resolution



Apply Hfix-25845, but note Hfix-25845 does not address the unique constraint error which 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.
Suggest Edit

Published March 16, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

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