ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

soitoolbox purgeClearedAlerts timeouts with SOI Services active

book

Article ID: 145709

calendar_today

Updated On:

Products

CA Service Operations Insight (SOI)

Issue/Introduction

The soitoolbox runs into timeouts for large amount of data for purgeClearedAlerts when SOI Services are up and running

Cause

When SOI Services are up and running the sql queries executed by soitoolbox purgeClearedAlerts feature might timeout in SQL Server caused of the large number of rows they have to clear in the database.

Environment

Release : 4.2

Component : Service Operations Insight (SOI) Manager

Resolution

The new introduced soitoolbox batchSize parameter allows to define the amount of rows that should be cleared in one go. This helps to prevent any timeouts. Furthermore it is enhanced to take care for maintenance of ca_ssa_* tables in the database as well. The new soitoolbox utility is available with latest cumulative SOI patches after April 2019.

examples for batchSize parameter usage:


1) soitoolbox.exe -x --purgeClearedAlerts 90 --batchSize 5000 --timeout 0

2) soitoolbox.exe -x --cleanHistoryData 90 --batchSize 5000 --timeout 0