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
Rules are not triggered after unification run in RSA Identity Governance & Lifecycle 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 Viewing, Downloading or Deleting an existing ASR fails with 'The request could not be handled' error in RSA Identity Gover… Number of Views Review results are removed from the system after deleting a review definition in RSA Identity Governance & Lifecycle Number of Views Risk Data Processing run fails in RSA Governance & Lifecycle Number of Views
Trending Articles
Unable to login to RSA Authentication Manager Security Console as super admin Authentication Manager Security Console and Operations Console Inaccessible After Certificate Update Authentication Manager Administration Server with operations console service Fails to Start with "No config.xml Was Found"… RSA Authentication Manager Upgrade Process RSA SecurID Software Token Distribution to Android from RSA Authentication Manager 8.1
Don't see what you're looking for?
