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.
CCS 12.5.x
CCS 12.6.x
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
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:
Additional information on evidence data in CCS: