cancel
Showing results for 
Search instead for 
Did you mean: 

Archive BW PSA table

Former Member
0 Kudos

Hello,

our internal BW consultant would like that I archive one PSA table with transaction SARA.

SAP-Note 1178734 has been imlpemented.

There is also a  How-TO-DO for archive. https://www.sdn.sap.com/irj/sdn/netweaver (SAP How-to Guides)

System is BI Netweaver 7.31

Archive object is ZRS_PSA.

But it doesn' work.

After starting the write program I get error message

Structure  is not known in the ABAP Dictionary

Job cancelled after system exception ERROR_MESSAGE

Here some screen shots.


Regards,

Reinhard Doeker

Accepted Solutions (0)

Answers (3)

Answers (3)

sander_vanwilligen
Active Contributor
0 Kudos

Hi Reinhard,

Can you please confirm if my reply of Feb 21, 2014 12:34 AM is clear?

If not, please let me know how I can help you further.

Thanks,

Sander

sander_vanwilligen
Active Contributor
0 Kudos

Hi Reinhard,

A different implementation alternative could be the following approach. Introduce a Corporate Memory layer (as suggested in LSA - Layered, Scalable Architecture). Next to the main data flow, you have a second "branch-out" data flow to a write-optimized DSO where you will store your extracted data w/o any transformation. You will build up a complete extraction history here.

As the data volumes can grow here, it would be advisable to archiving on a regular basis and as soon as possible. Preferably to NLS (Near-line Storage).

Furthermore, you can subsequently execute PSA deletion on a regular basis, as part of your housekeeping activities.

Best regards,

Sander

john_hawk
Active Contributor
0 Kudos

Are you using SQL Server as your database?

If so, then the technical name you enters may not be a table, but a view.

One may may not archive from a view!

What's going on?

Other data bases use partitions in PSAs to separate requests. Unfortunately SQL Sever does not support partitioning, so separate tables are created. I believe the "000" is the technical name of the view SE16 uses to view the data by joining the table. Each PSA table contains the same prefix, but is numbered sequentially from xxx0001 to xxx999, (By the way, don't forget to delete requests from the PSA, Once you go over xxx999, the PSA will run out of numbers!)

Search for tables in SE11  beginning with /BIC/B0000564* and see what answers come up. Indentify the physical tables you wish to archive, and try again.

Let me know if this helps!

John Hawk