Not able to close Incidents under CEM UI Incident Management, it keep loading and never stops.
Introscope from 9.1x to 10.x
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.
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)
java -jar CEMExportTool.jar -host cembox -username username -password password -port 8081 -command 20 -incidentid 1 -comments "Closed from CEMExportTool by someone"