How To Fix FTI_LDB_MESSAGE024 - Access optimization is deactivated -> long runtimes

SAP Error Message - Details

• Message type: E = Error

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

• Message number: 024

• Message text: Access optimization is deactivated -> long runtimes

What causes this issue?

The field table used to optimize access to the logical database is not
filled.
Possible causes:
Access optimization has been explicitly deactivated for the query
The logical database call in a report was incomplete
The logical database was called via transactions such as SE38
The field list contains all the fields that were selected in a report.
This logical database needs such a list for two reasons:
The logical database is not suitable for pure master data reporting. If
only characteristics and attributes have been selected for a master data
report, the internal logic is likely to output the wrong data. At least
one key figure must be selected (such as the no. of units
, book value, NPV, ...).
In addition, selecting and calculating the data for many of the
attributes and key figures can be very time-consuming. In such cases,
the field list helps to optimize the use of the runtime - only the
requested logical database fields are filled.

System Response

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

How to fix this error?

To improve runtimes, reactivate access optimization or fill the field
table from within the report.
Alternatively, you can just continue. In this case, the field list is
filled in retrospect with all the fields from the logical database. If
you choose this option, all the fields are selected or calculated,
including fields that may not be required for the report. The runtime is
therefore longer than if the fields are requested by the report.

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_MESSAGE024 - Access optimization is deactivated -> long runtimes ?

  The SAP error message FTI_LDB_MESSAGE024 indicates that access optimization is deactivated, which can lead to long runtimes when executing queries or reports. This message is typically associated with the use of the SAP Business Warehouse (BW) or SAP HANA systems, where performance optimization is crucial for efficient data retrieval.
  
  Cause:
  
  Access Optimization Deactivation: The primary cause of this error message is that the access optimization feature is turned off. This feature is designed to improve the performance of data access by optimizing how data is retrieved from the database.
  
  Configuration Issues: There may be configuration settings in the BW or HANA system that prevent access optimization from being enabled.
  Data Model Design: Inefficient data model design or poor indexing can also contribute to long runtimes, especially if access optimization is not utilized.
  
  
  Solution:
  
  
  Activate Access Optimization:
  
  Go to the relevant settings in the SAP BW or HANA system.
  Navigate to the settings for the InfoProvider or query where