How to Clear Data

After installing and testing a Kiosk system, it may be desired to clear test check-in and check-out data from Kiosk reports and Kiosk Admin usage data from the UIP log history.

These instructions provide a manual way to clear the data from the Kiosk and UIP.

Follow the Clear Kiosk Report Data steps to clear the reporting data used for Kiosk usage reports.

Follow the Clear Work Flow History and Log Data from UIP steps to clear Kiosk Admin login and usage data history from UIP logs.

Clear Kiosk Report Data

The following should be done on the adapter hub machine where the kiosk services are installed. The adapter hub machine used by Kiosk is configured in UIP. Locate the adapter hub machine configured for the kiosk services by reviewing the list of adapter hubs in the UIP.

Warning

Before running these procedures, back up your adapter hub by taking a snapshot of the virtual machine.

1. Open a PuTTY session to the adapter hub machine
2. Delete the old report data from Kiosk's database (Mongo DB), by using the following commands (Be sure to preserve each line and replace <adapterhubservicename> with the name of the hub service):

   sudo docker exec -it $(sudo docker ps -f name=hubsvc_<adapterhubservicename>_k_mongo -q) mongosh
   use kiosk
   db.HttpActivity.drop()
   db.Signature.drop()
   db.FinancialTransaction.drop()
   db.DocumentValidationInformation.drop()
   db.PreCheckInGuest.drop()
   db.PreCheckInReservation.drop()
   db.GuestIdVerifyResult.drop()
   exit
   

Clear Work Flow History and Log Data from UIP

The following steps should be done on the UIP machine.

Warning

Before running these procedures, back up your UIP by taking a snapshot of the virtual machine.

1. Open a PuTTY session to the UIP machine

2. Stop the logging services,

   sudo docker service update --replicas 0 nap-apps_log_service
   sudo docker service update --replicas 0 nap-apps_fluentd
   

3. Delete the log data from UIP's database (Mongo DB)

   sudo docker exec -it $(sudo docker ps -f name=nap-dbs_mymongo -q) mongosh
   use logging
   db.log.drop()
   exit
   

4. Restart the logging services.

   sudo docker service update --replicas 1 nap-apps_log_service
   sudo docker service update --replicas 1 nap-apps_fluentd
   

5. Use sudo watch docker service ls to confirm that all UIP services are up before moving to the next step.

6. Clear the UIP wfhistory data stored in Influx.

   sudo docker exec -it $(sudo docker ps -f name=nap-wfe_myinfluxdb -q) influx
   use workflow
   delete from wfexecution
   delete from incomingevents
   exit