SQL Queries - CAST Central Base - Queries on snapshots - How to manually populate DSS_VIOLATION_STATUSES table for a given snapshot

Purpose of Query

The page details the process to populate the table, when a snapshot is missing from the DSS_VIOLATION_STATUSES table in CB.

Applicable CAST Version

ReleaseYes/No
8.3.x✅
8.2.x✅
8.1.x✅
8.0.x✅
7.3.x✅
7.2.x✅
7.0.x✅

Applicable RDBMS

RDBMSYes/No
Oracle Server✅
Microsoft SQL Server✅
CSS2✅
CSS1✅

Query for CSS

When a Snapshot is missing from the DSS_VIOLATION_STATUSES table in CB, run the following statement to populate this table:

set search_path=XXX_central;
select ADG_COMPUTE_VIOLATION_STATUSES(<SNAPSHOT_ID>);

Query for Oracle

N/A

Query for SQL server

N/A

Notes/comments

Query result example