How to delete duplicate Integration services

1. Take back up of the following tables and perform the below delete statements to delete log tables.

DELETE FROM OPB_SESS_TASK_LOG;

DELETE FROM OPB_SWIDGINST_LOG;

DELETE FROM OPB_DTL_SWIDG_LOG;

DELETE FROM OPB_TASK_INST_RUN;

DELETE FROM OPB_WFLOW_VAR_RUN;

DELETE FROM OPB_WFLOW_DEP_RUN;

DELETE FROM OPB_WFLOW_CACHE;

DELETE FROM OPB_WFLOW_RUN;

COMMIT;

2. Execute the below query for the list of integration services list under the repository

SELECT * FROM OPB_SERVER_INFO;

3. Delete the duplicate integration service based on the least server id  

                        (ex: 2 – Integration_ABC, 5 - Integration_ABC, perform delete on 2)

Delete from OPB_SERVER_INFO

where server_id in ( 2,5) -- least server id as it is outdated