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
How to configure a global default Circuit Breaker threshold value in RSA Identity Governance & Lifecycle Number of Views Raw Data counts and Task Result counts in Role Collector data runs are sometimes inconsistent in RSA Identity Governance &… Number of Views After successful Account data collection, Custom Account Integer Attribute value is not displaying under Accounts tab in R… Number of Views Cannot avoid circuit breaker abort for scheduled Identity Data Collector (IDC) collections in RSA Identity Governance & Li… Number of Views Collector circuit breaker tripped by rejections in RSA Via Lifecycle and Governance Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.9 Release Notes (January 2026) An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x RSA Authentication Manager 8.8 Setup and Configuration Guide
Don't see what you're looking for?
