Workaround | Modify 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 |