How To Fix FTI_LDB_MESSAGE320 - Pure delta InfoSource indicator is set; No data selection

SAP Error Message - Details

• Message type: E = Error

• Message class: FTI_LDB_MESSAGE - Messages for TR OLTP Reporting Using Logical Databases

• Message number: 320

• Message text: Pure delta InfoSource indicator is set; No data selection

What causes this issue?

You have set the <ZK>Pure Delta InfoSource </>indicator for the
InfoSource 0CFM_DELTA_POSITIONS in Customizing for <ZK>Treasury und Risk
Management </>by choosing <ZK>Transaction Manager -> General Settings ->
Business Information Warehouse -> Define InfoSources for Delta Position.
</><ZK></>
The system therefore does not select any data when initializing the
position with extractor 0CFM_INIT_POSITIONS.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

System Response

How to fix this error?

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message FTI_LDB_MESSAGE320 - Pure delta InfoSource indicator is set; No data selection ?

  The SAP error message FTI_LDB_MESSAGE320 indicates that the Pure Delta InfoSource indicator is set, but there is no data selection available for the extraction process. This typically occurs in the context of SAP BW (Business Warehouse) when working with InfoSources that are configured for delta extraction.
  Cause:
  
  No New Data: The most common cause is that there is no new data available in the source system since the last delta extraction. This can happen if the data in the source system has not changed or if the data has been fully extracted previously.
  Incorrect Delta Configuration: The delta mechanism may not be configured correctly, leading to the system not recognizing any new data.
  Data Selection Criteria: The selection criteria defined for the extraction may be too restrictive, resulting in no records being selected for extraction.
  Technical Issues: There could be technical issues in the source system or in the delta queue that prevent data from being extracted.
  
  Solution:
  
  Check Source Data: Verify that there is indeed new data in the source system that meets the criteria for extraction. You can do this by checking the source tables or using transaction codes like SE16 or SE11.
  Review Delta Configuration: Ensure that the delta configuration for the InfoSource is set up correctly. This includes checking the delta queue and ensuring that the delta mechanism is functioning as expected.
  Adjust Selection Criteria: If the selection criteria are too restrictive, consider modifying them to allow for more data to be selected.
  Monitor Delta Queue: Use transaction RSA7 to monitor the delta queue. If there are entries in the delta queue, ensure they are being processed correctly.
  Reinitialize Delta: If necessary, you may need to reinitialize the delta process. This involves performing a full load followed by a delta load to reset the delta mechanism.
  Check for Errors: Look for any error messages in the source system that might indicate issues with data extraction or delta processing.
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes such as RSA3 (DataSource test), RSA7 (Delta Queue), and RSMO (Monitor Data Transfer).
  Documentation: Review SAP documentation on delta extraction and InfoSources for best practices and troubleshooting steps.
  SAP Notes: Check for any relevant SAP Notes that may address known issues or provide additional guidance on this error message.
  
  By following these steps, you should be able to identify the cause of the error and implement a solution to resolve it.