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
The RSA Governance & Lifecycle Raw Data table for collection run IDs is empty Number of Views Data purging fails with ORA-02292: integrity constraint (AVUSER.FK_xxxxxx violated - child record found) in RSA Identity G… Number of Views An empty change request is created when attempting to commit a role using the "Actions" button, even though no changes or … Number of Views Review results are removed from the system after deleting a review definition in RSA Identity Governance & Lifecycle Number of Views How to purge table data prior to version 7.0.1 in RSA Identity Governance & Lifecycle Number of Views
Trending Articles
Passwordless Authentication in Windows MFA Agent for Active Directory – Quick Setup Guide RSA Authentication Manager 8.9 Release Notes (January 2026) RSA Authentication Manager Upgrade Process RSA Authentication Manager 8.7 SP2 Setup and Configuration Guide An example of SSO using SAML and ADFS with RSA Identity Management and Governance 6.9.x
Don't see what you're looking for?
