Realtime Data flow takes long to restart after multiple failures
When real time data flow run is stopped after a large number of failures, the data flow run takes a long time restart.
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.
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.
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;.
0% found this useful