Built-in Viptela Groups are not Populating Correctly from Virtual Network Assurance (VNA)

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• CA Performance Management - Data Polling
• DX NetOps

Issue/Introduction

Items are missing from the built-in Viptela groups and do not appear in the VNA inventory

Cause

In the gateway.log we see many:

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (vna.subnetted_ip_address, CONSTRAINT FK_subnetip_networkinterface FOREIGN KEY (networkInterfaceId) REFERENCES inventory (id) ON DELETE NO ACTION ON UPDATE NO ACTION)

This is indicative of the following which is fixed in VNA 3.7.6 and later:

Symptom:

 Items are missing from VNA due to persistence failures while processing messages.

Resolution:

 Updated the VNA persistence error handling to prevent failures from rolling back message processing. Additionally, updated the persistence logic to correctly persist additional objects that were previously leading to persistence failures.

(3.7.6, DE435483, 20099081,20093248)

 

Environment

Release : 3.6

Component : IM Reporting / Admin / Configuration

Resolution

Restarting wildfly on the VNA server may work around this temporarily but the issue may return unless VNA is upgraded to 3.7.6 or later.

service wildfly stop
service wildfly start