Binding size mismatch on the Agent Behavior Events Description dimension causes cube processing to fail

Products

• IT Analytics

Issue/Introduction

Processing the cube SEP Agent Behavior Events fails while processing the Agent Behavior Events Description dimension.

Environment

Release : 2.9.0, 2.9.1

Component :

Cause

This error is caused by the string length of a description value for an endpoint in the Symantec Endpoint Protection (SEP) data source exceeding 256 characters. The dimension expects a string value of 256 characters or less.

Resolution

This issue is resolved by altering the IT Analytics database view vITAnalytics_SEP_AgentBehaviorEventDescriptionDim to truncate description values that exceed 256 characters in length.

To make this change, follow this procedure:

1. Open SQL Server Management Studio (SSMS)
2. In the Connect to Server window, select the Server type 'Database Engine' and provide the name or IP address of your IT Analytics database host (and instance name, if not the default instance) as the Server name
3. Connect using the Authentication method enabled during the installation of IT Analytics
4. Expand the Databases folder under the host name in the Object Explorer pane
5. Locate and expand the IT Analytics database (the default name is 'ITAnalytics')
6. Expand the Views folder
7. Locate the view dbo.vITAnalytics_SEP_AgentBehaviorEventDescriptionDim
8. Right-click this view, select Script View as > ALTER To > New Query Editor Window
9. In the query editor window, edit line 13 by replacing this:

   , DESCRIPTION

   with this:

   , CAST(DESCRIPTION as VARCHAR (256)) AS DESCRIPTION

10. Execute the ALTER statement by pressing the function key F5, clicking the Execute button in the SSMS toolbar, or selecting Execute from the Query menu