Red Hat Satellite 6 present's error when searching for a host : ERROR: invalid reference to FROM-clause entry for table "smart_proxies"

Issue

• When searching for any host from WebUI in Satellite 6.2.X, This error message is printed on screen:

Oops, we're sorry but something went wrong ERROR: invalid reference to FROM-clause entry for table "smart_proxies" LINE 1: SELECT smart_proxies.id FROM "smart_proxies" "puppet_ca_prox... ^ HINT: Perhaps you meant to reference the table alias "puppet_ca_proxies_hosts"