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:

At 5/04/2019 , Blogger sandeep saxena said...

Good idea. This information is more useful for my study. I like it very much.
Manual Testing Training in Chennai
testing courses in chennai
Manual Testing Training in T Nagar
Mobile Testing Training in Chennai
Mobile Testing Training
Drupal Training in Chennai
Photoshop Classes in Chennai
Manual Testing Training in Chennai

 
At 5/07/2019 , Blogger divya said...


Great info. The content you wrote is very interesting to read. This will loved by all age groups.
Angularjs Training in Chennai
Angularjs Course in Chennai
CCNA Training in Chennai
Salesforce Training in Chennai
Angular5 Training in Chennai
Angular6 Training in Chennai
Angular7 Training in Chennai
Angularjs Training in Chennai
Angularjs Course in Chennai

 
At 10/17/2019 , Blogger Chris Hemsworth said...

The article is so informative. This is more helpful for our
best software testing training in chennai
best software testing training institute in chennai with placement
software testing training
courses

software testing training and placement
software testing training online
software testing class
software testing classes in chennai
best software testing courses in chennai
automation testing courses in chennai
Thanks for sharing.

 
At 10/18/2019 , Blogger zuan said...

Thanks for sharing an informative blog keep rocking bring more details.I like the helpful info you provide in your articles. I’ll bookmark your weblog and check again here regularly. I am quite sure I will learn much new stuff right here! Good luck for the next!
Web Designing Training Institute in Chennai | web design training class in chennai | web designing course in chennai with placement
Mobile Application Development Courses in chennai
Data Science Training in Chennai | Data Science courses in Chennai
Professional packers and movers in chennai | PDY Packers | Household Goods Shifting
Web Designing Training Institute in Chennai | Web Designing courses in Chennai
Google ads services | Google Ads Management agency
Web Designing Course in Chennai | Web Designing Training in Chennai

 
At 10/18/2019 , Blogger Naveen S said...

This is the first & best article to make me satisfied by presenting good content. I feel so happy and delighted.By Learn Digital Marketing Course Training in Chennai it will help to get Digital Marketing Training with Placement Institute in Chennai. If you Learn Social Media Marketing Training with Placement Institute in Chennai, you will get job soon.

Learn Best Digital Marketing Course Training in Chennai in professional institute to get reputed job.

 

Post a Comment

Subscribe to Post Comments [Atom]

<< Home