Alarm hangs when generating report

Products

• Endpoint Threat Defense for Active Directory

Issue/Introduction

You are experiencing a malfunction in the display of alarms in the Inbox section, as shown in the following screenshot:

 

Environment

Endpoint Threat Defense for Active Directory on premises

External SQL server

Cause

While creating db, we observed the failure in creating the table "slf".
Refer to and note the error statement in the "SETDADHelperSvc.log" file, below:
============
[ERR] Column or parameter 'value' has type 'text' and collation 'Latin1_General_100_CI_AI_SC'. The legacy LOB types do not support Unicode supplementary characters whose codepoints are U+10000 or greater. Change the column or parameter type to varchar(max), nvarchar(max) or use a collation which does not have the _SC flag.
Warning! The maximum key length for a clustered index is 900 bytes. The index 'PK_domainou_32136E598B7D18B4' has maximum length of 1024 bytes. For some combination of large values, the insert/update operation will fail.
============"

Resolution

Please get in contact with support quoting this article.