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.

Discussion

 Jagannath Panda (JagannathP17215284)
Coforge

Coforge
IN
JagannathP17215284 Member since 2024 59 posts
Coforge
Posted: Mar 7, 2017
Last activity: Jul 4, 2017
Posted: 7 Mar 2017 13:42 EST
Last activity: 4 Jul 2017 8:46 EDT
Closed

Rules view not getting created in pr4_rule_vw
Since last 2 days all our newly created rules/ check out rules are not getting stored into data-rule-summary table. As a result we are getting rule count as 0 in ruleset form though the rule set is having rules in side it. Also no rule while clicking check out rules link in designer studio..
To see attachments, please log in.
Testing Applications
System Administration
Installation and Deployment
Data Integration

Posted: 7 years ago
Posted: 8 Mar 2017 8:14 EST
Celeste Dufresne (CelesteDufresne_GCS)
PEGA
Fellow, Technical Support, Cloud Service
Pegasystems Inc.
US

Up until 7.1.8 the pr4_rule_vw table and the pr_sys_updatescache tables were populated using database triggers.  It seems like a couple of days ago when this started someone must have disabled the database triggers.  There should be triggers on the pr4_base and all of the pr4_rule* tables.  Once the triggers are back in place you will need to issue an update statement on each table, setting pzInskey=pzInskey, to get the tables back in sync.

To see attachments, please log in.

Related content:

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