Troubleshooting
Problem
Users may find that they are seeing an increase in rejected events in the SiteProtector Console.
Symptom
- New events are not being displayed in SiteProtector and the rejected event count is increasing.
- The job history of the Load Sensor Data job under SQL Agent in the SQL server indicates the following error:
EXECUTE msdb.dbo.sp_sqlagent_log_jobhistory @job_id = 0xB293935E355E51449C5EC6D23E865154, @step_id = 1, @sql_message_id = 3621, @sql_severity = 16, @run_status = 2, @run_date = 20090319, @run_time = 121829, @run_duration = 4, @operator_id_emailed = 0, @operator_id_netsent = 0, @operator_id_paged = 0, @retries_attempted = 0, @session_id = 97, @message = N'Executed as user: IssApp. Cannot insert the value NULL into column ''VulnStatus'', table ''RealSecureDB.dbo.SecurityChecks''; column does not allow nulls. INSERT fails. [SQLSTATE 23000] (Error 515) The statement has been terminated. [SQLSTATE 01000] (Error 3621)'
Resolving The Problem
If you have the error message above, check the SecurityChecks table definition and verify that VulnStatus is defined correctly. It should be a bit value, with (0) as default, and no Nulls are allowed.
- In SQL Server Management Studio, expand Databases > RealSecureDB > Tables.
- Right-click the SecurityChecks table and select Design.
- Highlight the VulnStats column.
- In the Column Properties window, ensure the Default Value or Binding is set to
0
.
[{"Product":{"code":"SSETBF","label":"IBM Security SiteProtector System"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Database","Platform":[{"code":"PF033","label":"Windows"}],"Version":"3.0;3.1;3.1.1","Edition":"","Line of Business":{"code":"LOB24","label":"Security Software"}}]
Historical Number
5458
Was this topic helpful?
Document Information
Modified date:
20 January 2021
UID
swg21436947