Deleting data from Workflow tables throws error in Identity Governance & Lifecycle
Originally Published: 2018-05-28
Article Number
Applies To
RSA Version/Condition: 7.0.2 P03
Issue
DELETE FROM WP_USER_DATA WHERE (PROCI_ID, PROCI_DB) IN (SELECT PROCI_ID,PROCI_DB FROM GTT_WFDATARETENTION_IDS) AND
VAR_NAME IN (SELECT VAR_NAME FROM T_AV_UD_VAR_REMOVE);
V_CUSTOM_MESSAGE := 'Pruned '||SQL%ROWCOUNT||' rows of user data stored in T_AV_UD_VAR_REMOVE';
DATABASE_LOGS.INFO_INFO(G_CTX, IN_RUN_ID, G_PKG_NAME, V_PROC_NAME,V_CUSTOM_MESSAGE); failed with an index key not found error.
SQL Error: ORA-08102: index key not found, obj# 265832, file 12, block 1844690 (2)
08102. 00000 - "index key not found, obj# %s, file %s, block %s (%s)"
Cause: Internal error
Cause
Resolution
alter index WP_USER_DATA_IX01 rebuild;
Related Articles
Account summary table export includes the HTML tags that construct the account mapping button in RSA Identity Governance &… 39Number of Views Rules are not triggered after unification run in RSA Identity Governance & Lifecycle 80Number of Views Discovery Endpoints 115Number of Views Error while exporting Request Monitoring Policies in RSA Identity Governance & Lifecycle 28Number of Views Entitlement View does not scope correctly when triggered via request buttons in RSA Identity Governance & Lifecycle 16Number of Views
Trending Articles
Download RSA SecurID Access Cloud User Event audit logs using Cloud Administration REST API CLU RSA Authentication Manager Upgrade Process RSA MFA Agent 2.3.6 for Microsoft Windows Installation and Administration Guide RSA Authentication Manager Patch Updates How to implement SAML SSO Authentication with Microsoft Azure Active Directory and RSA Identity Governance & Lifecycle
Don't see what you're looking for?