Error Message

2021-06-18 09:37:47 INFO: #{23} [AlertsManager.processWBIntermediateDB] Processing new alerts from file: C:\DataInsight\data\alerts\inbox\alerts_1_1623796202103_wbrt.sqlite (72 KB)

2021-06-18 09:37:47 INFO: #{23} [AlertsManager.processWBIntermediateDB] Found real-time alerts db for whitelist/blacklist policies: C:\DataInsight\data\alerts\inbox\alerts_1_1623796202103_wbrt.sqlite

2021-06-18 09:37:47 SEVERE: #{23} [AlertsManager.executeMergeRpt] Error while merging alerts DB

2021-06-18 09:37:47 SEVERE: #{23} [PolicyJob.processWBIntermediateDB] Error occured while merging alerts from intermediateDB to alertsDB for alert file alerts_1_1623796202103_wbrt.db

2021-06-18 09:37:47 INFO: #{23} [PolicyJob.processWBIntermediateDB] Moving C:\DataInsight\data\alerts\inbox\alerts_1_1623796202103_wbrt.db to C:\DataInsight\data\alerts\err\alerts_1_1623796202103_wbrt.db

2021-06-18 09:37:47 WARNING: #{23} [PolicyJob.processWBIntermediateDB] Could not move to err. Deleting C:\DataInsight\data\alerts\inbox\alerts_1_1623796202103_wbrt.db

Initial log entry indicating the issue:

2021-03-01 00:42:03 INFO: #{36} [AlertsManager.processWBIntermediateDB] Processing new alerts from file: d:\DataInsight\data\alerts\inbox\alerts_1_1612254455086_wbrt.sqlite (0 bytes)

At least one of the alert database files is corrupt or is empty (0kb) and cannot be processed

Since the file cannot be removed the gen_rt_alerts.exe is caught in a loop and will fail to process any remaining files from \DataInsight\data\alerts\inbox 

Remove all 0kb alert files from \DataInsight\data\alerts\inbox