Data collection failure queries in the RSA Identity Governance and Lifecycle public database schema reference omit collection failures due to circuit breaker issues
Originally Published: 2017-07-14
Article Number
Applies To
RSA Version/Condition: 7.0.0, 7.0.1. 7.0.2
Issue
Cause
Resolution
Workaround
Change from
SELECT 'IDC' AS COLLECTOR_TYPE, NAME AS COLLECTOR_NAME,
START_TIME, END_TIME
FROM IDENTITY_COLLECTION WHERE STATUS IN ('Failed', 'Aborted')
UNION
SELECT 'ADC' as COLLECTOR_TYPE, NAME AS COLLECTOR_NAME,
START_TIME, END_TIME
FROM ACCOUNT_COLLECTION WHERE STATUS IN ('Failed', 'Aborted')
UNION
SELECT 'RDC' AS COLLECTOR_TYPE, NAME AS COLLECTOR_NAME,
START_TIME, END_TIME
FROM ROLE_COLLECTION WHERE STATUS IN ('Failed', 'Aborted')
UNION
SELECT 'EDC' AS COLLECTOR_TYPE, NAME AS COLLECTOR_NAME,
START_TIME, END_TIME
FROM ENTITLEMENT_COLLECTION WHERE STATUS IN ('Failed', 'Aborted')
UNION
SELECT 'MAEDC' AS COLLECTOR_TYPE, NAME AS COLLECTOR_NAME,
START_TIME, END_TIME
FROM MULTI_APP_COLLECTION WHERE STATUS IN ('Failed', 'Aborted')
UNION
SELECT 'DADC' AS COLLECTOR_TYPE, NAME AS COLLECTOR_NAME,
START_TIME, END_TIME
FROM DATA_ACCESS_COLLECTION WHERE STATUS IN ('Failed', 'Aborted')
ORDER BY START_TIME DESC, COLLECTOR_TYPE ASC, COLLECTOR_NAME ASC
Change to
SELECT 'IDC' AS COLLECTOR_TYPE, NAME AS COLLECTOR_NAME,
START_TIME, END_TIME
FROM IDENTITY_COLLECTION WHERE STATUS IN ('Failed', 'Aborted','CircuitBreaker')
UNION
SELECT 'ADC' AS COLLECTOR_TYPE, NAME AS COLLECTOR_NAME,
START_TIME, END_TIME
FROM ACCOUNT_COLLECTION WHERE STATUS IN ('Failed', 'Aborted','CircuitBreaker')
UNION
SELECT 'RDC' AS COLLECTOR_TYPE, NAME AS COLLECTOR_NAME,
START_TIME, END_TIME
FROM ROLE_COLLECTION WHERE STATUS IN ('Failed', 'Aborted','CircuitBreaker')
UNION
SELECT 'EDC' AS COLLECTOR_TYPE, NAME AS COLLECTOR_NAME,
START_TIME, END_TIME
FROM ENTITLEMENT_COLLECTION WHERE STATUS IN ('Failed', 'Aborted','CircuitBreaker')
UNION
SELECT 'MAEDC' AS COLLECTOR_TYPE, NAME AS COLLECTOR_NAME,
START_TIME, END_TIME
FROM MULTI_APP_COLLECTION WHERE STATUS IN ('Failed', 'Aborted','CircuitBreaker')
UNION
SELECT 'DADC' as COLLECTOR_TYPE, NAME AS COLLECTOR_NAME,
START_TIME, END_TIME
FROM DATA_ACCESS_COLLECTION WHERE STATUS IN ('Failed', 'Aborted','CircuitBreaker')
ORDER BY START_TIME DESC, COLLECTOR_TYPE ASC, COLLECTOR_NAME ASCRelated Articles
RSA Governance & Lifecycle 8.0.0 Public Database Schema Reference Guide Number of Views Poor performance when processing SoD Rules that use a Correlation Attribute in RSA Identity Governance & Lifecycle Number of Views Overview of Public Database Schema Views in RSA Identity Governance & Lifecycle Number of Views Identity Data Collector (IDC) collection fails with the error: "ORA-00918: column ambiguously defined" during the Identit… Number of Views RSA Identity Governance and Lifecycle 7.1 Public Database Schema Reference Number of Views
Trending Articles
RSA Authentication Manager 8.9 Setup and Configuration Guide How to 'Trust' the RSA Authentication Manager Security Console Self-Signed Root CA certificate and prevent Cert warnings. RSA Authentication Manager 8.9 Release Notes (January 2026) Configure RSA Authentication Manager as a Secure Proxy Server for Cloud Access Service RSA Authentication Manager Upgrade Process
Don't see what you're looking for?
