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)'
[{"Product":{"code":"SSETBF","label":"IBM Security SiteProtector System"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Database","Platform":[{"code":"PF033","label":"Windows"}],"Version":"3.0;3.1;3.1.1","Edition":"","Line of Business":{"code":"LOB77","label":"Automation Platform"}}]
Log InLog in to view more of this document
This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.
Historical Number
5458
Was this topic helpful?
Document Information
Modified date:
20 January 2021
UID
swg21436947