We have 15k decision data or offers in production and there are ad-hoc requests to turn on one or two effective immediately.
What is the best way to achieve this without a server restart?
I understand for un-versioned decision data - we can run aquery on pr_dm_propositions to make the offer inactive. But, I am more concerned about versioned decision data.
@GayathriG1080 we don’t recommend updating the DB directly. If you wish to achieve this, each proposition has an active flag, this can be changed as appropriate. You should not need to do this directly in production, instead you should make use of change management capability to do this (Ops Manager or if prior to 8.5 Revision management).
In the absence of this you can deploy a change directly to production to switch off but this is likely more cumbersome than using our change management capability.
Add to what Alex mentioned, the versioned propositions are not backed up by DB table and they are managed with in a rule named “” Decision data"
Yes, inactivating the active flag is the best approach, however, the nodes do not sync up when we do that and it requires a rolling restart of the servers. We are trying to avoid multiple rolling restart.
Unfortunately, We do not have revision management set up. (7.3.1) Once we upgrade to 8.5 - will explore Ops Manager
@GayathriG1080 Proposition Cache will be updated when we update propositions. You do not require rolling restart for this. Could you please check if PropositionCache is disabled from DIsablePropCache DSS in your case?
Thanks & Regards,
Matta
@MANNM1 Sure, Will check Thanks