How To Fix FTI066 - No data selected; no data sent to delta queue

SAP Error Message - Details

• Message type: E = Error

• Message class: FTI - Treasury Information System

• Message number: 066

• Message text: No data selected; no data sent to delta queue

Self-Explanatory Message

Since SAP believes that this specific error message is 'self-explanatory,' no more information has been given.The majority of messages in the SAP system have a message text, however this is frequently insufficient to comprehend or resolve the problem.

To make things easier, more detailed information is frequently added to describe the issue, how to fix it, and the necessary steps or configuration modifications.

Unfortunately, there isn't any extra information in this error notice.

What else can you do?

First, use our AnswerBot below to get a possible cause and solution (requires a premium subscription).

Also, review the in-depth Common Questions & Answers listed below; you could discover a solution there or be able to connect with others who have faced similar challenges.

You can also try searching the SAP support portal (support.sap.com) but you need a special user ID to access it. It is possible that an SAP support note exists that provides additional details about the mistake or even steps for fixing it.

Smart SAP Assistant

• What is the cause and solution for SAP error message FTI066 - No data selected; no data sent to delta queue ?

  The SAP error message FTI066: No data selected; no data sent to delta queue typically occurs in the context of data extraction processes, particularly when using SAP's Financials or other modules that involve data transfer to a delta queue (like SAP BW or SAP Data Services). This error indicates that the system did not find any data to process for the delta extraction.
  Causes:
  
  No New Data: There may simply be no new or changed data in the source system since the last extraction. This is common if the data has not been updated or if the extraction is run too frequently.
  Selection Criteria: The selection criteria defined for the extraction might be too restrictive, leading to no records being selected.
  Data Locking: If the data is being locked by another process or transaction, it may not be available for extraction.
  Delta Queue Issues: There could be issues with the delta queue itself, such as it being full or not properly configured.
  Technical Issues: There may be underlying technical issues, such as problems with the data source or connectivity issues.
  
  Solutions:
  
  Check Data Availability: Verify if there is new or changed data in the source system that meets the selection criteria. If not, you may need to wait until new data is available.
  Review Selection Criteria: Examine the selection criteria used for the extraction. Ensure that they are set correctly and are not overly restrictive.
  Monitor Data Locks: Check if there are any locks on the data that might prevent it from being extracted. You can use transaction codes like SM12 to monitor locks.
  Delta Queue Configuration: Ensure that the delta queue is properly configured and functioning. You can check the status of the delta queue using transaction codes like RSA7 (for BW) or other relevant monitoring tools.
  Re-run Extraction: If you suspect a temporary issue, try re-running the extraction process after some time.
  Check Logs: Review the logs for any additional error messages or warnings that might provide more context about the issue.
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as RSA7 (for monitoring delta queues), SM37 (for job monitoring), and SLG1 (for application logs).
  SAP Notes: Check SAP Notes for any known issues or patches related to the error message FTI066. SAP's support portal can provide valuable insights and solutions.
  Documentation: Review SAP documentation related to data extraction processes, delta queues, and data transfer methods to ensure best practices are being followed.
  
  If the issue persists after trying the above solutions, it may be beneficial to consult with your SAP Basis or BW team for further investigation.