Monitor unlimited number of servers
Filter log events
Create email and web-based reports

Direct access to Microsoft articles
Customized keywords for major search engines
Access to premium content

Event ID: 1 Source: CSAdminServer

Source
Level
Description
Database error occured: Error information: 1950/3621 (Generic db error: "Database error: code = 3621 message="IDispatch error #3119" description="DELETE statement conflicted with COLUMN REFERENCE constraint "FK_fts_uagents__Hosts_nId". The conflict occurred in database "KAVA" table "fts_uagents" column "nAgentHostId".
DELETE statement conflicted with COLUMN REFERENCE constraint "FK_fts_uagents__Hosts_nId". The conflict occurred in database "KAVA" table "fts_uagents" column "nAgentHostId".
The statement has been terminated." source="Microsoft OLE DB Pro) O:\CS AdminKit\development2\server\db\ado\db_adoprepstmtimpl.cpp 376
Comments
 
In my case, the error was "Database error occured: #1950 (156) Generic db error: "156, 'Microsoft OLE DB Provider for SQL Server', 'IDispatch error #3092', 'Incorrect syntax near the keyword 'WHERE'.', GUID='{0C733A63-2A1C-11CE-ADE5-00AA0044773D}', LastStatement='UPDATE ak_patches SET wstrApplicationName=N'1093', wstrFileName=N'patch_2786_server_b.exe', wstrRelativeSrvPath=N'AutoPatches/akp8/9.0.2786/', wstrToAppVersion=N', wstrFromAppVersion=N'9.0.2786, 9.0.2800, {cc02c40a-4ce3-421b-8fa3-1ddb1788c088}, 9.0.2802, {3062db5e-3763-4c4a-8910-358f61fc67ed}, {cc02c40a-4ce3-421b-8fa"

For this problem see this Kaspersky fix: EV100307 (Incorrect syntax near the keyword WHERE error in Kaspersky Event Log).

Windows Event Log Analysis Splunk App

Build a great reporting interface using Splunk, one of the leaders in the Security Information and Event Management (SIEM) field, linking the collected Windows events to www.eventid.net.

Read more...

 

Cisco ASA Log Analyzer Splunk App

Obtain enhanced visibility into Cisco ASA firewall logs using the free Firegen for Cisco ASA Splunk App. Take advantage of dashboards built to optimize the threat analysis process.

Read more...