Support Article
Realtime Data flow takes long to restart after multiple failures
SA-76285
Summary
When real time data flow run is stopped after a large number of failures, the data flow run takes a long time restart.
Error Messages
Not Applicable
Steps to Reproduce
- Create a real time data flow.
- Execute the real time data flow such that it creates a large number of data flow failures.
- Run for a sufficient time to create a large number of data flow failures.
- Stop the data flow.
- Restart the data flow.
Root Cause
A defect in Pegasystems’ code or rules.
When a stop and restart is attempted on the realtime dataflow run which has a high number of failed records, the failed entries from <pega data schema>.pr_data_decision_ddf_error table are attempted to be deleted. When the number of records in this table is high, the Delete query with a Where condition is expensive causing a performance bottleneck.
Resolution
Perform the following local-change:
Truncate the pr_data_decision_ddf_error table using the SQL statement truncate table <pega data schema>.pr_data_decision_ddf_error;.
Published March 29, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.