Overflow sww_cont business partner workflow TR

[jrgen_link]

HI , we are using the standard workflow WS20000263 out of treasury now on HANA1909. so far it was working fine because we stopped it for the purpose of migration but this time it was forgotten to stop for some 1000 vendors to some 100 companies. The result is the table sww_cont gets an overflow because all workitems of the partners are growing dramantously . up to 50.000 entries for key: subobject and data "und" . any hint to solve the problem ? deleting the "und" by the SAP_WAPI_WRITE_CONTAINER ?

thanx

[jrgen_link]

Hi

the solution can be found in the knowledge base by the keywords also used here and it is corrected by hint 3159396. Small things can really getting ....

Thanx for assistance here

[jrgen_link]

Hi Pavan,

thanx for your grreat support. I just was to fast checking the results. The processing just seems to take time.

So on production we could start with the oldest WF and SWWL is checking if them correct or corruoted by the overflow on the tabel sww_cont. Then the numbers of entries should decerase by the huge number of lines for subobject. .

It is not "free" the memory space on HANA DB of Production. . So next question is : it is done by the jobs running for WF and they still busy to handle the crashed Items from the mass creation before and after that would be settled then going on to the deletion
or
just an issue of the HANA adminstration.

thanx

[jrgen_link]

Hi Pavan thanx for your answer

I have tried it in a test system. each change of the business partner seems to create 3 ID's . In the SWWL transaction one out of the 3 ID's are listet even I removed all other selections at start mask for the run only giving a range of xx20 to xx30 then listing is 21 , 24, 27, 30 . I could start the deletion of one of the listed ID and it empties the container of it. but the high number of the subobjects are belonging to the not listed ID . they remain the same . When I try to get access to the ID via a list it just causes a shortdump .

thanx

Jurgen

[bpawanchand]

Hi Jurgens,

I am I could not get you. Can you share some scree shots which can help me to understand the issue?

Thanks

Pavan Bhamidipati

[bpawanchand]

Hello Jurgens

What I understand from the question is the table SWW_CONT is becoming a bottle neck due to entries of the workflow template. I guess if it is ok to delete the instances of the workflow then I would try to check like below.

1. First Ill get all the active instances of the workflow by using SWI6 transaction. For your workflow I guess The BOR is TRLOAPPROV. and I download the list of work items which are still running active and in process.
2. Select one work item from the above list and validate the SWW_CONT entries by querying the table from Se16.
3. The use the same work item ID and logically delete the work item by using SWWL transaction. After deleting it check in the table SWW_CONT if the entries are deleted or not.

Thanks

Pavan