SOI : purgeClearedAlerts command hangs and does not finish
search cancel

SOI : purgeClearedAlerts command hangs and does not finish

book

Article ID: 272191

calendar_today

Updated On:

Products

CA Service Operations Insight (SOI)

Issue/Introduction

When you use the SOItoolCommand to purge the old alerts( purgeClearedAlerts) the script hangs and does not finish: 

Started 04/08/2023 at 01:00:01

-> Looking for SOI services on machine HOSTANAME
-> Connecting to the server HOSTANAME... DONE
   Service CA SOI UI Server                    : NOT FOUND
   Service CA SOI Store Indexer                : NOT FOUND
   Service CA SOI Integration Services         : NOT FOUND
   Service CA Cat. container CatalystConnector : NOT FOUND
   Service CA SOI Event Management             : NOT FOUND
   Service CA SOI UCF Broker                   : NOT FOUND
   Service CA SOI Application Server           : NOT FOUND
   Service CA SOI MQ Server                    : NOT FOUND
-> Initializing DB connection to SAMStore@HOSTANAME(timeouts=3000/7200)... 
Connecting using SQL Server driver
DONE
-> Checking DB schema version... DONE

-> Checking if SOI is running... NO, all SOI services are stopped

-> Deleting cleared Alerts older than 85 days from the SOI database...  
Total cleared alerts to be deleted: 110643
Time taken to find the alerts to delete : 25.7 seconds
Number of Database trips for purge will be : 111
0.9% - 1000 out of 110643 alerts have been purged
1.81% - 2000 out of 110643 alerts have been purged
2.71% - 3000 out of 110643 alerts have been purged
3.62% - 4000 out of 110643 alerts have been purged
4.52% - 5000 out of 110643 alerts have been purged
5.42% - 6000 out of 110643 alerts have been purged
6.33% - 7000 out of 110643 alerts have been purged
7.23% - 8000 out of 110643 alerts have been purged
8.13% - 9000 out of 110643 alerts have been purged
9.04% - 10000 out of 110643 alerts have been purged
9.94% - 11000 out of 110643 alerts have been purged
10.85% - 12000 out of 110643 alerts have been purged
11.75% - 13000 out of 110643 alerts have been purged
12.65% - 14000 out of 110643 alerts have been purged
13.56% - 15000 out of 110643 alerts have been purged
14.46% - 16000 out of 110643 alerts have been purged
15.36% - 17000 out of 110643 alerts have been purged
16.27% - 18000 out of 110643 alerts have been purged
17.17% - 19000 out of 110643 alerts have been purged
18.08% - 20000 out of 110643 alerts have been purged
18.98% - 21000 out of 110643 alerts have been purged
19.88% - 22000 out of 110643 alerts have been purged
20.79% - 23000 out of 110643 alerts have been purged
21.69% - 24000 out of 110643 alerts have been purged
22.6% - 25000 out of 110643 alerts have been purged
23.5% - 26000 out of 110643 alerts have been purged
24.4% - 27000 out of 110643 alerts have been purged
25.31% - 28000 out of 110643 alerts have been purged
26.21% - 29000 out of 110643 alerts have been purged
27.11% - 30000 out of 110643 alerts have been purged
28.02% - 31000 out of 110643 alerts have been purged
28.92% - 32000 out of 110643 alerts have been purged
29.83% - 33000 out of 110643 alerts have been purged
30.73% - 34000 out of 110643 alerts have been purged
31.63% - 35000 out of 110643 alerts have been purged
32.54% - 36000 out of 110643 alerts have been purged
33.44% - 37000 out of 110643 alerts have been purged
34.34% - 38000 out of 110643 alerts have been purged
35.25% - 39000 out of 110643 alerts have been purged
36.15% - 40000 out of 110643 alerts have been purged
37.06% - 41000 out of 110643 alerts have been purged
37.96% - 42000 out of 110643 alerts have been purged
38.86% - 43000 out of 110643 alerts have been purged
39.77% - 44000 out of 110643 alerts have been purged
40.67% - 45000 out of 110643 alerts have been purged
41.58% - 46000 out of 110643 alerts have been purged
42.48% - 47000 out of 110643 alerts have been purged
43.38% - 48000 out of 110643 alerts have been purged
44.29% - 49000 out of 110643 alerts have been purged
45.19% - 50000 out of 110643 alerts have been purged
46.09% - 51000 out of 110643 alerts have been purged
47.0% - 52000 out of 110643 alerts have been purged
47.9% - 53000 out of 110643 alerts have been purged
48.81% - 54000 out of 110643 alerts have been purged <----------- script hangs here 

 

 

Environment

Release : 4.2

MSSQL

Cause

The query takes too long and times out. 

Resolution

In order to fix the above issue, increase the remote query execution timeout:

Using SQL Server Management Studio
To configure the remote query timeout option:

1. In Object Explorer, right-click a server and select Properties.

2. Click the Connections node.

3. Under Remote server connections, in the Remote query timeout box, type or select a value from 0 through 2,147,483,647 to set the maximum number of seconds for the SQL Server to wait before timing out.