Spectrum Archive Manager is hanging

Products

• CA Spectrum

Issue/Introduction

The Spectrum Archive Manager is hanging and the following error message was found in the $SPECROOT/SS/DDM/ARCHMGR.OUT file:
 

May 03 09:28:47 : ArchMgr started as user '#####'
May 03 09:28:47 : ArchMgr validating database.
May 03 09:29:15 : ArchMgr successfully connected to MySQL service
May 03 09:29:15 : ArchMgr loaded DDM database with landscape handle 0x100000

May 03 09:29:19 : ArchMgr has successfully connected to the SpectroSERVER.
May 03 09:29:19 : ArchMgr has successfully advertised CORBA Event Service.

May 03 09:29:19 : ArchMgr is now ready on port 0xbafe, precedence 10

SPC-SHD-29021: 
**************************************************************************
The following output is intended to facilitate debugging, please forward
to CA technical support.  The files listed are not part of the customer
installation of SPECTRUM.
**************************************************************************

May 03 09:30:37 ERROR TRACE at ModelArchDBImp.cc(4851): doSqlQuery/mysql_query: Failure executing query:
INSERT DELAYED IGNORE INTO event(model_h, utime, counter, clk_seq, version, node_id, user_key, type, severity, vardata_string) VALUES(1379596,1525303436,5581261,725,1,'\0PV•dy',5,104005745,70,'\0\0\0\0\0\0\0\0\0\0\0\0<hostName>+\0\0\0\0æI\0\0Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared :Cleared 
.
.
.

:Cleared :Cleared :Cleared :Profile SQL-PECON, instance XX.YY.WW.ZZ has 0.48 page reads per second\0\0\0\0\0\0\r\0\0\0<IP_Address>e\0\0\0\0\0\0\0\0\00h\0\0\0\0\0\0\0\0\0SQL-PECON-page_readsi\0\0\0\0\0\0	\0\0\0sqlserverj\0\0\0\0\0\0\0\0\0Primary_Hub_nameq\0\0\0\0\0\0\0\0\04.2:34D3\0\0\0\0\0\0\0EX26233061-80861B3\0\0\0\0\0\0\0C3\0\0\0\0\0\0\0')
Native Error: 1153, Got a packet bigger than 'max_allowed_packet' bytes
May 03 09:30:41 ERROR TRACE at DDMDbIf.cc(2915): Aborting database transaction.
May 03 09:30:41 ERROR TRACE at CsEventMgr.cc(1752): Event Log Manager: Error attempting to log event to database.
.
May 03 09:30:43 : Closing database
May 03 09:30:43 : ArchMgr is shutting down...
May 03 09:30:43 : ArchMgr has successfully shut down.

 

Environment

CA Spectrum 10.2.1 and CA UIM 8.51 SP1 + spectrumgtw 8.65 + SNMP Gateway 1.40

Cause

The SNMP Gateway probe is still enabled, even though the spectrumgtw probe is already being used.

Run the following MySQL query on the DDMdb database to see if there is any event generated by the SNMP Gateway probe:

SELECT * FROM event WHERE type=0x6330076;

Resolution

Disabled the SNMP Gateway probe.