NFA and CAPC / NetOps Portal temp_id2 table is full sync error

Products

• CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

If you find a sync error between NFA and CAPC / NetOps Portal with the NFA Console ProductSyncLog saying:

14:34:36 2 - Push - Error processing members :
NQS_BUS_10100: Flatten failed on Interface
NetQoS.ReporterAnalyzer.i18n.i18nException: Flatten failed on Interface ---> MySql.Data.MySqlClient.MySqlException: The table 'temp_id2' is full
   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.ExecuteNonQueryWithCommandTimeout(String sql, Int32 timeout, IFileLog fileLog)
   at NetQoS.ReporterAnalyzer.Data.ReporterAnalyzer.ProductSync.PushedMembersDc.BuildRelationshipWalkTable(String sql, String tempDstTable)
   at NetQoS.ReporterAnalyzer.Data.ReporterAnalyzer.ProductSync.PushedMembersDc.Flatten(String typeTable, String itemTypeName, UInt32 startTime, Boolean removeInheritance)
   at NetQoS.ReporterAnalyzer.Business.ProductSync.PushedMembers.FlattenAll(UInt32 updatedOn, Boolean removeInheritance, IFileLog fileLog)
   --- End of inner exception stack trace ---
   at NetQoS.ReporterAnalyzer.Business.ProductSync.PushedMembers.FlattenAll(UInt32 updatedOn, Boolean removeInheritance, IFileLog fileLog)
   at NetQoS.ReporterAnalyzer.Business.ProductSync.PushedMembers.UpdateStagedData(UInt32 updatedOn, IFileLog fileLog)
   at NetQoS.ReporterAnalyzer.Business.ProductSync.Sync.EndPush(SyncTime syncTime)

Environment

Release : 20.2

Component : NQRPTA - REPORTERANALYZER

Cause

The reporter.groups table is very large and requires more than 512MB for an in-memory temp table.

Resolution

To resolve this, we edited the D:\CA\NFA\MySql\my.ini file on the NFA console:

We changed:

tmp_table_size=512M
max_heap_table_size=512M

to 

tmp_table_size=1024M
max_heap_table_size=1024M

We then restarted CA NFA MySQL Service on the NFA console and did the resync to see the problem has been resolved.