Change status for 18 million messages in the Integration Engine

Advertisement
October 11

Hello there!
I have the following situation and I wonder that maybe you could help. Currently I have more than 18 million messages for the BC_XMB object in the Integration Engine for a BI System (connected to a PI system).
The problem here is that the archiving/deletion jobs in this BI system are faulty since maybe a couple of years ago and all of these messages are marked as "Archivable":
What I'm trying to do here is to change the status for these 18 million messages from "can be archived" to "to be deleted" since there is no way that I can archive this 18 million messages (filesystem capacity). I've been looking many option but I cannot figure out how to do it.
Maybe, if you know an alternative way to do this, I will be very pleased to hear it.
Thanks a lot in advance.
Carlos

Advertisement

Replay

Raghu.
I've done the following:
1. I've executed SE38 tx code.
2. I've entered the "RSXMB_DELETE_MESSAGES" report as "Program"
3. As the "RSXMB_DELETE_MESSAGES" report does not have a selection screen, it must be executed with default parameters. So, I selected "Program -> Execute -> Background".
4. There are no available variants, so I clicked on the "Execute immed." button.
5. The job starts. I can monitor it on the SM37 tx code.
6. It only deleted 20 messages.
What I get from this, is that the "RSXMB_DELETE_MESSAGES" report cannot delete the big part of the messages since them are marked as "Archivable" and not as "Archived".
what do you think of it??
regards
Carlos.

View 12 Replies

Auto Cancellation of Messages in the Integration Engine.

October 11

Dear all, Issue: Auto Cancellation of Messages in the Integration Engine. Description: Actually Today, I'm facing Problem in message mapping and its showing error "JCO_SYSTEM_FAILURE". Finally the message is Auto Canceled and showing the status

View All Replies

I am unable to change passwords for any users.  The "change password" is grayed out.

November 30

I am unable to change passwords for any users.  The "change password" is grayed out.  I know there is a way to change them but I am having trouble finding it. Message was edited by: dmw1975If you're in the Users pane of the server app, and you s

View All Replies

Bottom bar for text messages in the middle of screen?!

November 30

The email and text message screen has a bar at the bottom for composing emails, searching, forwarding, replying, and deleting. However, this bar moved all the way up to the middle of the screen. As a result, the view of my message is limited to the u

View All Replies

Change status for sales order in crmd_order

October 11

Hi, I am creating a report which has to change for all sales order with status "Open" to status "Processed". Is there any function or bapi to do this ?? Supposing, there is no function, which tables do i have to change ??? thanks in ad

View All Replies

Inventory status for a date in the PAST with BATCHES with VALUE

November 30

Hi, How can I get a status REPORT of all inventory as on a date in the PAST with BATCH numbers and VALUE? The following ready reports do not solve my problem: 1. Inventory Status: This gives CURRENT date inventory QUANTITY only. 2. Inventory in Wareh

View All Replies

What are default adpters in  ABAP stack  in the Integration engine

November 30

Hi, May I  know the what are the default adapters in  ABAP stack and in Intergation engine.  One I know is IDOC,  which we dont need to configure as outbound, whats others. ThanksHi, also sender http adapter can be found on abap stack all the rest ha

View All Replies

Extracting User Status for Sales Orders

November 30

I am trying to extract user status transactional data for sales orders (at both the header and item level).  I have been following SAP note 300300 to configure the status extractors and map the BW objects to sales order status data sources (2LIS_11_V

View All Replies

How to delete a document status for a document type

November 30

Hi, May i know how to delete the some document statuses for a document type. Because present we are having many document statuses, In that we want to remove some statuses.please find the screenshot and help me please. In tha above screenshot, Now i w

View All Replies

Custom processing for ALEAUD01 messages ??

November 30

Hi Everyone, Whenever ALEAUD01 IDocs are sent to XI, it is treated as an acknowledgement message by the system. We can see the IDOC in IDX5, but it does not go into the normal receiver determination route. Is there any way/setting in XI which will al

View All Replies

Language for standard messages

November 30

Hi All ! I get a lot of error messages in my application, for example: "Validation Error: Value is required. " or "Validation Error: Value is less than allowable minimum of '2' " It's ok, but how can I change language for these message

View All Replies

Changing everything for old history

November 30

Hello, I am abandoning my old account, and I would like to know if there is any way to change the display name associated with all of the old history/records,including the records on other user's computers I've chatted with? I know how to change it f

View All Replies

[RFC to File]Problem about Changing file name in message mapping.

October 11

Hi, my problem:     Type:RFC to File     I change the file name in message mapping. when I call the RFC to send the data twice at the same time, both of the output file names are changed while I only want to change the second output file name.     th

View All Replies

Mapping Runtime failing for all messages

October 11

Hi Experts, We are facing an issue with our mapping runtime in the integration engine. Any message going through the integration engine is giving a mapping error as shown below (for example): LinkageError during appliction Java mapping com/sap/xi/tf/

View All Replies

Activation of User status for Prod. order

November 30

Hi, I have created a status profile with a status as a user status for production order. Now the thing is how to activate this user status for a specific transaction. the requirement is after settlement the user status should get activated for produc

View All Replies

Charges for text messages that cannot be received

November 30

Looking at my Xoom usage online today I noticed that there were 5 text messages sent to the phone number of the line my Xoom is using.  But, as discussed in other posts here, the Xoom cannot receive or send text messages.  I called Verizon to turn of

View All Replies

Why cant I change sounds for alerts in Mavricks

November 30

Hi there, I tried changing sound affects in System Preferences/Sounds/Sounds Effects, and then selecting the one I want, but it's not playing at all now. Before that I had another sound for the alert. I'd like to change it for when I hear the notific

View All Replies

Help fix my function to show status for all folders

October 11

I have created a function (tow of them for the same purpose) but they are not working. They compile but when i call them I get null result. What I want to do is get folder status for all folders in the database. There is a table called folder with st

View All Replies

Unable to set status for subscreen

November 30

Dear Experts, In my subscreen, I want to set the fct code for enter. I am not able to set the status so that i can provide the fct code under the standard function keys. In my subscreen I have a list of input screen fields, when i enter the first inp

View All Replies

Java.lang.Exception error during XML validation by Integration Engine

October 11

Hi professionals, We are trying to use XML validation by the Integration Engine. Step 1: We created an appropriate directory structure where we had to store the structure (xsd). \usr\sap\<system id>\SYS\global\xi\runtime_server\A\B\C\D\E\F A - valid

View All Replies

Tags:

  1. on nxt finger sensor issue
  2. is 15 inch laptop enough for eve online
  3. Fair photoshop cs4 action
  4. print rdf oracle in new tab
  5. mass approval fk09
  6. Using the load TXT
  7. does STATUS_CHANGE_EXTERN COMMIT WORK
  8. content
  9. QRRI
  10. DCD5
Copyrights 2019 Fcffair BigData Resource, All rights reserved