search cancel

The SQL db table CIStagingTemp has a large number of rows.

book

Article ID: 230235

calendar_today

Updated On:

Products

CA Service Operations Insight (SOI)

Issue/Introduction

The CIStagingTemp table is very large, and there is no option to clean it up in the soitoolbox.

How can we reduce the size of this table?

 

Environment

Release : 4.2

Component : SOI DATABASE/MODELING

Cause

Not all SQL tables are included in the SOItoolbox.

Resolution

Access the SQL manager and run this query:

    TRUNCATE TABLE CIStagingTemp;

Restart the SOI manager and UI services.