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

Database crashing when simulation starts execution

SA-19106

Summary



User has observed that database is crashing when the simulation is running. User has witnessed it multiple times in a week.


Error Messages



Not Applicable.


Steps to Reproduce



Not Applicable.


Root Cause



Running simulation is causing too much load on database resources for example Memory and CPU utilization is high. Redo logs are getting full too quickly. 

It is suspected that during Simulation execution, it fetches all columns from the customer table, and for the batch output, the "Insert" statement also contains all columns corresponding to SR properties, even though many of the columns are not required and populated. This is causing DB REDO logs to get full too quickly.


Resolution



Simulation and Interaction rules are deprecated since Pega 7.1.7.

User is recommended to use Data Flows and Data Sets to achieve the same.
 
 
Suggest Edit

Published January 30, 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