PSA table data not deleted even though request is deleted.

[Former Member]

Hi All,

We have recently done BI migration - ( Migrated to new hardware and Operating System from SunOS to Linux).
Now we are facing an issue with the data in PSA table which is not getting deleted. Although the PSA requests are getting deleted but data remains in PSA table.
Also we do not want to deleted whole PSA data , we only have to delete few selected requests from PSA and then reload that data.

Please suggest, how to solve this issue.

Thanks and regards,

Ankita

[Former Member]

Hello,

If you delete requests from the PSA, they remain physically in a partitioned PSA table for the time being.

The requests are first deleted logically (from table RSTSODSREQUEST) and are given a deletion flag in PSA partitioning administration (table RSTSODSPART). You can no longer access these requests.

The requests are not deleted physically from the PSA table until all requests in a partition have been logically deleted and have thus been given the deletion flag in PSA partitioning administration.

Source:

Deleting Requests from the PSA - Modeling - SAP Library

[colm_boyle]

Hi Ankita,

submit a support incident to SAP, there can be many reasons the PSA data is not being deleted, usually the reason is that described by Sjoerd, but to correction needs to be analysed, perhaps changing the active and inactive PSA table by debugging can sort the issue out, or perhaps we can run some correction reports.

Whatever you do it is always advisable to avoid making changes via SE14, this can cause inconsistencies in the request admin tables on the application side,

thanks,

Colm

[Former Member]

Hi,

There should be two PSA tables now, a new and old version.

Make sure to clean the old one, and keep the new version. Even though requests are not visible anymore, the old version is still being read by the DTP. This happens with HANA migrations as well now and then.

Sjoerd

[RafkeMagic]

check the actual table behind it and then delete the requests from that table (via a little ABAP program)

[RamanKorrapati]

Hi,

Can you try to activate PSA table thru SE14.

Later cross check, whether it shows deleted request data or not.

Try to do RSRV tests on PSA table.

Thanks

[Former Member]

Yes we tried to activate PSA table table through SE14, but as we are facing the same issue in case of all data flows in BI for all PSA. Also we can't delete whole PSA data as it contain historical records.

[RafkeMagic]

in the display of your DataSource (RSA1 > DataSources > <select your DataSource & double-click it>) follow menu path: Goto > Technical Attributes

in the PSA Properties block you'll find the (real) PSA table (in the form of /BIC/B*** where *** stands for a bunch of numbers)

double-click it

here you can see all the requests that are still in your PSA

if you want to selectively delete from this table, create an ABAP program for it

otherwise empty the table via process chain with process variant Delete PSA request (set older than date to 31.12.9999) or use SE14 (if you know what you're doing)