Red Banner error when trying to access Enforce UI resources

book

Article ID: 206916

calendar_today

Updated On:

Products

Data Loss Prevention

Issue/Introduction

After upgrading DLP 15.5 MP2 you see a RedBanner with the following message...

Error : "An unexpected error has occurred. This could be due to one of the following: 1) Your session timed out and you selected a link that was no longer valid, 2) You used the browser back or forward button placing the system into an inconsistent state, or 3) The system experienced a temporary problem"


This error is generally seen when visiting the "Manage > Data Profiles > Exact Data" page in the Enforce Console.

You can confirm this by checking for the following error message in the "localhost.log" file.
"ORA-00904: "A0"."NUMOFDOCUMENTS": invalid identifier"

Full Error Message:
* SQLException during execution of sql-statement:
* sql statement was 'SELECT A0.viewRowNum,A0.indexedInfoSourceID,A0.infoSourceID,A0.type,A0.informationMonitorID,A0.status,A0.startDate,A0.updatedDate,A0.endDate,A0.version,A0.numOfDocuments FROM LastIndexedStatusByMonitor A0'
* Exception message is [ORA-00904: "A0"."NUMOFDOCUMENTS": invalid identifier
]
* Vendor error code [904]
* SQL state code [42000]
* The root stack trace is --> 
* java.sql.SQLSyntaxErrorException: ORA-00904: "A0"."NUMOFDOCUMENTS": invalid identifier

In the Manager_Jdbc.log 

File: Enforce/logs/debug/manager_jdbc_0.log
Date: 1/19/2021 8:06:23 PM
Level: FINE
Thread: 123
Session: 1
EventType: Failed
Id: 863
Caller: 
Message:  Query failed with error: ORA-00904: "A0"."NUMOFDOCUMENTS": invalid identifier

Cause

When applying the MP2 update, there are some sql updates to theses views. The MP2 package will connect to the database using the following files: OracleHost, OraclePort, OracleUsers

Windows:

Linux:

/etc/Symantec/DataLossPrevention/EnforceServer/15.5/Installation

 

Environment

Release : 15.5 MP2

Component : EnforceMigrationUtility

Resolution

Solution 1: update the files in the following folders and regkeys: oracleHost, oraclePort, oracleUserName, oracleServiceName

windows:

Re-run 15.5 mp2 msp.

Linux:

cd /etc/Symantec/DataLossPrevention/EnforceServer/15.5/Installation
update the oracleHost, oraclePort, oracleUserName, oralceServerName files
cd /opt/Symantec/DataLossPrevention/EnforceServer/15.5/Protect/install/ ;; ./EnforceServerUpdateConfigurationUtility

Solution 2:

go to:C:\Program Files\Symantec\DataLossPrevention\EnforceServer\15.5\Protect\install\sql

You should see a CreateViews.sql file dated 09/10/2019 (the MP2 official build date) that has all the views including the LASTINDEXEDSTATUSBYMONITOR one.
If that is the right file, you should see the NUMOFDOCUMENTS (last) column.
need to 'replay' this CREATE OR REPLACE VIEW LASTINDEXEDSTATUSBYMONITOR block in SQL*Plus to fix the missing columns

 

login to sqlplus and run the createviews.sql

Windows:

Browse to C:\Program Files\Symantec\DataLossPrevention\EnforceServer\15.5\Protect\install\sql with windows explorer

open a Administartor command prompt
@CreateViews.sql
exit sqlplus
restart SymantecDLPManagerService
Verify redbanner is resolved.
 
Linux:
 
cd /opt/Symantec/DataLossPrevention/DetectionServer/15.5/Protect/install
@CreateViews.sql
exit sqlplus
service SymantecDLPManagerService restart
verify the redbanner issue is resolved.

Attachments