ORA-00942 error when adding a DLP data source connection to IT Analytics

Products

• IT Analytics

Issue/Introduction

When adding a Symantec Data Loss Prevention (DLP) data source connection to IT Analytics (ITA), the following error is returned:

A connection to Symantec Data Loss Prevention database failed.
Exception: Data model creation failed. Possibles [sic] causes include:
The service account may not have sufficient permissions on the IT Analytics SQL database to perform this operation.
The credentials used to traverse this connection or another existing connection of the same data source, may not have sufficient rights to login and read a target database server.

The exception includes the query executed against the OLE DB provider and linked server pointing to the Oracle database server:

Exception: An error occurred while preparing the query "select * from <schema>.ENFORCEVERSION" for execution against OLE DB provider "OraOLEDB.Oracle" for linked server "ITANALYTICS_DLP_ITA_<hostname or IP>_<schema>". OLE DB provider "OraOLEDB.Oracle" for linked server "ITANALYTICS_DLP_ITA_<hostname or IP>_<schema>" returned message "ORA-00942: table or view does not exist".

Note <schema>.ENFORCEVERSION references a different service owner than that specified in the connection wizard.

Environment

Release : 2.9.1

Component : Symantec DLP 15.7 Content Pack

Cause

When adding a new DLP data source connection to ITA, the stored procedure spITAnalytics_DLP_CreateViews executes a query against the Oracle database to identify the owner of the INCIDENT table. When multiple values are returned by this query, the wrong owner may be set and subsequently passed as the parameter for the @DLPDatabaseOwner variable.

Resolution

For assistance, please contact Broadcom support.