Truncate TABLE PSA table-index part

[Former Member]

Dear all,

I have a doubt about the truncate action on BW of PSA table.

To speed the activity and empty some tablespace I have truncated for example the PSA /BIC/B0000025000 and all table and index parts have emptied, so, on the contrary of disk space, the table part and index part from 00001 to 00050 for example are no longer used and the next uploads creates partition 00051.

The question is: I must drop all index and table part previously emptied?

If yes a must keep in mind some indications?

I could have some problem to leave this table and index part empty, for example about performance or inconsistence?

There is some contraindication to truncate PSA?

Can i use program 'RSAR_CLEANUP_PSA_DIRECTORY' to delete its?

Thanks for your help.

Best Regards

Daniele

[Former Member]

Hi Kaushal,

i have solved my problem.

For the error:

Fatal error occured, DO NOT USE correct option

For errors 'wrongly present in partition' refer to NOTE 849857 / 992248

of report RSAR_PSA_CLEANUP_DIRECTORY; in the rest of log (transaction SLG1) we can find this entries:

Request : ODSR_48YLZTXG8FFEOU547U93MMQEF missed in partition 0001

Request : ODSR_48YLZTXG8FFEOU547U93MMQEF stored in wrong partition 0000

that must be delete manually.

After that we can execute the report RSAR_PSA_CLEANUP_DIRECTORY in repair option.

Best Regards

Daniele

[Former Member]

Hi,

check Note 733371 - CleanUp for inconsistent PSA directory entries

might helps you

regards,

kaushal

[Former Member]

Hi Kaushal,

thanks for your answer.

I have executed program mentioned in oss note 733371.

After the execution of RSAR_PSA_CLEANUP_DIRECTORY

some errors have found:

in the head of log there are this two entries:

Fatal error occured, DO NOT USE correct option

For errors 'wrongly present in partition' refer to NOTE 849857 / 992248

the rest of log this kind of errors:

Request : ODSR_47KKTL3NMVNZPGY17C4POEYAV missed in partition 0015

The oss note 849857 is for release lower of mine, the note 992248 is for my release, its talks about a program 'SAP_PSA_ZEROCORRECT' imported automatically with SP 11, i have level 13 os SP BI but i didn't find that program,

do you have some idea about that?

After execution of report RSAR_PSA_CLEANUP_DEFINITION (only check)

I have this error:

No DDIC Table Exists for PSA: ZEDS_NOT_T_BA Vrs. 000

There Is No Active DDIC Table: /BIC/B0000852000

Do you think that if i run RSAR_PSA_CLEANUP_DEFINITION with repair object i can resolve all my problem visualized for report RSAR_PSA_CLEANUP_DIRECTORY either? Or before in must execute RSAR_PSA_CLEANUP_DIRECTORY whit repair option?

Thanks for your help

Ciao

[Former Member]

Hi,

its talks about a program 'SAP_PSA_ZEROCORRECT' imported automatically with SP 11, i have level 13 os SP BI but i didn't find that program, 
do you have some idea about that?

992248 not doesn't tells that SAP_PSA_ZEROCORRECT is available with SP11.

SAP_PSA_ZEROCORRECT is attached to sap Note 856097 - Check and repair program for Note 849857

first implement sap note 856097 using snote, you get that program, execute the program and check the result.

regards,

kaushal