Cannot Delete Messages in XI (PI)
We are using SAP NetWeaver PI v7.00 SP15. Our PSAPSR3DB tablespace is growing and we can't delete the messages. If I run RSXMB_SHOW_REORG_STATUS it shows 615,086 asynchronous messages not in retention period (can be deleted). There are only 1314 messages in the retention period. There are 113,759 messages without errors to be flagged.
If I run RSXMB_DELETE_MESSAGES through TCODE SXMB_ADM I get these results:
07.10.2008 13:10:21 Job started
07.10.2008 13:10:21 Step 001 started (program RSXMB_DELETE_MESSAGES, variant &0000000000027, user ID DBARBOUR)
07.10.2008 13:10:34 0 XML messages deleted
07.10.2008 13:10:34 Step 002 started (program RSXMB_TABLE_SWITCH, variant &0000000000027, user ID DBARBOUR)
07.10.2008 13:10:34 Job finished
I'm working through Note 872388 Troubleshooting Archiving and Deletion in XI 3.0 / PI 7.0 and others, but nothing is working.
I've even tried using the http screen suggested in 807615, but still can't get rid of the old messages. My configuration is set to 'simple" (without table switch?) so it's somewhat puzzling the deletion job tries the switch, although I'm not sure if that's signifigant.
Can someone help me out here?