Delete then recreate IME and Directories with the same OID data
book
Article ID: 103792
calendar_today
Updated On:
Products
CA Identity ManagerCA Identity GovernanceCA 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