Reports are not showing any data for Specific time

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

No data from 5.30 AM to some amount of time on daily basis. Able to see data only after restarting NFA services.
So need to restart Services daily.

Environment

Network Flow Analysis 10.0.0 on Windows 2012R2

Cause

Poller_wrapper log showing below error 

INFO   | jvm 1    | 2019/09/08 23:00:08 | 11:00:08 PM - [SEVERE  ] - Error refreshing in memory router and interface cache from the database

INFO   | jvm 1    | 2019/09/08 23:00:08 | com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'ExpectedSequence' cannot be null

Resolution

For Error " Column 'ExpectedSequence' cannot be null" Defect DE431573 has been raised and fix  will be available in NFA 10.0.4 release.Due to the error "ExpectedSequence' cannot be null" services are also getting stopped, this will also get fixed once we apply 10.0.4.

Additional Information

Refer DE431573