on 10-14-2008 6:33 PM
I have a scenario...where i am doing RFC to file.
I transfer some bank details from RFC to File.....My problme here is...the data which i sent should not stay in XI and should be deleted immediately...I know archiving and deleting concept can be used.....but i need only for this single interface.....how can this be done...
please some one guide me......
Hi,
>I transfer some bank details from RFC to File
You can Lock in Sxmb_moni & The Successful messages passing SAP XI / PI are stored in Table for some days ( As a default 30 days ) but we cannot read those messages in the Table because It is stored in Compressed mode / hash code / binary.
Cheers
Agasthuri Doss
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Harsha
I have performed this by creating a report which is nothing but a copy of RSXMB_SELECT_MESSAGES and with this i selected all messages where "Sender service = My Sender service" and deleted the records from the table. This report i executed along with receiver maintaining order at runtime
For me it was an encrypted message that need to be read from FTP location still we need to delete it -
I dont know this will help you or not
Thanks
Gaurav
Edited by: Gaurav Bhargava on Oct 15, 2008 4:50 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI
We created copy of RSXMB_SELECT_MESSAGES as this will check for authorizations, status etc.
Main requirement was to remove data after taking backup from SXMSPMAST. You can find the messages for a sender or receiver, message type (A or S), time range and QOS etc. My requirement was very specific and i had to delete report. and keep the delta.
As my ERP was using PowerConnect to a DW and i need to remove data from SXMB_MONI only and need to keep the backup(Delta).
We achieved in this manner..
I think this could help you understandl
Thanks
Gaurav
Gaurav,
Can you please elabaorate the steps u did for deleting messages in sxmb_moni...
as for ur answer, I exceuted the program,which would take me to SXMB_MONI...after that what should i do...?
i still didnt get you....Can you please explain what needs to be done step by step....
i even checked the table SXMSPMAST but couldn't find any answer
Edited by: Harsha reddy on Oct 15, 2008 2:47 AM
Hi Harsha
Cannot go to code level details
I would suggest go to SE11 and use SXMS* and look for XI and Integration engine tables.
You can use this to remove the content of messages from SXMB_MONI as well as RWB logs.
Steps can be
1. Look for the report this will allow you to get the authorization etc. I used it because some people were authorized to see the content and in that case i should not delete it.
2. Look for the tables that store various set of data and you can stop the display of content using conditions.
For me it was when i receive sensitive information after receiving successfully we need to remove the content. It should not be a failure case as the support person can look for SXMB_MONI to debug.
I know information is not complete but this can help.
Thanks
Gaurav
any ideas please...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.