Support Article
Database triggers removed during upgrade to Pega 7.1.8
Summary
Pega 7.1.7 to 7.1.8 update seems to have completed successfully except that the database triggers are not restored at the end of the update.
Error Messages
Not Applicable
Steps to Reproduce
Run update script to update to Pega 7.1.8.
Root Cause
This behavior is as per design.
Resolution
Starting from Pega 7.1.8, there are no longer any database triggers used by Pega. The updating of the pr4_rule_vw and pr_sys_updatescache tables are now handled by the engine itself.
The process for performing updates to the pr_sys_updatescache and pr4_rule_vw tables has been restructured to increase system processing efficiency. In previous releases, database (DB) triggers were used to perform updates to these tables. These updates are now performed directly within the Pega 7 engine and the DB triggers are eliminated.
Published August 19, 2015 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.