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

5 comments:

  1. 먹튀사이트 잡는 고릴라의 먹튀검증 통과 메이저토토사이트 안전놀이터 추천 훌륭한 먹튀검증을 통한 안전토토사이트를 추천합니다 고릴라만의 검증 시스템은 특별합니다 전세계적인 먹튀검증을 인전받은 최고의 메이저사이트 추천을 합니다 자세한 내용은 내 웹 사이트를 방문하십시오 먹튀검증.

    ReplyDelete
  2. Nice post. Thanks for sharing! I want people to know just how good this information is in your article...Every candidate has the anxiety after the participation of any competitive Exam to Check their Sarkari Result Upcoming.

    ReplyDelete
  3. Try to establish a long term relationship with the Salesforce Integration Consultant and consider the effectiveness of their ongoing support before deciding to make them your future Salesforce consulting partner based on the future improvements. Salesforce interview questions and answers

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete