1 Console server on windows 2012 R2
1 Harvester on Linux
The problem was that the MySQL instance which is supposed to run on port 3307 was down.
Found that there is a log file named NFACustomStorageEngine.log which was owned by root user.
Changed the user for the log file to NFA user and then try to start the MySQL CSE
Successfully started NQMySQL service
Also verify whether NFA poller service is running