Remove old messages from CRM_DNO_MONITOR

[Former Member]

Hi All,

We have lot of test messages in CRM_DNO_MONITOR which needs to be deleted, but whicle deleting its giving error that "ransaction cannot be deleted" and

"The transaction cannot be deleted. If required, you can find the cause

in the application log. There could be a follow-up document for the

transaction."

"Check whether a follow-up document exists, or check whether you want to

cancel the document instead of deleting it."

Can anyone give an idea what is the follow-up document which we needs to delete before deleting the message?

We could also see that all messages which are having document flow enabled in the messages are not able to delete.

Kindly let me know if anyone has a solution.

Regards,

Phani.

[Former Member · Accepted solution]

Hi,

Unfortunately it is not that easy to delete old Support Desk messages.

As you know every message consists of two messages in reality. The CRM

message has to be archived using transaction SARA. The archiving object

is CRM_SERORD. The basis messages cannot be archived because there is no

archiving object existing for them. What you can do is to set the dele-

tion flag (status I0076) for every message you do not need any more.

Afterwards you can use report Z_DELETE_BASIC_NOTIFICATIONS provided in

the attached note:

#566225 Report to delete the basis notifications with deletion flag

For CRM test messages alternatively the report CRM_ORDER_DELETE can be

used with the following restriction.

Deleting of CRM message with report "crm_order_delete" works only if the

item of the CRM message (with exists in the background without being

displayed) is not released. But if you are using transactiontype SLF1

for the CRM message the status 'Released' is set for the

item as soon as you set the status 'In process' for the message. As

'Completed' is a follow-up status of status 'In process' you cannot de-

lete the CRM messages anymore using the report.

to set the deletion flag for the basic notification you have to use

transaction DNOTIFWL.

Here you have to set the status 'complete notificatation' so that

it is set to completed. Afterwards you canm set the status 'Mark for

deletion' at the same place.

Hope the above helps.

Cheers,

sh

[Former Member]

Thanks for the answers

[Former Member]

Hi,

Goto se38 and run the report CRM_ORDER_DELETE.

Enter the ticket no which you want to delete

Also, have a look at this note: 1329247.

Thx,

Waseem.

[prakhar_saxena]

Hi

Service Desk messages in Solution Manager consist of two parts: the support message in Solution Manager, and the service process in CRM.

You must carry out the following steps to delete the messages from the system completely:

1. In Solution Manager

Deletion of the message in Solution Manager involves two parts:

a) Call transaction DNOTIFWL and set the deletion flag for the Service Desk message. The deletion flag corresponds to the system status I1076 (deletion flag).

b) Execute the report Z_DELETE_BASIC_NOTIFICATIONS.

If you execute the report in production mode, all messages with the status I0076 are deleted from the database. You can also execute the report in test mode. In this case, the system displays a list of messages that can be deleted.

2. In CRM

You cannot delete a service process in CRM. The service process must be archived.

Call transaction SARA and select the archiving object CRM_SERORD. Archiving involves three steps:

a) Initial run Report CRM_ARC_SERORD_CHECK

b) Write run Report CRM_ARC_SERORD_SAVE

c) Delete run Report CRM_ARC_SERORD_DELETE

When the delete run has completed, the service process has been deleted from the database and is in an archive file. You can access archived documents using transaction SARE.

Check the following notes.

1329247

398914

398915

985079

Thread

Hope it helps,

Regards

Prakhar