Enrolling new device issue - update from 3.7.2 or older to version 3.8.4

Issue 1:

Cause:

Due to failing to select device models from Cassandra, enrolling new devices may fail.

How to check:

BASH

# Connect to Cassandra on a persistence node
cqlsh

# Use the main VeridiumID keyspace;
use KEYSPACE_NAME;
# The VeridiumID keyspace name can be found in the Admin Dashboard -> Settings -> Advanced -> config.json -> cassandra.keyspace

# Run the following query in the main VeridiumID keyspace
select * from device_models_brands WHERE model="EXAMPLE_MODEL";

If the above query fails, it means that the indexes associated with the ‘device_models_brands’ table are corrupted.

Resolution:

In order to solve the issue, the indexes must be recreated.

BASH

# Connect to Cassandra on a persistence node
cqlsh

# Use the main VeridiumID keyspace;
use KEYSPACE_NAME;
# The VeridiumID keyspace name can be found in the Admin Dashboard -> Settings -> Advanced -> config.json -> cassandra.keyspace

# Run the following queries in order to recreate the indexes
drop index device_models_brands_brand;
drop index device_models_brands_model;
drop index device_models_brands_name;

CREATE INDEX device_models_brands_brand ON veridium.device_models_brands (brand);
CREATE INDEX device_models_brands_model ON veridium.device_models_brands (model);
CREATE INDEX device_models_brands_name ON veridium.device_models_brands (name);

Issue 2:

Cause:

Due to failing to select enrollment code from Cassandra, enrolling new devices may fail for some devices. This is normally happens from update from 3.7.2 or older to 3.8.4, if

How to check: - Error appears in bops.log → Could not retrieve active enrollment codes.

Resolution:

In order to solve the issue, a temporary table should be cleaned.

BASH

# Connect to Cassandra on a persistence node
cqlsh

# Use the main VeridiumID keyspace;
use KEYSPACE_NAME;
# The VeridiumID keyspace name can be found in the Admin Dashboard -> Settings -> Advanced -> config.json -> cassandra.keyspace

# Run the following queries in order to recreate the indexes
truncate table enrollment_code