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

FDT_EXPRESSIONS143 - Overview

• 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.