'yum update' fails to update third party packages after enabling SCA with "none of the providers can be installed"

Issue

After enabling SCA yum update fails with package X requires Z but none of the providers can be installed on third party packages.

Example:

...
Error:
 Problem 1: package MariaDB-shared-10.5.20-1.el8.x86_64 requires MariaDB-common, but none of the providers can be installed
  - cannot install the best update candidate for package mariadb-connector-c-3.1.11-2.el8_3.x86_64
  - package MariaDB-common-10.5.18-1.el8.x86_64 is filtered out by modular filtering
  - package MariaDB-common-10.5.19-1.el8.x86_64 is filtered out by modular filtering
  - package MariaDB-common-10.5.20-1.el8.x86_64 is filtered out by modular filtering
 Problem 2: package MariaDB-shared-10.5.20-1.el8.x86_64 requires MariaDB-common, but none of the providers can be installed
  - cannot install the best update candidate for package mariadb-connector-c-config-3.1.11-2.el8_3.noarch
  - package MariaDB-common-10.5.18-1.el8.x86_64 is filtered out by modular filtering
  - package MariaDB-common-10.5.19-1.el8.x86_64 is filtered out by modular filtering
  - package MariaDB-common-10.5.20-1.el8.x86_64 is filtered out by modular filtering
(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)