ICDX - Database query 0010_AlertsQuery failed

Products

• ICDx

Issue/Introduction

Below error occurring in SEPM collector logs

[DB Sensor] WARN com.symantec.cas.ucf.sensors.DB.DBSensor - Database query 0010_AlertsQuery failed. The datediff function resulted in an overflow. The number of dateparts separating two date/time instances is too large. Try to use datediff with a less precise datepart.

Cause

This issue could be caused by wrong data format in ALERTS table from sem5 database.

Resolution

This issue should be solved at SEPM database level by removing wrong date format.
Open a case through Broadcom portal for assistance