When customer says they are able to see the logs in /var/tmp/archive directory but the same is not visible on the cassandra DB.

We can replicate this behaviour on our lab using customer analytics data.

Pre-requisite:

Atleast one analytic node up and running in lab

Make sure you have same software release as in customer setup 

Below procedure is tested on 22.1.2 software release

Step 1:

First get the tenant and site from the customer analytics so as to have the same tenant and sites on our lab

sudo su

mkdir /tmp/export

chmod 777 /tmp/export

Execute the below commands from the analytics shell:

cqlsh -e "COPY van_analytics.sdwan_sites_info TO '/tmp/export/sdwan_sites_info.csv' WITH HEADER = true ;" -u cassandra -p cassandra

cqlsh -e "COPY van_analytics.tenants_info TO '/tmp/export/tenants_info.csv' WITH HEADER = true;" -u cassandra -p cassandra

It will save two files under /tmp/export path

Step 2:

Now we need to take the archive files from the /var/tmp/archive/ path. 

Either we can take the complete archive files from ls -lrth /var/tmp/archive or 

archive files from specific appliance ls -lrth /var/tmp/archive/tenant-Tenant-X/VSN0-Appliance-X or 

archive files from a specific date from a specific appliance ls -lrth /var/tmp/archive/tenant-Tenant-X/VSN0-Appliance-X | grep 20240424

Step 3:

Copy the files to one of the lab Analytic nodes where you are going to try the lab replication

For e.g

Copy the csv files in step 1 to the path /tmp/export and run the below command

sudo python3 /opt/versa/scripts/van-scripts/vandb-import.py -i /tmp/import/ -d all -u cassandra -p cassandra

This will import the tenant and site details in the customer setup onto your lab setup

You can login to the UI of the analytics and verify if you are able to see the tenants and appliances on the UI drop downs. Although you wont yet see the consumption data

Step 4:

Now transfer the archive files to /var/tmp/archive directory.

If you are going to transfer only files of a specific appliance, then create a same tenant and appliance directory before copying the .tar.gz archive files

once the archive files are placed, then run the restore script

sudo /opt/versa/scripts/van-scripts/log-restore.py --src /var/tmp/archive/ --dst /var/tmp/log

This will start ingesting the archive data into the DB

Now you will see interesting data being shown on the lab as same as seen in customer setup

Note:

You can do the import and restore on one of the analytic nodes if you have two node cluster as the data will get sync with other node

If you want to setup two node cluster for this lab replication, you can just goto any of the director which is in the same network as the newly created two lab analytics and execute the cluster installation script by feeding in the IPs in clustersetup.conf and execute it. This will bring up a two node analytics cluster