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

PEGA.PR_SYS_DECCHG archival/cleaning process

SA-19867

Summary



How does one delete the rules which are not being used frequently in the application from PRPC related tables?

Resolution



Use purgeTableContainingClass API in PegaDatabase to delete old entries from a class. Below is the java doc for that method

/**

* Wrapper for the SQLGenerator purgeTableContainingClass function. Deletes all rows from the given table who are older than the specified number of days,

* by filtering on the specified column.

*

* @param aClassName The table to purge

* @param aColumn The column to filter date by

* @param aDays Delete all rows older than this many days

* @throws DatabaseException

*/

public void purgeTableContainingClass(String aClassName,String aColumn, String aDays) throws DatabaseException;



Create an activity that calls this API inside a Java step and run this activity to purge the entries. Also create a recurring agent and schedule it to run this activity periodically.

 

 

Suggest Edit

Published February 26, 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