Delete then recreate IME and Directories with the same OID data

book

Article ID: 103792

calendar_today

Updated On:

Products

CA Identity Manager CA Identity Governance CA Identity Portal

Issue/Introduction


We need to delete the IME and user directories then recreate them with the same OID We need to do this to preserve the task persistence data from the old IME

Environment

Release:
Component: IDMGR

Resolution

This doc does assume that the steps are being run by the DBA
This is not a recommended procedure and should ONLY be used when the data is absolutly needed.

If the Current IME OID is 22
For Oracle:
we can run the select statement
IM_ENVIRONMENT_JDBC_SEQ.CURRVAL SELECT FROM DUAL;

To validate current value Should be 22 (this can change due to cacheing, if the number is way off, add the cache value.)
 then run
ALTER SEQUENCE IM_ENVIRONMENT_JDBC_SEQ INCREMENT by -1;

This should make the SEQ 21, so that 22 is available for creation.

The SEQUENCES for user dirs
SEQUENCE IM_DIRECTORY_SEQ
SEQUENCE IM_DIR_CONNECTION_SEQ