Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

RSTSODSPART contains wrong PARTNO value

We have having trouble deleting PSA/changelog data. The requests/changelogs we wish to delete are visible in the PSA tree (directory), and exist physically in the PSA tables. But, when we run the deletion job, we receive the following type of job log entry (no runtime error is logged):

DDL time(___1): .........2 milliseconds
Delete request REQU_4DDT1PRMY41NHYNPT2B872PHK from PSA 8BOF_O41_OA : Error - subrc: 2

Checks using RSRV, RSAR_PSA_PARTITION_CHECK, and SAP_PSA_PARTNO_CORRECT all come back clean.

RSAR_PSA_CLEANUP_DIRECTORY contains the following entries:

Request : REQU_4DDT1PRMY41NHYNPT2B872PHK deletion flag inconsistent in RSTSODSPART
Orphaned RSTSODSPART entries detected
Partition 0001 not dropped

Also, I have noticed that the PARTNO values in RSTSODSPART for the affected requests do not correspond to the PARTNO values in the actual PSA tables. In every case, the PARTNO value in RSTSODSPART is 2, whereas the PARTNO value in the PSA table is 1.

I have not attempted running RSAR_PSA_CLEANUP_DIRECTORY in repair mode because the logs indicate no auto correction is available for inconsistent RSTSODSPART entries. I'm tempted to try, however.

Is there any risk to running RSAR_PSA_CLEANUP_DIRECTORY in repair mode in this circumstance? Any other thoughts on how to resolve this problem?



P.S. We are running BI 7.0, SP15, on Oracle 10.2.

P.P.S. I have already consulted the following OSS Notes: 733371, 1044023, 1063105, 1102626, 1150724.

Not what you were looking for? View more on this topic or Ask a question