Integration Processes deleted but still in SXI_CACHE

[Former Member]

I'm trying to understand why old integration processes would still reflect in transaction SXI_CACHE although I have done the following:

1. Deleted them & all references from Integration Repository & Integration Directory.

2. Deleted the Runtime Version from SXI_CACHE.

3. Deleted the old workflows using transaction SWWL.

4. Did delta & full cache refreshes from SXI_CACHE.

How do you do a thorough clean up of old Integration Processes no longer required?

Edited by: Marius de Wet on Sep 29, 2008 4:38 PM

[dharamveer_gaur2]

hi

Can you checked whether the WORK ITEMS is modified and also try SLD Cache Refresh.

To clear the SLD cache, from the Integration Builder main menu, choose Environment ® Delete Cache for SLD Data.

Once we have deleted the cache for SLD data, accessing objects in the SLD may take longer than usual initially.

[dharamveer_gaur2]

Integration process created is also assigned in ID,so delete Integration Process from ID then delete from IR.

Now

Refresh SLD Cache and CPA Cache

http://<host>:5<sys#>00/CPACache/refresh?mode=delta Delta CPA cache refresh

http://<host>:5<sys#>00/CPACache/refresh?mode=full Full cache refresh

SLD Cache - Used to cache the objects you created in SLD to runtime.You can check if SLD cache is updated or not in Integration repostory or Integration Directory.

Edited by: Dharamveer Gaur on Sep 30, 2008 12:37 PM

[Former Member]

Hi,

please check objects tab of ID for the deleted Integration Process, if you find it there then delete it from there activate change list and refresh cache....

[Former Member]

I've checked all objects in ID thoroughly & cannot find anything that still references the old IPs.

[Former Member]

did you check OBJECTS tab of ID??? if not please check there...

[Former Member]

Thank you for all the replies but unfortunately no luck yet.

I've done the following as suggested:

1. Re-created one of the IPs in IR & ID

2. Confirmed that the WORK ITEMS are modified

3. Deleted ID first then IR

4. Refreshed the SLD Cache and CPA Cache

5. Checked the OBJECTS tab of ID

Somewhere there is still a reference that keeps them alive in SXI_CACHE.

[Former Member]

Hi Marius,

I know that you have already done it, but check SWWL transaction again.

When you run the transaction, leave blank all the fields (ID, type, status....)

Maybe there is a work item in an undesired status....

What is the return code of your Integration Process in SXI_CACHE?

Carlos

[Former Member]

Carlos,

I've checked SWWL & deleted all work items just in case. SWWL is now clean.

SXI_CACHE shows it with a return code 2 as I have deleted the runtime version.