Unable to close CEM incidents.

Products

• CA Application Performance Management Agent (APM / Wily / Introscope)
• INTROSCOPE

Issue/Introduction

  Symptoms: 

  Not able to close Incidents under CEM UI Incident Management, it keep loading and never stops.

 

  Environment:  

  Introscope from 9.1x to 10.x

 

  Cause: 

  This may happen due to a high number of defects in the APM Database.  Often, this occurs when the number of defects exceeds more than a million.

 

 Workaround:

 Use either of these two approaches:

 

 Approach 1: SQL Query  

 Run the following query against the database:

 update ts_biz_events set ts_status = 1 where ts_status in (2,3,4)

 Note: ts_status = 1 (Close), 2 = Open, 3=Pending, 4=Aged out.

 

 Approach 2: APM CE (CEM) Export Tool
  Use the export tool with these command-specific parameters: -incidentid -comments(optional)
               

                For example:
                java -jar CEMExportTool.jar -host cembox -username username -password password -port 8081 -command 20 -incidentid 1 -comments "Closed from CEMExportTool by someone"

 

Environment

Release: CEMUGD00200-10.2-Introscope to CA Application-Performance Management-Upgrade Mai
Component: