Tablespace Summary on DLP Enforce is not loading

Products

• Data Loss Prevention
• Data Loss Prevention Enforce

Issue/Introduction

Tablespace Summary on the DLP Enforce is not loading and you see the below error in the localhost.log file:

22 May 2025 18:07:26,385- Thread: 173 SEVERE [com.vontu.manager.admin.database.TableAllocationManagerListService] Table allocation refresh data procedure failed with error: ORA-06512: at "PROTECT.DDV_SHOW_SPACE", line 1489
ORA-06512: at "PROTECT.DDV_SHOW_SPACE", line 1489

ORA-01400: cannot insert NULL into ("PROTECT"."DDV_TABLE_STATS"."TABLESPACE_NAME")

Environment

16.x

Cause

A procedure to store tables information cannot insert information due to a table outside of DLP database schema which is not assigned to a tablespace.

Resolution

1. Run the below query as protect user on your DB:
   
   select table_name, tablespace_name from user_tables
where temporary='N' and tablespace_name IS NULL;
   
   
2. If the query results tables without a tablespace name, this table likely does not belong to DLP database schema and needs to be dropped to restore functionality.