When is it appropriate to delete requests from the PSA

[Former Member]

Hi All

I am using BW3.5. I we frequently are getting problems due to our table spaces being full. This in general is caused by the volume of requests in the PSA. What I want to know is what is safe to delete and what do you really want to keep? Are there any guidelines to help determine this.

I don't want to delete unknowingly something that I may need in the future.

Many Thanks

Tim

[Former Member · Accepted solution]

Right Pradhiba, so you are saying if I delete the PSA requests I won't be able to reconstruct my data should I ever need to delete it e.g. for a transport which includes a change to the structure of an info provider, perhaps a deletion of an info object.

What are the dangers of loosing the ability to reconstruct?

Our system is relatively new so an experiences would be greatly appreciated.

[Former Member · Accepted solution]

in that case, yes you wont be able to reconstruct. instead u might have to move the data to a temporary ODS and then move it back.

[Former Member]

For all who are replying on how to delete PSA requests, that is not really my question. I am fully aware of the how. I'm more interested in frequency, when it is safe to delete them and which requests I should really keep because if I delete them I may get problems in the future.

[Former Member]

Arun

I work for an insurance company. Some of our claims can be open for many months and so subject to changes. Are you saying that if a record is likely to be changed we must keep the previous PSA requests?

Thanks

Tim

[Former Member]

no. PSA data is required only if you are going to delete the request from ODS and reconstruct it. otherwise changes can be loaded without old PSA data.

[Former Member]

Hi,

Change the Process chain steps For all Full uploads to following

1. Delete PSA Data.

2. Delete Content of Data Target

3. Schedule info package.

Hope that helps.

Regards

Mr Kapadia

[Former Member]

Create a process chain, add the process type Deletion of Requests from PSA and configure it to delete requests older than 5 days or as per your need. Add all the infoobjects, infosources and infopackages where PSA data needs to be deleted regularly.

Activate and schedule this process chain to run daily

So only last 5 days of PSA data will be retained if you had said 5.

regards,

Pradhiba

[former_member184494]

Tim,

It again depends on your data retention policy ....

Ideally it should be one month's data in PSA but depending on volumes - you can either drop it immediately or look at periods of 1 week / 1 fortnight etc....

Also you will have to look at any reload / changes to previous dates records that come - i.e the time period for a record to stabilize -- something like a sales document can be edited for a max of upto 1 week after which it is deemed complete and closed if it is kept open.... which would mean that having a PSA of 1 week should suffice...

Arun