Description of problem:

hammer -u admin -p changeme  host create --name='rhel-7-libvirt12' --root-password='changeme' --organization-id="1" --location-id="2" --hostgroup="RHEL 7 Server 64-bit HG" --compute-resource="libvirt" --compute-attributes="cpus=1, memory=1073741824, start=1" --interface="primary=true, compute_type=bridge, compute_bridge=katello_latest, compute_model=virtio" --volume="capacity=10G,format_type=qcow2" --operatingsystem-id 3 --pxe-loader 'PXELinux BIOS'
Could not create the host:
  ERROR:  insert or update on table "hosts" violates foreign key constraint "hosts_operatingsystem_id_fk"
  DETAIL:  Key (operatingsystem_id)=(3) is not present in table "operatingsystems".




2017-08-22 09:07:24 8d37cb27 [app] [I] Started POST "/api/hosts" for 127.0.0.1 at 2017-08-22 09:07:24 -0400
2017-08-22 09:07:24 8d37cb27 [app] [I] Processing by Api::V2::HostsController#create as JSON
2017-08-22 09:07:24 8d37cb27 [app] [I]   Parameters: {"host"=>{"name"=>"rhel-7-libvirt12", "location_id"=>2, "organization_id"=>1, "operatingsystem_id"=>3, "pxe_loader"=>"PXELinux BIOS", "compute_resource_id"=>1, "hostgroup_id"=>2, "build"=>true, "enabled"=>true, "managed"=>true, "compute_attributes"=>{"cpus"=>"1", "memory"=>"1073741824", "start"=>"1", "volumes_attributes"=>{"0"=>{"capacity"=>"10G", "format_type"=>"qcow2"}}}, "content_facet_attributes"=>{}, "subscription_facet_attributes"=>{}, "overwrite"=>true, "host_parameters_attributes"=>[], "interfaces_attributes"=>[{"primary"=>"true", "compute_attributes"=>{"type"=>"bridge", "bridge"=>"katello_latest", "model"=>"virtio"}}], "root_pass"=>"[FILTERED]"}, "apiv"=>"v2"}
2017-08-22 09:07:24 8d37cb27 [app] [I] Current user: foreman_admin (administrator)
2017-08-22 09:07:24 8d37cb27 [app] [I] Current user: foreman_admin (administrator)
2017-08-22 09:07:24 8d37cb27 [app] [I] Current user: admin (administrator)
2017-08-22 09:07:24 8d37cb27 [app] [I] Authorized user admin(Admin User)
2017-08-22 09:07:24 8d37cb27 [app] [I] Current user: admin (administrator)
2017-08-22 09:07:28 8d37cb27 [app] [I] Add DNS A record for rhel-7-lhost1-name.redhat.com/10.x.x.x
2017-08-22 09:07:28 8d37cb27 [app] [I] Add DNS PTR record for rhel-7-lhost1-name.redhat.com
2017-08-22 09:07:29 8d37cb27 [app] [W] Rolling back due to exception during save
 | ActiveRecord::InvalidForeignKey: PG::Error: ERROR:  insert or update on table "hosts" violates foreign key constraint "hosts_operatingsystem_id_fk"
 | DETAIL:  Key (operatingsystem_id)=(3) is not present in table "operatingsystems".
 | : INSERT INTO "hosts" ("type", "build", "compute_resource_id", "managed", "root_pass", "pxe_loader", "hostgroup_id", "location_id", "operatingsystem_id", "organization_id", "puppet_proxy_id", "puppet_ca_proxy_id", "environment_id", "name", "owner_id", "owner_type", "architecture_id", "ptable_id", "grub_pass", "lookup_value_matcher", "uuid", "created_at", "updated_at") VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9, $10, $11, $12, $13, $14, $15, $16, $17, $18, $19, $20, $21, $22, $23) RETURNING "id"
 | /opt/rh/rh-ror42/root/usr/share/gems/gems/activerecord-4.2.6/lib/active_record/connection_adapters/postgresql_adapter.rb:602:in `exec_prepared'
 | /opt/rh/rh-ror42/root/usr/share/gems/gems/activerecord-4.2.6/lib/active_record/connection_adapters/postgresql_adapter.rb:602:in `block in exec_cache'
 | /opt/rh/rh-ror42/root/usr/share/gems/gems/activerecord-4.2.6/lib/active_record/connection_adapters/abstract_adapter.rb:472:in `block in log'



Version-Release number of selected component (if applicable):

Sat6.3.0-snap12.0

How reproducible:


Steps to Reproduce:
1. Create a host with non-existant --operatingsystem-id
2.
3.

Actual results:

Could not create the host:
  ERROR:  insert or update on table "hosts" violates foreign key constraint "hosts_operatingsystem_id_fk"
  DETAIL:  Key (operatingsystem_id)=(3) is not present in table "operatingsystems".


Expected results:

Should throw an error at an early stage, with a message something like,
"operatingsystem not found by id '3' "



Additional info: