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.
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 .
Thank You
For which all PRPC versions will this be applicable ?
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.
Is there any way to update the values from the DB in that case?
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
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.
Hi Prudhvi_N,
Thanks, it's working!
Does this mean after updating this section in db directly for DSS settings, to reflect the changes a restart would not be necessary ?
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
Hi,
The DSS settings are stored in PR_DATA_ADMIN table of rules schema as Data-Admin-System-Settings instance.