Delete PSA Issue

[sap_cohort]

Hi, When we try to delete our PSA we receive the following errors with no good context.

- DDL time(___1): ........69 milliseconds Message no. DA093

- Delete request REQU_4DF2URKNZGH72J8Q8QQCIW79Q from PSA 2LIS_13_VDITM_BA: Error - subrc: 2 Message no. RSM1156

When we run the RSAR_PSA_CLEANUP_DIRECTORY Program we get the following:

- PSA: 2LIS_13_VDITM_BA Version 000 DB-table /BIC/B0000121000 already deleted

Message no. BL001

- Request already deleted on database:REQU_4DF2URKNZGH72J8Q8QQCIW79Q, Created on:20090408 Message no. BL001

Can anyone help me get past this PSA Delete Issue?

Thanks!

[Former Member · Accepted solution]

Hi Kenneth,

did you already try transaction rsrv? There you can find a consistency check for PSA tables.

[sap_cohort · Accepted solution]

Hi, I just did the RSRV check on the PSA table and it returns all green.... Thanks. Let me know if you have any other ideas?

Thanks

[Former Member · Accepted solution]

Please check below notes

Note 628215 - P14:Delete PSA:Inadequate error messages issued for errors

Note 1150724 - Consolidated note on the check & repair reports for PSA

Regards,

Kams

[sap_cohort]

I am having SAP Follow up on this issue....

[Former Member]

Hello Kenneth,

We have encountered the same issue.

When we try to delete PSA we receive following error.

- DDL time(___1): ........1 milliseconds

Kindly let us know how did you resolve the issue.

Thanks and Regards

Shilpa

[sap_cohort]

Here is the solution! They just got back to me with this...

Good Luck...

Note 1063105 - Program RSAR_PSA_CLEANUP_DIRECTORY

[Former Member]

We too are having the issue. What where selected options under the Processing Option and the Check Options.

Thanks.

Bob Sonntag

[Former Member]

Helpful Hints:

We are running DB2 and SPS18,

OSS Notes:

0001063105

0001269790

0001299635

0001328848

0001313895

Reports:

RSAR_PSA_CLEANUP_DIRECTORY

Z_RSAR_PSA_PHYSICAL_DELETION

SAP_PSA_PARTNO_CORRECT

Z_RSAR_RSTSODSPART_RECORDS

One has to be little patient since it takes a little while to get the application tables in sync with the db thru the Reports

Also DDL Time for delete content step in Process chain still fails but if one repeats that steps, it turns green and PC moves on.

GoodLuck.

Edited by: MANISH ANGARAI on Oct 13, 2009 1:30 PM

[mr_v]

If u have 'MSSQL' database systems, check weather the following note applicable

1044023 & 1102625

[mr_v]

If u use 'MSSQL' database systems, check the following SAP notes weather applicable

1044023 & 1102625