Archive Manager is hunging

Document ID : KB000094247
Last Modified Date : 03/05/2018
Show Technical Document Details
The Archive Manager is hunging and the following error message was found in the $SPECROOT/SS/DDM/ARCHMGR.OUT file:
May 03 09:28:47 : ArchMgr started as user 'specadmin'
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

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 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\0vcspeconsrv113L+\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\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 Aborting database transaction.
May 03 09:30:41 ERROR TRACE at 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.
CA Spectrum 10.2.1 and CA UIM 8.51 SP1 + spectrumgtw 8.65 + SNMP Gateway 1.40
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; 
Disabled the SNMP Gateway probe.