"Database error during results storage" Continuous error with collection-evaluation in Control Compliance Suite

Products

• Control Compliance Suite Standards Database
• Control Compliance Suite
• Control Compliance Suite Databases Oracle
• Control Compliance Suite Directory Services
• Control Compliance Suite Standards Middleware
• Control Compliance Suite Standards Module
• Control Compliance Suite Standards Network Devices
• Control Compliance Suite Standards Server
• Control Compliance Suite Standards Virtual Server

Issue/Introduction

Trying to run a report and it is failing with: 

"Error details: An error occurred in Evaluation activity: Data Query failed: Results storage failed: System.ApplicationException: Database error during results storage."

 

Cause

The logs showed similar entries as seen below:

2025-05-29 18:19:40.843,2025-05-29 14:19:40.843,Example,Verbose,SQLStoreAPI,AppserverService,5428,BladeRunnerAsyncUploadQueue thread:99,99,InsertEvidence,,0,0,Bulk Insert has Failed with exception trying slow insert
2025-05-29 18:19:40.843,2025-05-29 14:19:40.843,Example,Error,SQLStoreAPI,AppserverService,5428,BladeRunnerAsyncUploadQueue thread:99,99,InsertEvidence,,0,0,"Exception in InsertEvidence: System.Data.SqlClient.SqlException (0x80131904): The transaction log for database 'CSM_Reports' is full due to 'LOG_BACKUP'.
   at Symantec.CSM.SQLStoreAPI.EvidenceStoreOne.InsertEvidence(DateTime EvalDate, String& EvidenceData)
   at Symantec.CSM.SQLStoreAPI.SMEvidenceHelper.InsertEvidence(List`1 checksDetailedEvidence, DateTime entryDateTime)
ClientConnectionId:GUID
Error Number:9002,State:2,Class:17"
2025-05-29 18:19:40.843,2025-05-29 14:19:40.843,Example,Error,EvidenceResultStorage,AppserverService,5428,BladeRunnerAsyncUploadQueue thread:99,99,InsertEvaluationResultsEvidence,,0,0,"System.Exception: InternalError:Unable to store evidence

2025-05-29 18:19:40.859,2025-05-29 14:19:40.859,Example,Error,AppServer.BladeRunnerJobs,AppserverService,5428,BladeRunnerAsyncUploadQueue thread:99,99,OnUploadFailed,,0,0,"Results upload failure occurred for DPS job c34fddee-5402-4511-9381-fbf9138a3ed8, job cannot continue. : System.ApplicationException: Results storage failed: System.ApplicationException: Database error during results storage. ---> System.ApplicationException: Database error during results storage.

Resolution

The transaction database is full. Follow the steps in the MS article to troubleshoot why and to resolve the issue.

Troubleshoot a full transaction log (SQL Server Error 9002)

 

The above article includes a script.  Run this script against the CSM_Reports database.
If nothing comes back or nothing for "Transaction Log Backup", then you will need to back up the transaction log for the CSM_Reports database.

That can be done by following the steps in the following MS article.

Back up a transaction log