NFA Data Sources Synchronization fails with Tablespace error

book

Article ID: 221320

calendar_today

Updated On:

Products

CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

If you observe this sync error between the NFA data source and the NetOps Portal in the x:\CA\NFA\reporter\Logs\ ProductSyncWSLog's:

0:48:02 -1 - PushRequest - :
Exception has been thrown by the target of an invocation.
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> MySql.Data.MySqlClient.MySqlException: Tablespace '`reporter`.`interface_groups_staged`' exists.
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at NetQoS.Data.MySqlDataComponentBase.ExecuteNonQuery(MySqlConnection connection, String sql, Int32 commandTimeout, IFileLog fileLog, DataParameter[] dataParameters)
   at NetQoS.Data.MySqlDataComponentBase.ExecuteNonQuery(String sql)
   at NetQoS.ReporterAnalyzer.Data.ReporterAnalyzer.TypedGroupsDc.CreateStagingTable()
   at NetQoS.ReporterAnalyzer.Business.ProductSync.StagedMembers.Initialize(Boolean fullUpdate, IFileLog fileLog)
   at NetQoS.ReporterAnalyzer.Business.ProductSync.Sync.Push_Members(SyncTime syncTime, SyncUpdateState sus, SyncUpdateTable sut)
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
   at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at NetQoS.ReporterAnalyzer.Business.ProductSync.SyncUtility.Callback(Sync syncInstance, SyncUpdateTable sut, SyncTime syncTime, SyncUpdateState sus)
   at NetQoS.ReporterAnalyzer.Business.ProductSync.Sync.PushRequest(SyncTime syncTime, SyncUpdateState syncUpdateState)
   at NetQoS.ReporterAnalyzer.WebService.ProductSync.ProductSync.PushRequest(SyncTime syncTime, SyncUpdateState syncUpdateState)

 

Cause

There is an .ibd file in the x:\CA\NFA\MySQL\data\reporter directory without a table space causing a sync code exception.

Environment

Network Flow Analysis

Resolution

1. Go to the x:\CA\NFA\MySQL\data\reporter directory and cut out the interface_groups_staged.ibd file and move it to the desktop.

2. Restart the CA MySQL Service.

3. Ensure the logs don't show further failures in x:\CA\NFA\reporter\Logs\ ProductSyncWSLog's.