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
Access denied insufficient privileges error when clicking on entitlement Information icon in RSA Identity Governance and L… Number of Views Intermittent failure of AA to post challenge questions. Number of Views Error message "Access denied - User not a member of any identity source in access policy" in RSA SecurID Access Number of Views Clicking on the 'View the Approval Request' URL from an approval email fails with 'Request could not be handled' in RSA Id… Number of Views How to recover the Application and AFX after an unexpected database failure in RSA Identity Governance & Lifecycle Number of Views
Trending Articles
AFX Server remains in a 'Not running' State, afx status shows 'timed out waiting for AFX applications to start' and mule_e… RSA Release Notes for RSA Authentication Manager 8.8 RSA Authentication Manager 8.7 SP1 Patch 1 Hotfix 1 Downloading RSA Authentication Manager license files or RSA Software token seed records RESTful Web Service Connector capability test fails with unauthorized (401) error when using Basic authentication in RSA G…
Don't see what you're looking for?
