DLP Incident Message Component Document Format dimension generating a data binding error

Products

• IT Analytics

Issue/Introduction

When processing the dimension DLP Incident Message Component Document Format for DLP 14.6 a data binding error is generated.

<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">
  <Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100" xmlns:ddl200="http://schemas.microsoft.com/analysisservices/2010/engine/200" xmlns:ddl200_200="http://schemas.microsoft.com/analysisservices/2010/engine/200/200">
    <Object>
      <DatabaseID>IT Analytics</DatabaseID>
      <DimensionID>DLP Incident Message Component Document Format</DimensionID>
    </Object>
    <Type>ProcessUpdate</Type>
    <WriteBackTableCreation>UseExisting</WriteBackTableCreation>
  </Process>
</Batch>
    Processing Dimension 'DLP Incident Message Component Document Format' failed.
        Start time: 3/6/2017 4:35:13 PM; End time: 3/6/2017 4:35:15 PM; Duration: 0:00:01
        Processing Dimension Attribute 'Message Component - Document Format' failed.
            Start time: 3/6/2017 4:35:14 PM; End time: 3/6/2017 4:35:15 PM; Duration: 0:00:00
            Error Messages 1
                Errors in the back-end database access module. The read operation was cancelled due to an earlier error. Errors in the OLAP storage engine: An error occurred while the 'Message Component - Document Format' attribute of the 'DLP Incident Message Component Document Format' dimension from the 'IT Analytics' database was being processed.
        SQL queries 1
            SELECT [MessageComponentDocumentFormatDim].[DOCUMENTFORMAT] AS [MessageComponentDocumentFormatDimDOCUMENTFORMAT0_0]
  FROM 
   (
  
SELECT     DOCUMENTFORMAT
FROM         dbo.vITAnalytics_DLP_MessageComponentDocumentFormatDim
   )
   AS [MessageComponentDocumentFormatDim]
        Processing Dimension Attribute '(All)' completed.
            Start time: 3/6/2017 4:35:13 PM; End time: 3/6/2017 4:35:13 PM; Duration: 0:00:00
Errors and Warnings from Response
    Errors in the OLAP storage engine: An error occurred while the 'Message Component - Document Format' attribute of the 'DLP Incident Message Component Document Format' dimension from the 'IT Analytics' database was being processed.
    Errors in the back-end database access module. The read operation was cancelled due to an earlier error.
    Errors in the OLAP storage engine: An error occurred while the 'Message Component - Document Format' attribute of the 'DLP Incident Message Component Document Format' dimension from the 'IT Analytics' database was being processed.
    Server: The operation has been cancelled.
    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.

Environment

Data Loss Prevention 14.6
IT Analytics 2.6

Cause

With the release of Data Loss Prevention 14.6 the DocumentFormat field in the MessageComponet table of the DLP database been increased in size from 20 characters to 64 characters.

This change affects the following cubes and the Matches measure for these cubes:

• DLP Discovery Incident Details
• DLP Discovery Incident Summary
• DLP Endpoint Incident Details
• DLP Endpoint Incident Summary
• DLP Incident Details
• DLP Incident Summary
• DLP Network Incident Details
• DLP Network Incident Summary

Resolution

This issue has been fixed via the release of an updated content pack for DLP.

You can find the content pack here -->  TECH250545.