IT Analytics (ITA) processing jobs for the DLP Endpoint Incident Details and DLP Endpoint Incident Summary cubes fail and the SQL Server Agent logs the following error:
<Warning WarningCode="2165374978" Description="Errors in the back-end database access module. The size specified for a binding was too small, resulting in one or more column values being truncated." Source="Microsoft SQL Server 2016 Analysis Services" HelpFile="" />
After following the procedure documented in KB article 224711, the failure is traced to the column Endpoint Incident - Machine Name.
Release : 2.9.1
Component : Cubes
An endpoint agent's machine (computer) name exceeds 15 characters.
The NETBIOS naming standard restricts Windows machine names to 15 characters, with a 16th character "reserved to identify the functionality that is installed on the registered network device". See the following Microsoft document for more information:
Computer endpoints that do not conform to the NETBIOS standard, such as those running macOS or Linux, may have machine names that exceed this length limitation.
To increase the column binding size for the Endpoint Incident - Machine Name attribute, follow this procedure:
<ID>Endpoint Incident - Machine Name</ID>
<Name>Endpoint Incident - Machine Name</Name>
The DLP Endpoint Incident dimension is populated during cube processing by the view vITAnalytics_DLP_EndpointIncidentDim, which specifies a datatype of nvarchar for the ENDPOINTMACHINENAME column and a string length of 255; however, the column bindings for the dimension's Endpoint Incident - Machine Name attribute are restricted to 15 characters, per the NETBIOS standard.