How to delete log from SMQ1 ECC-PRD

[Former Member]

Hi ,

ECC-PRD server tcode SMQ1 a lot of entry's logs are available.Please

how we can delete and what is the best procedure.

Regards

Dinesh

[Former Member · Accepted solution]

Hello Dinesh

The standard way to delete queue entries is to run report RSTRFCQD/DS as a batchjob as mentioned in note 763255.

please also check below sap notes

375566 Large number of entries in tRFC and qRFC tables

366869 HOLD/EXECUTED/WCONFIRM entries in ARFCRSTATE

1621114  RSTRFCEH - Performance improvement with deletion

[Former Member]

Dinesh,

SMQ1 is not a log.  It is a listing of Queues that have not processed.

In general, it is not wise to delete any entries from SMQ1 unless you first investigate; particularly in a productive system.  In many cases, these entries represent interface failures; e.g. a bit of data that was SUPPOSED to update a destination system in fact did not perform the update.  In such cases, the systems may be out of synch, and that inconsistency might represent genuine business problems.

The other experts have described how to perform the deletions, once you have decided that the entries should be deleted.  However, I strongly recommend that you at least look at samples of each failure, and first determine if deletion is the only step that must be performed.  Depending upon the contents of the queue, there may be other steps you should take as well.....

Best Regards,

DB49

[Former Member]

Hi Dinesh

In the ERP system, you can use the report RDELALOG to delete records from the application log.

Refer below link for better understanding

Deleting Entries in the Application Log - Integration via Core Interface (CIF) - SAP Library

I hope it is clear now .

Regards

Virender