Description of problem: hammer content-host list by erratum id failed Version-Release number of selected component (if applicable): * apr-util-ldap-1.3.9-3.el6_0.1.x86_64 * candlepin-0.9.38-1.el6.noarch * candlepin-common-1.0.18-1.el6.noarch * candlepin-selinux-0.9.38-1.el6.noarch * candlepin-tomcat6-0.9.38-1.el6.noarch * elasticsearch-0.90.10-7.el6.noarch * foreman-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch * foreman-compute-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch * foreman-gce-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch * foreman-libvirt-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch * foreman-ovirt-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch * foreman-postgresql-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch * foreman-proxy-1.8.0-0.develop.201501280951gite1bc928.el6.noarch * foreman-release-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch * foreman-selinux-1.8.0-0.develop.201412151103gite2863e4.el6.noarch * foreman-vmware-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch * katello-2.1.0-1.201411061509gitb0b8f43.el6.noarch * katello-certs-tools-2.0.1-1.el6.noarch * katello-default-ca-1.0-1.noarch * katello-installer-2.2.0-1.201501272021gitf707d62.el6.noarch * katello-installer-base-2.2.0-1.201501272021gitf707d62.el6.noarch * katello-repos-2.1.1-1.el6.noarch * katello-server-ca-1.0-1.noarch * openldap-2.4.39-8.el6.x86_64 * openldap-devel-2.4.39-8.el6.x86_64 * pulp-docker-plugins-0.2.1-0.2.beta.el6.noarch * pulp-katello-0.3-3.el6.noarch * pulp-nodes-common-2.5.1-1.el6.noarch * pulp-nodes-parent-2.5.1-1.el6.noarch * pulp-puppet-plugins-2.5.1-1.el6.noarch * pulp-puppet-tools-2.5.1-1.el6.noarch * pulp-rpm-plugins-2.5.1-1.el6.noarch * pulp-selinux-2.5.1-1.el6.noarch * pulp-server-2.5.1-1.el6.noarch * python-ldap-2.3.10-1.el6.x86_64 * ruby193-rubygem-ldap_fluff-0.3.3-1.el6.noarch * ruby193-rubygem-net-ldap-0.10.0-1.el6.noarch * ruby193-rubygem-runcible-1.3.0-1.el6.noarch How reproducible: Always Steps to Reproduce: hammer> content-host list --erratum-id=6b3f8b99-f4a5-42fa-82af-1e04b28d8f4e --organization-id=1 PGError: ERROR: column reference "uuid" is ambiguous LINE 1: SELECT uuid FROM "katello_systems" INNER JOIN "katello_syste... ^ : SELECT uuid FROM "katello_systems" INNER JOIN "katello_system_errata" ON "katello_system_errata"."system_id" = "katello_systems"."id" INNER JOIN "katello_errata" ON "katello_errata"."id" = "katello_system_errata"."erratum_id" WHERE "katello_errata"."id" IN (SELECT "katello_errata"."id" FROM "katello_errata" WHERE "katello_errata"."uuid" IN ('6b3f8b99-f4a5-42fa-82af-1e04b28d8f4e')) Actual results: as shown above Expected results: content-host list by erratum-id should work fine Additional info:
Created attachment 986087 [details] foreman-debug
Created attachment 986090 [details] error log
I can't reproduce this: [root@prometheus ~]# hammer content-host list --erratum-id=31d45294-ccaf-42f5-b3d9-ddcbec43b50f --organization-id 2 -------------------------------------|------------------|------------------- ID | NAME | INSTALLABLE ERRATA -------------------------------------|------------------|------------------- d22349bd-575e-4541-ae87-540adce7425e | asgard.bitbin.de | 12 -------------------------------------|------------------|------------------- Can you confirm this is still an issue?