search cancel

Error: "Prerequisites have not been met” when trying to install DLP cubes

book

Article ID: 174598

calendar_today

Updated On:

Products

IT Analytics

Issue/Introduction

When trying to install the Symantec DLP cubes after installing the Symantec Data Loss Prevention Content Pack, the following error is displayed:

Prerequisites have not been met

The following error is also returned by the stored procedure spITAnalytics_DLP_CreateViews:

OLE DB provider "OraOLEDB.Oracle" for linked server "ITANALYTICS_DLP_ITANALYTICS_<hostname>_PROTECT" returned message "ORA-00904: "MESSAGEORIGINATOR"."ENDPOINTUSERNAME": invalid identifier".

Cause

The @DLP_Version variable is not being set correctly by the stored procedure spITAnalytics_DLP_CreateViews to interpret the installed DLP version.

Environment

IT Analytics for Symantec Data Loss Prevention 2.9.x

Resolution

To resolve this issue by updating spITAnalytics_DLP_CreateViews, follow this procedure:

  1. Using SQL Server Management Studio (SSMS), connect to the database engine hosting the ITAnalytics database
  2. In Object Explorer, navigate to Databases > ITAnalytics > Programmability > Stored Procedures
  3. Locate and right-click the stored procedure spITAnalytics_DLP_CreateViews and select Modify to generate an ALTER script in a new query editor window
  4. In the new query editor window, locate the following section of code and edit it per the instructions in red text:
    if @TABLE_COUNT = 0
    begin
    SELECT @DLP_Version = '10.6'
    end
    else 
    begin 
    SET @DLP_OPENQUERY = 'SELECT @DLP_Version = ISNULL(LEFT([VERSION],4), 11.0) FROM OPENQUERY('+ @LinkedServerName + ',''select version from ' + @DLPDatabaseOwner + '.ENFORCEVERSION where ISCURRENTVERSION = ''''Y'''' '')'
    EXEC sp_executesql @DLP_OPENQUERY, N'@DLP_Version decimal(3,1) out', @DLP_Version OUTPUT;

    end

    Set @DLP_Version = 'xx.x'  --Add this line, where xx.x equals the major DLP version integrated (e.g. '15.7')
    if @FirstServer = 0
  5. Execute the script by pressing the F5 key, selecting Execute from the Query menu, or clicking the Execute button in the toolbar

If you require assistance with this procedure, please open a support case with Broadcom.