SOA 12c Purging

Steps to Implement SOA Purging in 12c Fusion:

1. Shutdown SOA 12c Fusion domain (please follow sequence Managed servers, Admin Server, and Node Manager)
2. Login to SOA 12c Fusion database as SYS and execute the following

NOTE: SOAINFRA schema name could be different to what I am referring here as “SOAINFRA”

GRANT ALTER SESSION TO SOAINFRA

3. Ensure you take the backup of Scripts for Constraint ‘FA_CORR_FLOW_INSTANCE_FK’ under SOAINFRA Schema
4. Log into SOAINFRA schema of SOA 12c Fusion Database and execute below SQL statement

alter table “SCA_FLOW_ASSOC” drop constraint “FA_CORR_FLOW_INSTANCE_FK”;

5. Start SOA 12c Fusion domain (please follow sequence Node Manager, Admin Server, and Managed servers)
6. Run the following query on SOA 12c Fusion Database and note down the count of total instances present

select count(1) from SOAINFRA.SCA_FLOW_INSTANCE;

7. Login to SOA 12c Fusion EM console
8. In Target Navigation pane, Under SOA, right-click on soa-infra (soa server1), Navigate to SOA Administration> Auto Purge

9. Update the Schedule as follows for SOA Flow Purge Job 1 as seen in the screenshot below and then Click on More Auto Purge Configuration Properties

NOTE: The above values can be configured as per your requirement.

10. Click on PurgeJobDetails

11. Expand DELETE_INSTANCES_AUTO_JOB1
12. Set the following parameter values

NOTE: The above values can be configured as per your requirement.

13. Click on Apply to save the changes.

14. To test whether the above schedule purging is working fine or not. We will perform an ad-hoc run by going to SOA Infrastructure > SOA-Administration > Auto Purge and click on Run Now

15. Wait for 15-20 minutes and run the following query on Retail Fusion SOA DB to ensure whether SOA Purge is running fine

select count(1) from SOAINFRA.SCA_FLOW_INSTANCE;

Note: Count from the above step should be relatively lower than one obtained in step 6.