2909635 - REGEX_TOO_COMPLEX while executing report RS_CDS_COMPARE_DDIC_DB or Z report ZRS_CDS_COMPARE_DDIC_DB

Below Runtime Error is produced by the mentioned reports

Category ABAP programming error
Runtime Errors REGEX_TOO_COMPLEX
Except. CX_SY_REGEX_TOO_COMPLEX
ABAP Program CL_ORA_GENERIC_UTILS==========CP
Application Component BC-DB-ORA
...

Error analysis
An exception has occurred which is explained in more detail below. The
exception is assigned to class 'CX_SY_REGEX_TOO_COMPLEX' and was not caught in
procedure
"STRING_SPLIT" "(METHOD)", nor was it propagated by a RAISING clause.
Since the caller of the procedure could not have anticipated this
exception, the current program was terminated.
The reason for the exception is:
The search with regular expression ".*\s+.*" was cancelled.

Due to the relatively high level of complexity of the expression, it is
not possible to determine the hits according to the leftmost-longest
rule for the current search text.

• Operating System Independent
• Oracle RDBMS 19c
• SAP Netweaver
• as of SAP_BASIS 7.40 SP 23
• as of SAP_BASIS 7.50 SP 16
• as of SAP_BASIS 7.51 SP 09
• as of SAP_BASIS 7.52 SP 05
• as of SAP_BASIS 7.53 SP 03
• SAP note 2801989 got applied (which is required to avoid other problems)

sqlmacrooff.sql, CDS Views, SQL Macro, SQL Macros, SORAMON, RS_CDS_COMPARE_DDIC_DB, ZRS_CDS_COMPARE_DDIC_DB, NOSQLMACRO , KBA , BC-DB-ORA-CCM , (CCMS) Database Monitors , Problem