ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

query request ID

book

Article ID: 132791

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal

Issue/Introduction



IDM/Sigma r12.6 SP4. How can I find IDM task ID(e.g. 375fb029-a6e65ae0-091cd777-dae9ea) by Identity portal request ID(e.g. 3241). Currently only way is using IDP admin UI, is there a way to query database?

Environment

Release:
Component: SIGMA

Resolution

select BACKENDREQUESTID, status from request_backend where rootid in () REQUEST_BACKEND table has the mapping with the IDM task and IP request, where BACKENDREQUESTID column holds IDM task ID, status holds request status and rootid is the request ID we see in the identity portal. Note: We see BACKENDREQUESTID value only if a request is sent to IDM. If a request is failed due to an error in the IP itself then we see 'null' value for it. Hence check request status as well.