CCS error during Evaluation: "An error occurred in evaluation activity; Data query failed; Results storage failed; System.ApplicationException; Database error during results storage."
search cancel

CCS error during Evaluation: "An error occurred in evaluation activity; Data query failed; Results storage failed; System.ApplicationException; Database error during results storage."

book

Article ID: 158993

calendar_today

Updated On:

Products

Control Compliance Suite Control Compliance Suite Standards Server Control Compliance Suite Standards Module

Issue/Introduction

Running a CCS CER job or an Evaluation job, you see the following error in the CCS console:

"An error occurred in evaluation activity; Data query failed; Results storage failed; System.ApplicationException; Database error during results storage." 

 

This error also shows up in the Application server logs:

Log path example: C:\ProgramData\Symantec.CSM\Logs\AppServer\AppServer.Service.XXXXXXXXXXXXXX.XXXX.XXXXX

2022-09-30 14:50:02.677,2022-09-30 10:50:02.677,AppSrvrHostName,Error,AppServer.BladeRunnerJobs,AppserverService,4284,BladeRunnerAsyncUploadQueue thread:74,74,OnUploadFailed,,0,0,"Results upload failure occurred for DPS job 8a3230dd-####-####-####-4f24dabf115a, job cannot continue. : System.ApplicationException: Results storage failed: System.ApplicationException: Database error during results storage. ---> System.ApplicationException: Database error during results storage.

and a bit farther in the logs:

2022-09-30 14:50:02.739,2022-09-30 10:50:02.739,AppSrvrHostName,Error,AppServer.WorkFlowSvc,AppserverService,4284,,72,Runtime_WorkflowTerminated,,0,0,"Runtime_WorkflowTerminated called for job instance 8a3230dd-####-####-a757-4f24dabf115a : Symantec.Interfaces.AppServer.JobManagement.EvaluationException: An error occurred in Evaluation activity: Data Query failed: Results storage failed: System.ApplicationException: Database error during results storage. ---> System.ApplicationException: Data Query failed: Results storage failed: System.ApplicationException: Database error during results storage. ---> System.ApplicationException: Results storage failed: System.ApplicationException: Database error during results storage. ---> System.ApplicationException: Database error during results storage.

Environment

CCS 12.5.x
CCS 12.6.x

Cause

Every 90 days, a new CSM Storage Evidence file is created on the CSM_Reports database. 

In this particular case, CCS Stored Procedure (spCreateEvidencePartition) was scheduled for the day when there was a shortage of disk space on the SQL server. 

Due to the lack of the storage, the corresponding file has not been created

Screenshots below demonstrate properly created storage evidence files:

The Files tab should correspond to the Filegroups tab

Resolution

Executing a stored procedure manually from SQL Management Studio fixes the issue.

NOTE: Make sure you have adequate free space for your Reporting database (CSM_Reports) before proceeding with the steps below.  Also note if Positive Evidence is enabled in your environment, the required disk space may be considerably higher than what is recommended in the documentation link below.
Disk sizing for Reporting database

Steps:

  • Browse CSM_Reports and navigate to Programmability -->Stored Procedures -->dbo.spCreateEvidencePartition 
  • Right Click -->Execute Stored Procedure

 

Additional Information

Additional information on evidence data in CCS:

Database maintenance for evidence data