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
Last Modified: 2023-10-06
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
Installation fails with 'Reference data is not available for verifying prerequisites on this operating system distributio… 37Number of Views Collector circuit breaker tripped by rejections in RSA Via Lifecycle and Governance 270Number of Views RSA Identity Management and Governance 6.9.1 P12 Active Directory Identity Data Collector (IDC) collection fails with "Unp… 89Number of Views MultiApp collector is failing at task 3 with ORA-01400 error in RSA Governance & Lifecycle 27Number of Views Active Directory Collector fails with Unprocessed Continuation Reference(s) 29Number of Views
Trending Articles
RSA Authentication Manager 8.9 Patches and Hotfixes Readme RSA MFA Agent 2.5 for Microsoft Windows Installation and Administration Guide RSA-2026-24: RSA Authentication Manager Security Update for Third-Party Component Vulnerabilities IDR SSO - Step 3: Deploy the Identity Router RSA Authentication Manager 8.9 Setup and Configuration Guide
Don't see what you're looking for?