CAPC / NFA Query issue

Document ID : KB000117206
Last Modified Date : 09/10/2018
Show Technical Document Details
Issue:
User-added image
Errors on the DMService.log:

WARN  | RIB-Query-24             | 2018-10-01 17:38:54,532 | com.ca.im.rib.engine.sources.AuditingRIBSource
      | Null results returned from RIB Source: null
ERROR | RIB-Query-24             | 2018-10-01 17:38:54,537 | com.ca.im.rib.engine.query.tgt.TargetedRIBQueryInvoker
      | RIB query failure!
          Source: {Network Flow Analysis@server@ http://server:8681/NFARS/ribsource/rib/soap?wsdl}
          Query ID: {0ddc8295-73ff-4720-b998-771964a6f062}
          Query: {SELECT .Host.Host, .Host.Name, .Host.BytesOut, .LocalInterfaceID FROM CA.ReporterAnalyzer.RAWSParameters WHERE .InterfaceID = '7182' AND .StartTime = 1538411880 AND .EndTime = 1538415480 AND .Measurement = 'Bytes' AND .LimitCount = 50 AND .Direction = 'Out' AND .ProtocolID = 24 HAVING (.RAWebCall = 'HostSummary')}
javax.xml.ws.soap.SOAPFaultException:
Error occurred while running a RIB query on SQL RIB source.
  Possible reason: null
  Query:
{
SELECT .Host.Host, .Host.Name, .Host.BytesOut, .LocalInterfaceID FROM CA.ReporterAnalyzer.RAWSParameters WHERE .InterfaceID = '7182' AND .StartTime = 1538411880 AND .EndTime = 1538415480 AND .Measurement = 'Bytes' AND .LimitCount = 50 AND .Direction = 'Out' AND .ProtocolID = 24 HAVING (.RAWebCall = 'HostSummary')
Error occurred while running a RIB query on SQL RIB source.

Errors from the NFA WebServiceQueryLog.log:

15:46:48 -1 - Query: 
   archive@x.x.x.x:3307
Fatal error encountered during command execution.
   select    protocol,    sum(outoctets) Bytes    from protocol_traffic    where (router=inet_aton('10.0.4.20') and interface=2) and TimeStamp > 1539096360 - 60 and TimeStamp <= 1539099960 and protocol not in (4,0,1,2,3)    group by protocol    having Bytes > 0    order by Bytes desc    limit 50;
   (423.0000 ms)

15:46:50 -1 -  - :
Unable to connect to any of the specified MySQL hosts.
MySql.Data.MySqlClient.MySqlException (0x80004005): Unable to connect to any of the specified MySQL hosts.
   at MySql.Data.MySqlClient.NativeDriver.Open()
   at MySql.Data.MySqlClient.Driver.Open()
   at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings)
   at MySql.Data.MySqlClient.MySqlPool.CreateNewPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()
   at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver()
   at MySql.Data.MySqlClient.MySqlPool.GetConnection()
   at MySql.Data.MySqlClient.MySqlConnection.Open()
   at NetQoS.Data.MySqlDataComponentBase.OpenConnection(MySqlConnection connection)
Environment:
NFA 9.3.0+
Cause:
Microsoft Visual C++ 2013 Redistributable (x64) 12.0.30501 is missing from the server
Resolution:
  1. Download Microsoft Visual C++ 2013 Redistributable (x64) 12.0.30501 to each harvester and install it.
  2. Restart the CA NFA NQMySQL afterwards.
  3. The graphs should now load properly.