OIM_TaskArchival.sh Does Not Seem To Remove Any Rows When There is Large Number Records (In Million) To Archive (Doc ID 2233281.1)

Last updated on MAY 10, 2023

Applies to:

Symptoms

After running OIM_TaskArchival.sh  to purge and archive the OSI table within the OIM Database.  The output shows that 2.1 million rows will be deleted. However, upon querying the table, the same number of rows still exist including those in the date range that are been trying to remove.

EXPECTED BEHAVIOR
-----------------------
After OIM_TaskArchival.sh should remove all the records.

STEPS
-----------------------
The issue can be reproduced with the following steps:

1. Ensure that the Oracle Identity Manager database is available and that no reconciliation processes are running.

2. Run the following commands to set execution permission for the oim_recon_archival.sh file and to ensure that the file is a valid Linux or UNIX text file:
 
    chmod 755 path/oim_recon_archival.sh
 
   dos2unix path/oim_recon_archival.sh

3. Run the path/oim_recon_archival.sh file to run the utility.

4. Enter values for the following parameters when prompted:
           Oracle home directory
           Oracle Identity Manager database user name and password

5. Enter the reconciliation creation date in the YYYYMMDD format. All records on or before this date with required status value are archived.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.