DX Netops Spectrum Report Manager errors processing bucket files for NCM

Products

• Spectrum

Issue/Introduction

 

Jul 21, 2022 10:27:04.662 (SRM/EventPoller/ ) (SRM_Model_Create_Destroy_Events) - (ERROR) - Unable to properly process handler update.
  Domain:
  Handler: ModelCreateDestroyHandler
Jul 21, 2022 10:27:14.875 (SRM/EventPoller/) (SRM_Model_Create_Destroy_Events) - (ERROR) - Unable to properly process handler update.
  Domain:
  Handler: ModelCreateDestroyHandler
Jul 21, 2022 10:27:31.309 (SRM/EventPoller/) (com.aprisma.spectrum.app.repmgr.dc.event.handler.NCMConfigHandler) - (ERROR) - Unable to properly process handler update.
  Domain:
  Handler: NCMConfigHandler
Jul 21, 2022 10:27:38.963 (SRM/EventPoller/) (SRM_Model_Create_Destroy_Events) - (ERROR) - Unable to properly process handler update.
  Domain:
  Handler: ModelCreateDestroyHandler
Jul 21, 2022 10:27:58.296 (SRM/EventPoller/) (SRM_Model_Create_Destroy_Events) - (ERROR) - Unable to properly process handler update.
  Domain:
  Handler: ModelCreateDestroyHandler
Jul 21, 2022 10:28:18.946 (SRM/EventPoller/) (SRM_Model_Create_Destroy_Events) - (ERROR) - Unable to properly process handler update.
  Domain:
  Handler: ModelCreateDestroyHandler
Jul 21, 2022 10:28:54.732 (SRM/EventPoller/) (SRM_Model_Create_Destroy_Events) - (ERROR) - Unable to properly process handler update.
  Domain:
  Handler: ModelCreateDestroyHandler
Jul 21, 2022 10:29:40.534 (SRM/EventPoller/) (SRM_Model_Create_Destroy_Events) - (ERROR) - Unable to properly process handler update.
  Domain:
  Handler: ModelCreateDestroyHandler
Jul 21, 2022 10:29:40.918 (SRM/EventPoller/) (SRM_Model_Create_Destroy_Events) - (ERROR) - Unable to properly process handler update.
  Domain: 
  Handler: ModelCreateDestroyHandler
Jul 21, 2022 10:29:56.894 (SRM/EventPoller/) (SRM_Model_Create_Destroy_Events) - (ERROR) - Unable to properly process handler update.
  Domain: 
  Handler: ModelCreateDestroyHandler
Jul 21, 2022 10:30:24.041 (SRM/EventPoller/) (SRM_Model_Create_Destroy_Events) - (ERROR) - Unable to properly process handler update.
  Domain: 
  Handler: ModelCreateDestroyHandler

Caused by:com.mysql.jdbc.PacketTooBigException: Packet for query is too large (17452434

>16777216). You can change this value on the server by setting the max_allowed_packet' variable.

 

Environment

Release : 21.2

Component : Spectrum Reporting

Cause

Large NCM configuration exceeds max packet size for MySQL set.

Resolution

Located in $SPECROOT/mysql/my-spectrum.cnf is the line:

max_allowed_packet=16M

This value can be increased to 20M.

Restart MySQL and Tomcat service.