Flow Forensics Report fails with "Column count doesn't match value count at row 1" in ReportService*.log

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

Flow Forensics report fails and the \CA\NFA\Reporter\logs\ReportServiceLog there is an error like:

Query: 
   [email protected]:3308
Column count doesn't match value count at row 1
   insert into flowforensicsreport_instance_6

 

Environment

Release:
Component: NQRPTA

Cause

Non U.S. regional settings.

Resolution

Verify the Regional Settings are correct by following the steps in the KB article below:
https://comm.support.ca.com/kb/what-are-the-regional-settings-required-for-ada-nfa-ucm-npc-and-netvoyant/kb000021400