unable to create database report in Enforce UI
search cancel

unable to create database report in Enforce UI

book

Article ID: 281576

calendar_today

Updated On:

Products

Data Loss Prevention

Issue/Introduction

When selecting the Get Full Report in System>Database>Tablespace Summary. The report will not generate. 

Environment

Rhel 7.x

DLP 16.x ,15.x 

Cause

in the tomcat logs we see the following:


Thread: 307
Level: SEVERE
Source: com.vontu.manager.admin.database.DatabaseDiagnosticsReportLoader
Message: Error encountered while fetching database diagnostic reports data. Caught exception trying to fetch database diagnostics report data: Cannot run program "sqlplus": error=2, No such file or directory

In the service account the oracle environment variables are not set or are incorrectly set:

  • ORACLE_HOME
  • ORACLE_SID

Resolution

1. find the service user in terminal:

 ps ax o user:16,pid,pcpu,pmem,vsz,rss,stat,start_time,time,cmd | grep -i symantec | awk {'print $1" "$11'}

2. Edit the server users .bash_profile and add the ORACLE_HOME and ORACLE_SID environment variables

3. To reload the changes by running "source /home/<users>/.bash_profile" 

4. Restart the DLP services so the service account sessions load the new environment variables

5. re run the Get Summary reboot button in the Enforce UI and the report should generate.