Skip to Content
author's profile photo Former Member
Former Member

Question : PSA Table Data Deletion

Hi,

I have deleted PSA data request of 0GENDER_TEXT. But data for that request is still in PSA Table /BIC/B0000509000. This Data is daily Uploaded through Process Chain in the Every nihgt.My point is that it is blocking memory and not required at all.

An other the example of 0PA_C01 it is full update , in the cube we are deleting before uploading ,but in PSA it is appending by every update. If we are deleting from PSA Request still data for that request is in PSA Table /BIC/B0000521000 & /BIC/B0000522000.

Regards,

Anand Mehrotra.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 01:58 PM

    Hi

    1.Y dont you delete those PSA table & check whether data is deleted or not??.Actually those are PSA tables..but still now I am wondering what is the purpose of requests deletion.

    2. You are deleting the data in the cube & so ofcourse you see data in PSA as you mean in 2nd Q...

    hope this helps

    thanks

    BI Learner

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 18, 2008 at 04:19 PM

    In BW system, run this program RSAR_PSA_CLEANUP_DIRECTORY with

    Persistent Staging Area Radio Button and Repair check box 'ON' (checked) and

    enter u r PSA table name in Technical ODS Name box.

    Then schedule data loads

    -


    If that doesn't work, try to delete PSA table data from SE14...and retry the loads

    https://forums.sdn.sap.com/post!reply.jspa?threadID=1062342

    https://forums.sdn.sap.com/post!reply.jspa?threadID=984263

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 18, 2008 at 08:09 PM

    Hi,

    PSA stands for Persistent Staging Area ... you can read that as "Temporary Storage". Meaning you can hold data in the form of the transfer for some time.

    If you load data and the infopackage indicates load to the PSA, then you will be storing data in the PSA on every run. If you check Data Targets only, then you will bypass the PSA and no longer store data in it. For me, on Full Loads for Master Data, I always bypass the PSA since I am getting the full dataset on every run.

    If I am loading deltas, or it is important to retain a snapshot of a full load on a specific date (month end for example), I will store the data in the PSA for a time until I feel comfortable that I do not need to go back to it for any reason (bad deltas, reloads, etc...). In the case of PA, you may need a headcount snapshot at the end of the month, so you may want to keep that data.

    Cubes vs. PSA's: you can delete the data from a cube and the PSA data will still be available. This is evidenced in the "reconstruct" tab where you can reload a request from the PSA.

    The best way to delete PSA data for good is to go into the PSA tab under Modeling and do a deletion from those screens.

    Good Luck,

    Brian

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.