How To Fix FDT_EXPRESSIONS143 - Data not fully checked for overlaps (check too complex)

SAP Error Message - Details

• Message type: E = Error

• Message class: FDT_EXPRESSIONS - Formula & Derivation Tool: Expressions

• Message number: 143

• Message text: Data not fully checked for overlaps (check too complex)

What causes this issue?

The system has tried to carry out a check in order to find out whether
the supplied conditions in a decision table represent a continuous
sequence of values with no overlapping ranges. However, for technical
reasons it is impossible for the check to yield a reliable result.
INCLUDE FDT_CHECK_FAIL_REASON OBJECT DOKU ID TX

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?

We recommend you have a thorough look at the decision table data and do
some testing to make sure that for each use case that you expect during
productive use there is exactly one distinct combination of condition
values so that the system can make a unique decision on how a particular
set of input data has to be processed.

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 FDT_EXPRESSIONS143 - Data not fully checked for overlaps (check too complex) ?

  The SAP error message FDT_EXPRESSIONS143 indicates that there is an issue with the data checks related to overlaps in the context of the Flexible Data Import (FDI) or Flexible Data Transfer (FDT) framework. This error typically arises when the system is unable to fully validate the data due to the complexity of the checks involved.
  Cause:
  
  Complexity of Data Checks: The error often occurs when the checks for overlaps in the data are too complex for the system to process efficiently. This can happen if there are many conditions or if the data set is large.
  Configuration Issues: There may be issues with how the data checks are configured in the FDT framework, leading to inefficiencies in processing.
  Performance Limitations: The system may be hitting performance limits, causing it to skip some checks to avoid timeouts or excessive resource consumption.
  
  Solution:
  
  Simplify Data Checks: Review the configuration of the data checks and try to simplify them. This may involve breaking down complex conditions into simpler, more manageable checks.
  Optimize Data Sets: If possible, reduce the size of the data set being processed at one time. This can help the system handle the checks more efficiently.
  Increase System Resources: If the issue is related to performance limitations, consider increasing the resources available to the SAP system (e.g., memory, processing power).
  Review Logs and Traces: Check the application logs and traces for more detailed information about what might be causing the complexity. This can provide insights into specific areas that need attention.
  Consult SAP Notes: Look for relevant SAP Notes or updates that may address this specific error. SAP frequently releases patches and updates that can resolve known issues.
  Engage SAP Support: If the problem persists, consider reaching out to SAP Support for assistance. They can provide guidance based on the specific configuration and context of your system.
  
  Related Information:
  
  SAP Documentation: Review the official SAP documentation for FDT and FDI to understand the configuration options and best practices for setting up data checks.
  Community Forums: Engage with SAP community forums or user groups where similar issues may have been discussed. Other users may have encountered the same error and can share their solutions.
  Performance Monitoring: Implement performance monitoring tools to identify bottlenecks in the data processing that may be contributing to the error.
  
  By addressing the complexity of the checks and optimizing the data processing, you should be able to resolve the FDT_EXPRESSIONS143 error.