The customer reported an issue where large number of CSP agents (80%) remain offline (communication health red) and those agents are not transmitting events.
SISIPSService.log
MCOM,3,2025-06-16 02:04:18.729 Z+0100,W,50,HttpsLogDestination::writeLog,,F,,Communication,,,,,"SCSP Error when trying to send a log. Error Code 300 : Error Message : "1;SQL Code: 515&1;crlf1;&1; 'SCSPDB.dbo.DISCOVERED_DEVICE'
sis-agent.0.log
Cannot insert the value NULL into column 'OptProductId', table 'SCSPDB.dbo.DISCOVERED_DEVICE'; column does not
allow nulls. INSERT fails.
CSP 8.0.2
This is a known issue that was resolved in the latest Critical System Protection (CSP) Management Server Hotfix.
Upgrade Critical System Protection Management Server to build 8.0.2.133 or higher.
For updated SP please see ESCRT-7034