Bug 1376118

Summary: CFME 5.6 not reporting subnet to instance relationship properly in US GovCloud
Product: Red Hat CloudForms Management Engine Reporter: Jared Deubel <jdeubel>
Component: ProvidersAssignee: Adam Grare <agrare>
Status: CLOSED INSUFFICIENT_DATA QA Contact: Matouš Mojžíš <mmojzis>
Severity: high Docs Contact:
Priority: high    
Version: 5.6.0CC: dajohnso, jdeubel, jfrey, jhardy, mmojzis, obarenbo
Target Milestone: GA   
Target Release: 5.7.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: network:ec2
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2017-03-01 18:45:10 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Jared Deubel 2016-09-14 18:25:49 UTC 
Description of problem:
When drilling down through the network provider for AWS GovCloud the network and subnet views are not reporting and instance relationship.  This information is being reported with AWS East/West provider. 
These errors are reported when I do a relationship refresh for AWS GovCloud provider

[----] E, [2016-07-05T14:31:24.783675 #25752:773990] ERROR -- : MIQ(ManageIQ::Providers::Amazon::NetworkManager::Refresher#refresh) EMS: [Gov Cloud Network Manager], id: [99000000000003] Refresh failed
[----] E, [2016-07-05T14:31:24.783872 #25752:773990] ERROR -- : [ActiveRecord::RecordNotUnique]: PG::UniqueViolation: ERROR:  duplicate key value violates unique constraint "index_cloud_subnets_network_ports"
[----] E, [2016-07-05T14:31:24.783978 #25752:773990] ERROR -- : /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:598:in `async_exec'
[----] E, [2016-07-05T14:31:24.784092 #25752:773990] ERROR -- : MIQ(ManageIQ::Providers::Amazon::NetworkManager::Refresher#refresh) EMS: [Gov Cloud Network Manager], id: [99000000000003] Unable to perform refresh for the following targets:
[----] E, [2016-07-05T14:31:24.784203 #25752:773990] ERROR -- : MIQ(ManageIQ::Providers::Amazon::NetworkManager::Refresher#refresh)  --- ManageIQ::Providers::Amazon::NetworkManager [Gov Cloud Network Manager] id [99000000000003]
[----] E, [2016-07-05T14:31:24.835375 #25752:773990] ERROR -- : MIQ(MiqQueue#deliver) Message id: [99000000014954], Error: [PG::NotNullViolation: ERROR:  null value in column "security_group_id" violates not-null constraint
[----] E, [2016-07-05T14:31:24.835519 #25752:773990] ERROR -- : [ActiveRecord::StatementInvalid]: PG::NotNullViolation: ERROR:  null value in column "security_group_id" violates not-null constraint
[----] E, [2016-07-05T14:31:24.835637 #25752:773990] ERROR -- : /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:598:in `async_exec'
[----] E, [2016-07-05T14:31:41.234369 #25752:773990] ERROR -- : MIQ(ManageIQ::Providers::Amazon::NetworkManager::Refresher#refresh) EMS: [Gov Cloud Network Manager], id: [99000000000003] Refresh failed
[----] E, [2016-07-05T14:31:41.234589 #25752:773990] ERROR -- : [ActiveRecord::RecordNotUnique]: PG::UniqueViolation: ERROR:  duplicate key value violates unique constraint "index_cloud_subnets_network_ports"
[----] E, [2016-07-05T14:31:41.234722 #25752:773990] ERROR -- : /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:598:in `async_exec'
[----] E, [2016-07-05T14:31:41.234831 #25752:773990] ERROR -- : MIQ(ManageIQ::Providers::Amazon::NetworkManager::Refresher#refresh) EMS: [Gov Cloud Network Manager], id: [99000000000003] Unable to perform refresh for the following targets:
[----] E, [2016-07-05T14:31:41.234920 #25752:773990] ERROR -- : MIQ(ManageIQ::Providers::Amazon::NetworkManager::Refresher#refresh)  --- ManageIQ::Providers::Amazon::NetworkManager [Gov Cloud Network Manager] id [99000000000003]
[----] E, [2016-07-05T14:31:41.279844 #25752:773990] ERROR -- : MIQ(MiqQueue#deliver) Message id: [99000000014971], Error: [PG::NotNullViolation: ERROR:  null value in column "security_group_id" violates not-null constraint
[----] E, [2016-07-05T14:31:41.279992 #25752:773990] ERROR -- : [ActiveRecord::StatementInvalid]: PG::NotNullViolation: ERROR:  null value in column "security_group_id" violates not-null constraint
[----] E, [2016-07-05T14:31:41.280140 #25752:773990] ERROR -- : /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:598:in `async_exec'


This is a fresh install of the CF 4.1 appliance

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