ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Reports are not showing any data for Specific time

book

Article ID: 186969

calendar_today

Updated On:

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.

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

Environment

Network Flow Analysis 10.0.0 on Windows 2012R2

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