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
Collections are slow in Indirect Relationship Processing step in RSA Identity Governance & Lifecycle Number of Views Viewing, Downloading or Deleting an existing ASR fails with 'The request could not be handled' error in RSA Identity Gover… Number of Views Changes to the Manual Fulfillment Node in an AFX Fulfillment Workflow are unable to be saved in RSA Identity Governance & … Number of Views RSA Governance & Lifecycle 8.0.0 Deploying Remote Collection Agent and Provisioning Service Guide Number of Views 'Direct Members Missing' column under Role Entitlements tab incorrectly shows deleted, terminated and/or Role Members no l… Number of Views
Don't see what you're looking for?
