What is the purpose of update query for Policy Store ?

Document ID : KB000013002
Last Modified Date : 14/02/2018
Show Technical Document Details
Question:

I see that Policy Server is executing update query for Policy Store at some interval.

What is the purpose of this query ?

 

< 2017-02-03 08:09:35.665 IST >LOG: statement: update smrootconfig5 SET majorversion = 0 where majorversion < 0

< 2017-02-03 08:11:06.306 IST >LOG: statement: update smrootconfig5 SET majorversion = 0 where majorversion < 0

< 2017-02-03 08:11:06.929 IST >LOG: statement: update smrootconfig5 SET majorversion = 0 where majorversion < 0

Answer:

This is SanityCheck and we execute this query connect to store at polling interval.

In case of redundancy, Policy Server send polling request for checking state of Policy Store at 250 mill seconds.

Besides, Policy Server is checking if this connection state is available or not by executing this update query at 15 seconds.