SMQ1 Have Status NoSend

In SMQ1 (qRFC Monitor) I have status 'NOSEND'.

In the table TRFCQOUT, some entries have the status 'READY', others 'RECORDED'. ARFCSSTATE is 'READ'.

What do these statuses mean?

Which values in the field 'Status' mean what and which values are correct and which are alarming?

Are the statuses BW-specific or generally valid in qRFC?

---

Answer

Table TRFCQOUT and ARFCSSTATE: Status READ means that the record was read once either in a delta request or in a repetition of the delta request. However, this does not mean that the record has successfully reached the BW yet.

The status READY in the TRFCQOUT and RECORDED in the ARFCSSTATE means that the record has been written into the DeltaQueue and will be loaded into the BW with the next delta request or a repetition of a delta.

In any case only the statuses READ, READY and RECORDED in both tables are considered to be valid. The status EXECUTED in TRFCQOUT can occur temporarily. It is set before starting a DeltaExtraction for all records with status READ present at that time. The records with status EXECUTED are usually deleted from the queue in packages within a delta request directly after setting the status before extracting a new delta.

If you see such records, it means that either a process which is confirming and deleting records which have been loaded into the BW is successfully running at the moment, or, if the records remain in the table for a longer period of time with status EXECUTED, it is likely that there are problems with deleting the records which have already been successfully been loaded into the BW.

In this state, no more deltas are loaded into the BW. Every other status is an indicator for an error or an inconsistency.

NOSEND in SMQ1 means nothing (see note 378903).

The value 'U' in field 'NOSEND' of table TRFCQOUT is discomforting.

SAP BW Tips

Also read
Tickets and Authorization in SAP Business Warehouse

Get help for your SAP BW problems
SAP BW Forum - Do you have a SAP BW Question?

SAP Business Warehouse Books
SAP BW Books - Certification, Interview Questions and Configuration

SAP BW Tips
SAP BW Tips and Business Information Warehouse

Main Index
SAP ERP Modules, Basis, ABAP and Other IMG Stuff

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.