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
Identity Data Collector (IDC) collection fails with the error: "ORA-00918: column ambiguously defined" during the Identit… Number of Views Oracle bug ORA-00600 ktecgsc:objdchk_kcbgcur_3 causing the collectors to fail Number of Views Collectors do not pick the new password from the password vault in RSA 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 Certificate is issued with certdn value from CMP request rather than the one in ss.dat when CMP Server is configured with … Number of Views
Trending Articles
RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager 8.9 Release Notes (January 2026) Download RSA SecurID Access Cloud Administration audit logs using Cloud Administration REST API CLU Cloud Administration User Event Log API RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide
Don't see what you're looking for?
