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?
Release : 4.2
Component : SOI DATABASE/MODELING
Not all SQL tables are included in the SOItoolbox.
Access the SQL manager and run this query:
TRUNCATE TABLE CIStagingTemp;
Restart the SOI manager and UI services.