This document provides a step-by-step guide to debug missing data issues in the GUI of the Analytics cluster.


Step 1: Verify Active LEF Connection on VOS Device

Objective: Confirm that the VOS device has an active LEF connection with the correct node.

Procedure:

  • Log in to the Analytics Admin GUI.

  • Navigate to: Admin → System Status → Log Collector Exporter.

  • On the Log Collector Exporter Status page:

    • Select ALL from the dropdown.

    • Go to the Local Collector Connections tab.

    • Verify that the device is listed and connected correctly.

Step 2: Check for Raw Logs for the Missing Date

Objective: Ensure raw logs were received for the date on which data is missing.

Procedure:

  • SSH into the node where LEF is established for the device.

  • Run the following commands (replace with the correct site name and tenant) to search for the missing date (YYYYMMDD):

    # sudo su
# cd /var/tmp/archive/tenant-Creta/VSN0-BR03/
# ls 20250402*

  • Confirm that raw log files for the expected date are present.

Step 3: Verify Data in Database

Objective: Check whether data was ingested into the database.

Procedure:

Identify the Table:

  • Enable debug logging in the Analytics GUI.

  • Run:

    # tail -f /var/log/versa/tomcat/catalina.log

  • Reload the relevant graph to identify which table is being queried.

Query Cassandra:

  • Access the Analytics CLI:

    # cqlsh -u cassandra -p cassandra

  • Run a sample query to confirm table accessibility:

    SELECT * FROM van_analytics.sdwan_link_availability LIMIT 1;

  • Query for the specific missing dateblock (in YYYYMMDDHH format).
    Note: Reference time is in UTC.

    SELECT * FROM van_analytics.sdwan_link_availability WHERE tenantname='Creta' AND sitename='BR03' AND dateblock IN (2025040300) ALLOW FILTERING;

Interpret Results:

  • If no data is found, proceed to Step 4 to check for ETL errors.

Step 4: Check ETL Errors in Analytics GUI

Objective: Detect any ETL-related issues during data processing.

Procedure:

  • Go to the Analytics Admin GUI.

  • Navigate to: Admin → System Status → Status → ETL Monitoring.

  • Review the ETL Analytics Error Logs for any warnings or errors related to the missing date.