How to full sync the Ranger RMS database

Performing a full-sync in Ranger RMS truncates all the existing data from RMS tables in the Ranger database. The sync process initiates a fresh synchronization from the Hive Metastore (HMS). All available tables and database metadata download from HMS and persist into the Ranger database.

Have a (7.2.18) cluster with Ranger, Ranger RAZ, and Ranger RMS service up and running.

In Cloudera Manager > Ranger_RMS > Actions, click Stop.
Ensure that all Ranger RMS roles are in a stopped state before proceeding with the next steps.
In Ranger_RMS > Actions, click Ranger RMS Database Full Sync.
Confirm that the command completed successfully, as shown in the following example:

Figure 1. Confirming successful Ranger RMS database full sync

note
You can also confirm the text - ‘[I] Truncate operation executed successfully on Ranger RMS tables’ from the stderr log of the command from Cloudera Manager UI.
In Cloudera Manager > Ranger_RMS, click Start.