Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Jagannath Panda (JagannathP17215284)
Coforge

Coforge
IN
JagannathP17215284 Member since 2024 59 posts
Coforge
Posted: Jul 4, 2017
Last activity: Jul 5, 2017
Posted: 4 Jul 2017 8:48 EDT
Last activity: 5 Jul 2017 9:53 EDT
Closed

All the DB triggers are missing from rules schema in Dev/QA env

All the DB triggers are missing from rules schema in Dev/QA env which is resulting no new instance in Data-Rule-Summary(pr4_rule_vw).
How to build triggers back? This application had built 1 year back by some team and now its assigned to us for enhancement and the old team is also not aware how the triggers got missed from dev/qa env.
PRPC v7.1.5
DB-Postgres

To see attachments, please log in.
Data Integration

Posted: 7 years ago
Posted: 5 Jul 2017 7:45 EDT
Celeste Dufresne (CelesteDufresne_GCS)
PEGA
Fellow, Technical Support, Cloud Service
Pegasystems Inc.
US

Have the triggers been removed or just disabled?  If you need to regenerate them then you can run the generateddl script that comes with the media.  It will generate the ddl of what is missing.  After applying the DDL you will need to run some update commands to get the pr4_rule_vw table repopulated.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center 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