Unable to close CEM incidents.

Document ID : KB000044026
Last Modified Date : 14/02/2018
Show Technical Document Details


  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)

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