How To Fix FB129 - Sample search too complex

FB129 - Overview

• Message type: E = Error

• Message class: FB - Batch Programs

• Message number: 129

• Message text: Sample search too complex

What causes this issue?

A current sample search requires too much calculation.

System Response

The sample search is terminated.

How to fix this error?

The calculation effort depends on the search string and the text being
searched:
Search strings with repetition characters ("+" or "*") and "or"
characters ("|") require higher amounts of calculation and should not
be used if there are performance problems. This also applies to a
greater extent to nested constructions (for example, "(.|#+)+").
The calculation required also increases in relation to the length of
the input text (at least linear, under certain circumstances, also
exponential).

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message FB129 - Sample search too complex ?

  The SAP error message FB129, which states "Sample search too complex," typically occurs when a user attempts to execute a search or query in the SAP system that is too complex for the system to process efficiently. This can happen in various contexts, such as when using transaction codes related to financial documents, customer/vendor master data, or other areas where search functionalities are employed.
  Causes:
  
  Complex Search Criteria: The search criteria specified by the user may involve too many fields or conditions, making the query overly complex.
  Large Data Volume: The underlying database may contain a large volume of data, and the search criteria may not be optimized for performance.
  Inefficient Indexing: The database tables involved in the search may not be properly indexed, leading to performance issues.
  System Limitations: There may be inherent limitations in the SAP system regarding the complexity of queries that can be processed.
  
  Solutions:
  
  Simplify Search Criteria: Review and simplify the search