Thursday, June 19, 2014

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