000035379 - Data collection failure queries in the RSA Identity Governance and Lifecycle public database schema reference omit collection failures due to circuit breaker issues

Document created by RSA Customer Support Employee on Aug 1, 2017
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000035379
Applies ToRSA Product Set: RSA Identity Governance and Lifecycle 
RSA Version/Condition: 7.0.0, 7.0.1. 7.0.2
IssueData collection failure queries in the RSA Identity Governance and Lifecycle public database schema reference omit collection failures due to circuit breaker issues
CauseThese queries have not been updated to reflect the addition of the circuit breaker feature in RSA Identity Governance and Lifecycle versions 7.0 and up.
ResolutionThis issue is reported in defect ACM-75607 waiting for a fix in a future release.
 
WorkaroundModify the queries as follows:

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 ASC

Attachments

    Outcomes