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

Document ID : KB000105644
Last Modified Date : 12/07/2018
Show Technical Document Details
Issue:
Flow Forensics report fails and the \CA\NFA\Reporter\logs\ReportServiceLog there is an error like:
Query: 
   reporter@127.0.0.1:3308
Column count doesn't match value count at row 1
   insert into flowforensicsreport_instance_6

 
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