The CSM_DB data and CSM_Reports are full and purge jobs are not reducing the size of the DB

book

Article ID: 156255

calendar_today

Updated On:

Products

Control Compliance Suite Windows

Issue/Introduction

The CSM_DB data and CSM_Reports are full and purge jobs are not reducing the size of the DB

none reported.

Cause

as long as there are jobs that utilize assets or the gathered data the purge job will not acknowledge the data to be marked as purged.

Resolution

1.  delete any evaluation jobs or data collection jobs that are no longer needed.
Especially any failed jobs.  Then schedule a purge job.  Or expand database.

2. Find out what tables are the largest and send list to TSE.

ex.

CSM_DB; row count
R_CheckResults tables=76,841,276
B_Failures = 7,692,814
R_AssetStandardSummary = 546,254

CSM_Reports;
SubjectTestResultDetailArchive = 95,019,419
SubjectTestResultArchive = 32,434,722
SubjectTestResultEvidenceArchive =12,551,129


Applies To

CCS 10.5.1
pcu = ?

CSM_DB; row count
R_CheckResults tables=76,841,276
B_Failures = 7,692,814
R_AssetStandardSummary = 546,254

CSM_Reports;
SubjectTestResultDetailArchive = 95,019,419
SubjectTestResultArchive = 32,434,722
SubjectTestResultEvidenceArchive =12,551,129