Question

3
Replies
1359
Views
 Saurabh Kumar Singh (SaurabhKumarS)
Amazon

Amazon
IN
SaurabhKumarS Member since 2014 5 posts
Amazon
Posted: December 12, 2017
Last activity: August 26, 2020
Posted: 12 Dec 2017 8:45 EST
Last activity: 26 Aug 2020 8:41 EDT
Closed
Solved

Updating pr_operators table in from DB does not update Operator RULE in PEGA

I am trying to update email address for all operators from DB (Postgres) - using pgAdmin GUI. The pr_operators table shows updated values when querying in DB.

However, the same operator RULE in PEGA shows old value. If i update from PEGA, this works. But it is tedious to do it for suppose 1 lakh operators.

***Updated by moderator: Lochan to update Categories***

Data Integration System Administration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 3 years ago
Posted: 12 Dec 2017 9:09 EST
Sekar Anbu (SekarAnbu)
TCS

TCS
SE

Updating the exposed column will not help unless it is fully exposed table. As we have BLOB column for operators, you need to perform Obj-Save in order to update operators. 
Posted: 3 years ago
Posted: 12 Dec 2017 9:32 EST
Umamaheshwar Reddy Midthuru (Mahesh Midthuru)
PEGA
Sr. Software Solutions Engineer
Pegasystems Inc.
US

Adding to the above information, are you trying to update with the same email id for all the operators from PgAdmin GUI? If so you can write an activity to fetch the operators and update the mail id then perform Obj-Save.