Which table does Dynamic System Settings: Indexing Setting update in the DB ?
Hi
Usually I login to the PRPC application and change the Dynamic System Settings:Indexing Setting in the browser under Records, SysAdmin
I have an idea that whatever value we update here will be updated in a column under a table in the database.
Hence, is it possible to login to the DB server and change the Dynamic System Settings:Indexing Setting value using SQLPLS itself instead of logging in to the application and doing it every time ?
***Updated by moderator: Lochan to update Categories***
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Accepted Solution
BlueRose Technologies
AU
Hi Alex,
Give below query and try at your end.
SELECT * FROM pegadata.pr_data_admin
WHERE pzInsKey like 'DATA-ADMIN-SYSTEM-SETTINGS%';
May be you are not checking in the right DB as well. please check your configurations once.
Pegasystems Inc.
IN
Hi,
Yes , on updating the DSS setting value by running a query as below, updates the value in prpc as well :
update dbo.pr_data_admin set pySetting='xxxx' where pzInsKey='DATA-ADMIN-SYSTEM-SETTINGS PEGA-RULES!abc/def';
You need not login into prpc each time to change those values .
Pegasystems Inc.
US
This actually will not update the DSS on the system. Updating the exposed columns at the database level does not change the property value in the blob.
Capgemini
FR
Hi,
I'm interesting on that table but I don't have pr_data_admin on rules schema: it's present on data schema but I can't find pySetting column:
SELECT * FROM pegadata.pr_data_admin
WHERE pzInsKey='DATA-ADMIN-SYSTEM-SETTINGS PEGA-RULES!abc/def';
Return no row.
I'm on PRPC 7.2.1
Can you help me? Thanks
Accepted Solution
BlueRose Technologies
AU
Hi Alex,
Give below query and try at your end.
SELECT * FROM pegadata.pr_data_admin
WHERE pzInsKey like 'DATA-ADMIN-SYSTEM-SETTINGS%';
May be you are not checking in the right DB as well. please check your configurations once.
Virtusa
US
Hi Jagannath,
The answer is No. Since this is a data change, DSS should automatically pick up the updated/modified value from the pr_data_admin table.
Thanks,
VK