I am using below query to list out the error message ADDM found on triggering a particular query. However this query results multiple lines of same error message. So I wanted to understand:
- If there is a way to bring the latest error message if any.
- Also I noticed error messages for the queries which were successfully executed and reported SQL results in its last execution. I want to understand why it still shows the error for the query if its last execution was successful?
search IntegrationResult with (traverse DiscoveryResult:DiscoveryAccessResult:DiscoveryAccess:ProviderAccess traverse DiscoveryAccess:Metadata:Detail:SessionResult as sessions) where * has subword 'Oracle.OracleRDBMS_Options.OracleQueries.options_and_packs_usage' show label, failure_reason, #DiscoveryResult:Request:Pattern:Pattern.name as 'Triggering Pattern', #DiscoveryResult:DiscoveryAccessResult:DiscoveryAccess:ProviderAccess.endpoint as 'Endpoint', #DiscoveryResult:DiscoveryAccessResult:DiscoveryAccess:ProviderAccess.#Member:List:List:DiscoveryAccess.#Associate:Inference:InferredElement:Host.name as 'Hostname', #DiscoveryResult:Request:Pattern:Pattern.name as 'Pattern Name', unique(#sessions.message)