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

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.