1. Take back up of the following tables and perform the below
delete statements to delete log tables.
delete statements to delete log tables.
DELETE
FROM OPB_SESS_TASK_LOG;
FROM OPB_SESS_TASK_LOG;
DELETE
FROM OPB_SWIDGINST_LOG;
FROM OPB_SWIDGINST_LOG;
DELETE
FROM OPB_DTL_SWIDG_LOG;
FROM OPB_DTL_SWIDG_LOG;
DELETE
FROM OPB_TASK_INST_RUN;
FROM OPB_TASK_INST_RUN;
DELETE
FROM OPB_WFLOW_VAR_RUN;
FROM OPB_WFLOW_VAR_RUN;
DELETE
FROM OPB_WFLOW_DEP_RUN;
FROM OPB_WFLOW_DEP_RUN;
DELETE
FROM OPB_WFLOW_CACHE;
FROM OPB_WFLOW_CACHE;
DELETE
FROM OPB_WFLOW_RUN;
FROM OPB_WFLOW_RUN;
COMMIT;
2. Execute the below query for the list of integration
services list under the repository
services list under the repository
SELECT * FROM OPB_SERVER_INFO;
3. Delete the duplicate integration service based on the
least server id
least server id
(ex: 2 – Integration_ABC, 5 – Integration_ABC,
perform delete on 2)
perform delete on 2)
Delete
from OPB_SERVER_INFO
from OPB_SERVER_INFO
where
server_id in ( 2,5) — least server id as it is outdated
server_id in ( 2,5) — least server id as it is outdated