I do not see see data in reports that have a Time Filter applied in NFA 9.3.1 and earlier.

Document ID : KB000031780
Last Modified Date : 14/02/2018
Show Technical Document Details

Problem:

I do not see see data in reports that have a Time Filter applied in NFA 9.3.1 and earlier.

 

The \Reporter\logs\WebServiceQuery*log is filled with errors like below:

archive@10.0.0.1:3307 
Unknown or incorrect time zone: 'UTC' 
set time_zone = ?TimeZone; 
(0.0000 ms) 
at NetQoS.Data.MySqlDataComponentBase.OpenConnection(MySqlConnection connection) 
at NetQoS.Data.MySqlDataComponentBase.ExecuteDataTable(MySqlConnection connection, String sql, DataTable table, DataParameter[] dataParameters) 
at NetQoS.Data.MySqlDataComponentBase.ExecuteDataTable(MySqlConnection connection, String sql, DataParameter[] dataParameters) 
at NetQoS.Data.MySqlDataComponentBase.ExecuteDataTable(String sql, DataParameter[] dataParameters) 
at NetQoS.ReporterAnalyzer.Data.Archive.ArchiveDc.TopTypesOfService(String sourceTable, DateTime utcStartTime, DateTime utcEndTime, String timeZone, List`1 whereClauseExpressions, DataDirection dataDirection, Nullable`1 resolution, UInt32 topTypesOfServiceCount) 

 

Environment:  

NFA 9.3.1 and earlier.  If you are running 9.3.2 or later please see TEC1066143.

Cause: 

This will happen if the installation or upgrade of your Harvesters does not install all values into the time_zone* tables on the 3307 instance of MySql.

 

Resolution:

1. Download the .zip file from the ftp link below to your Harvester(s) and DSA(s) if this is a three tier architecture:

ftp://ftp.ca.com/pub/netqos/product_patches/NFA/9.3.2/DE48190_time_zone._tables.zip

 

2. On the Harvesters, stop the "Netqos NQMysql" Service. 

 

3. Go to \CA\NFA\Netflow\data\mysql\ and make a backup copy of the files below:

time_zone.frm

time_zone.MYD

time_zone.MYI

time_zone_leap_second.frm

time_zone_leap_second.MYD

time_zone_leap_second.MYI

time_zone_name.frm

time_zone_name.MYD

time_zone_name.MYI

time_zone_transition.frm

time_zone_transition.MYD

time_zone_transition.MYI

time_zone_transition_type.frm

time_zone_transition_type.MYD

time_zone_transition_type.MYI

 

4. Copy and Replace in the time_zone* files from the zip file in step 1 to the \CA\NFA\Netflow\data\mysql\ directory. 

 

5. Start the "Netqos NQMysql" Service on the Harvester(s) and DSA(s).

 

6. On the console recycle all of the "CA MySql" services and check the WebServiceQuery logs again after a few minutes or after running a report with Time Filters to see if the error message stops being logged.

7. Try running the Report again with time filters and verify if you can see data.  

Additional Information:

For NFA 9.3.2 or later please see TEC1066143 as the table formats have changed from myiasm to innodb in 9.3.2.

This issue has also been resolved in NFA 9.3.6 as part of Defect DE50627.