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".
IT Analytics for Symantec Data Loss Prevention 2.9.x
The @DLP_Version variable is not being set correctly by the stored procedure spITAnalytics_DLP_CreateViews to interpret the installed DLP version.
To resolve this issue by updating spITAnalytics_DLP_CreateViews, follow this procedure:
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
If you require assistance with this procedure, please open a support case with Broadcom.