Delete then recreate IME and Directories with the same OID data
Article ID: 103792
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
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
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
Feedback
Yes
No
Powered by
