ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

CAPC sync with NFA is failing with "The table 'temprelationsstaged' is full"

book

Article ID: 133332

calendar_today

Updated On:

Products

CA Network Flow Analysis (NetQos / NFA)

Issue/Introduction

User is not seeing all interfaces on a device, but Admin users can see all interfaces on a device.

After validating there were no duplicate interfaces on the device we found the CAPC sync with NFA was throwing some errors in the \CA\NFA\Reporter\Logs\WebServiceQueryLog*.log, mysql *.err log, and  \CA\NFA\Reporter\Logs\LogLog*.log like below:

  • WebServiceQueryLog

The table 'temprelationsstaged' is full


   START TRANSACTION;INSERT IGNORE INTO tempRelationsStaged (ParentGroupID, MemberGroupID, MemberTypeName) SELECT ParentGroupID, MemberGroupID, MemberTypeName FROM temp_id1 WHERE ParentTypeName='group';COMMIT


  • LogLog*.log

CallMethod.Invoke - :


Exception has been thrown by the target of an invocation.


System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> NetQoS.ReporterAnalyzer.i18n.i18nException: Flatten failed on Interface ---> NetQoS.ReporterAnalyzer.i18n.i18nException: Flatten failed on Interface ---> MySql.Data.MySqlClient.MySqlException: The table 'temprelationsstaged' is full


   at NetQoS.Data.MySqlDataComponentBase.ExecuteNonQueryWithIncreasingTimeout(MySqlConnection connection, String sql, IFileLog fileLog, DataParameter[] dataParameters)


  • Mysql .err log

[ERROR] D:\NETQOS\MySql\bin\mysqld.exe: The table 'temprelationsstaged' is full

Environment

Release : 9.3, 9.5, 10.0

Component : NQRPTA - REPORTERANALYZER

Resolution

1.  On the NFA Console server edit the my.ini file in the \CA\NFA\MySql directory.

2.  Find the max_heap_table_size  and change the value from the default 512 to 1024 like below:

              max_heap_table_size=1024

3.  Save the file and restart the CA Mysql service, which will restart most of the services on the NFA Console.

4. Perform a Full resync of the NFA data source and allow it to complete.

5. Check the ProductSyncWS*.log, WebServiceQueryWS*.log, LogLog*.log, and the mysql *.err log for any errors or exceptions.

6. Validate that issue is resolved for the user who was not able to see all interfaces.

Additional Information

See also the two KB articles below:

https://ca-broadcom.wolkenservicedesk.com/kb/nfa-data-not-seen-in-capc-but-is-seen-in-nfa/KB000108589

https://ca-broadcom.wolkenservicedesk.com/kb/certain-nfa-users-cannot-see-interfaces/kb000009253