CA Spectrum Archive Manager crash and performance issues

Products

• CA Spectrum

Issue/Introduction

When running CA Spectrum 10.2.2 or 10.2.3 users may notice that the Archive Manager (ArchMgr) process has crashed.  Also, users may see that mysql consumes 100% cpu, and there are delays when displaying events in the Events tab of OneClick.

Environment

Release: 10.2
Component: SPCAEM

Cause

ArchMgr and mysql inefficiencies were causing the issues.

Resolution

This is resolved in CA Spectrum release 10.3 and above with changes to Archive Manager and mysql. 

For CA Spectrum release 10.2.2, CA has released debug patch Spectrum_10.02.02.D403.  This MUST be installed on top of Spectrum_10.02.02.BMP_10.2.202 as there is functionality in the Spectrum_10.02.02.BMP_10.2.201 that D403 needs.  The release notes show:

Symptom: Arch Mgr was crashing when sql  server connection gets lost. 
    Resolution: Added few checks to prevent the crash.
    (DE367814, 01105510)

For CA Spectrum release 10.2.1, CA has released Spectrum_10.02.01.D336a. The release notes show:

    SAP Archive Manager high memory
    (DE298961, 00766236 )

If you need these patches, please open a case with CA Support and request them.