Description of problem:


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

How reproducible:
100%

Steps to Reproduce:
1.Navigate to configuration management
2.Add Red Hat satellite provider
3.Sort the Configuration management provider by URL. 


Actual results:
 PG::UndefinedColumn: ERROR:  column providers.url does not exist
LINE 1: ...rs::AnsibleTower::ConfigurationManager') ORDER BY "providers. is displayed in production.log

After hitting this error when you click on "All configuration management providers" in the accordion tree this error is continuously thrown.


Expected results:
sorting should work

Additional info:
production.log
[----] I, [2016-10-13T02:33:53.603071 #11878:1044efc]  INFO -- : Started POST "/provider_foreman/explorer?sortby=2&" for 127.0.0.1 at 2016-10-13 02:33:53 -0400
[----] I, [2016-10-13T02:33:53.607127 #11878:1044efc]  INFO -- : Processing by ProviderForemanController#explorer as JS
[----] I, [2016-10-13T02:33:53.607313 #11878:1044efc]  INFO -- :   Parameters: {"sortby"=>"2"}
[----] F, [2016-10-13T02:33:53.686174 #11878:1044efc] FATAL -- : Error caught: [ActiveRecord::StatementInvalid] PG::UndefinedColumn: ERROR:  column providers.url does not exist
LINE 1: ...rs::AnsibleTower::ConfigurationManager') ORDER BY "providers...
                                                             ^
: SELECT  "ext_management_systems"."id" AS t0_r0, "ext_management_systems"."name" AS t0_r1, "ext_management_systems"."created_on" AS t0_r2, "ext_management_systems"."updated_on" AS t0_r3, "ext_management_systems"."guid" AS t0_r4, "ext_management_systems"."zone_id" AS t0_r5, "ext_management_systems"."type" AS t0_r6, "ext_management_systems"."api_version" AS t0_r7, "ext_management_systems"."uid_ems" AS t0_r8, "ext_management_systems"."host_default_vnc_port_start" AS t0_r9, "ext_management_systems"."host_default_vnc_port_end" AS t0_r10, "ext_management_systems"."provider_region" AS t0_r11, "ext_management_systems"."last_refresh_error" AS t0_r12, "ext_management_systems"."last_refresh_date" AS t0_r13, "ext_management_systems"."provider_id" AS t0_r14, "ext_management_systems"."realm" AS t0_r15, "ext_management_systems"."tenant_id" AS t0_r16, "ext_management_systems"."project" AS t0_r17, "ext_management_systems"."parent_ems_id" AS t0_r18, "ext_management_systems"."subscription" AS t0_r19, "ext_management_systems"."last_metrics_error" AS t0_r20, "ext_management_systems"."last_metrics_update_date" AS t0_r21, "ext_management_systems"."last_metrics_success_date" AS t0_r22, "ext_management_systems"."tenant_mapping_enabled" AS t0_r23, "zones"."id" AS t1_r0, "zones"."name" AS t1_r1, "zones"."description" AS t1_r2, "zones"."created_on" AS t1_r3, "zones"."updated_on" AS t1_r4, "zones"."settings" AS t1_r5, "zones"."log_file_depot_id" AS t1_r6, "providers"."id" AS t2_r0, "providers"."type" AS t2_r1, "providers"."name" AS t2_r2, "providers"."guid" AS t2_r3, "providers"."zone_id" AS t2_r4, "providers"."created_at" AS t2_r5, "providers"."updated_at" AS t2_r6, "providers"."tenant_id" AS t2_r7 FROM "ext_management_systems" LEFT OUTER JOIN "zones" ON "zones"."id" = "ext_management_systems"."zone_id" LEFT OUTER JOIN "providers" ON "providers"."id" = "ext_management_systems"."provider_id" WHERE "ext_management_systems"."type" IN ('ManageIQ::Providers::ConfigurationManager', 'ManageIQ::Providers::Foreman::ConfigurationManager', 'ManageIQ::Providers::AnsibleTower::ConfigurationManager') ORDER BY "providers"."url" DESC LIMIT $1 OFFSET $2
/opt/rh/cfme-gemset/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/postgresql_adapter.rb:598:in `async_exec'
/opt/rh/cfme-gemset/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/postgresql_adapter.rb:598:in `block in exec_no_cache'
/opt/rh/cfme-gemset/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract_adapter.rb:566:in `block in log'
/opt/rh/cfme-gemset/gems/activesupport-5.0.0.1/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/opt/rh/cfme-gemset/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract_adapter.rb:560:in `log'
/opt/rh/cfme-gemset/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/postgresql_adapter.rb:598:in `exec_no_cache'
/opt/rh/cfme-gemset/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/postgresql_adapter.rb:587:in `execute_and_clear'
/opt/rh/cfme-gemset/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/postgresql/database_statements.rb:103:in `exec_query'
/opt/rh/cfme-gemset/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract/database_statements.rb:373:in `select'
/opt/rh/cfme-gemset/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract/database_statements.rb:41:in `select_all'
/opt/rh/cfme-gemset/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract/query_cache.rb:68:in `block in select_all'
/opt/rh/cfme-gemset/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract/query_cache.rb:83:in `cache_sql'
/opt/rh/cfme-gemset/gems/activerecord-5.0.0.1/lib/active_record/connection_adapters/abstract/query_cache.rb:68:in `select_all'
/opt/rh/cfme-gemset/gems/activerecord-5.0.0.1/lib/active_record/relation/finder_methods.rb:389:in `find_with_associations'
/var/www/miq/vmdb/lib/extensions/ar_virtual.rb:603:in `find_with_associations'
/var/www/miq/vmdb/lib/extensions/ar_virtual.rb:605:in `find_with_associations'
/opt/rh/cfme-gemset/gems/activerecord-5.0.0.1/lib/active_record/relation.rb:699:in `exec_queries'
/opt/rh/cfme-gemset/gems/activerecord-5.0.0.1/lib/active_record/relation.rb:580:in `load'
/opt/rh/cfme-gemset/gems/activerecord-5.0.0.1/lib/active_record/relation.rb:260:in `records'
/opt/rh/cfme-gemset/gems/activerecord-5.0.0.1/lib/active_record/relation.rb:256:in `to_a'
/var/www/miq/vmdb/app/models/miq_report/generator.rb:349:in `build_table'
/var/www/miq/vmdb/app/models/miq_report/search.rb:111:in `paged_view_search'
/var/www/miq/vmdb/app/controllers/application_controller.rb:1602:in `get_view'
/var/www/miq/vmdb/app/controllers/application_controller/ci_processing.rb:1615:in `process_show_list'
/var/www/miq/vmdb/app/controllers/provider_foreman_controller.rb:1162:in `process_show_list'
/var/www/miq/vmdb/app/controllers/provider_foreman_controller.rb:730:in `default_node'
/var/www/miq/vmdb/app/controllers/provider_foreman_controller.rb:583:in `get_node_info'
/var/www/miq/vmdb/app/controllers/provider_foreman_controller.rb:841:in `leaf_record'
/var/www/miq/vmdb/app/controllers/provider_foreman_controller.rb:827:in `replace_right_cell'
/var/www/miq/vmdb/app/controllers/provider_foreman_controller.rb:438:in `explorer'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_controller/metal/basic_implicit_render.rb:4:in `send_action'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/abstract_controller/base.rb:188:in `process_action'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_controller/metal/rendering.rb:30:in `process_action'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/abstract_controller/callbacks.rb:20:in `block in process_action'
/opt/rh/cfme-gemset/gems/activesupport-5.0.0.1/lib/active_support/callbacks.rb:126:in `call'
/opt/rh/cfme-gemset/gems/activesupport-5.0.0.1/lib/active_support/callbacks.rb:506:in `block (2 levels) in compile'
/opt/rh/cfme-gemset/gems/activesupport-5.0.0.1/lib/active_support/callbacks.rb:455:in `call'
/opt/rh/cfme-gemset/gems/activesupport-5.0.0.1/lib/active_support/callbacks.rb:101:in `__run_callbacks__'
/opt/rh/cfme-gemset/gems/activesupport-5.0.0.1/lib/active_support/callbacks.rb:750:in `_run_process_action_callbacks'
/opt/rh/cfme-gemset/gems/activesupport-5.0.0.1/lib/active_support/callbacks.rb:90:in `run_callbacks'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/abstract_controller/callbacks.rb:19:in `process_action'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_controller/metal/rescue.rb:20:in `process_action'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_controller/metal/instrumentation.rb:32:in `block in process_action'
/opt/rh/cfme-gemset/gems/activesupport-5.0.0.1/lib/active_support/notifications.rb:164:in `block in instrument'
/opt/rh/cfme-gemset/gems/activesupport-5.0.0.1/lib/active_support/notifications/instrumenter.rb:21:in `instrument'
/opt/rh/cfme-gemset/gems/activesupport-5.0.0.1/lib/active_support/notifications.rb:164:in `instrument'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_controller/metal/instrumentation.rb:30:in `process_action'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_controller/metal/params_wrapper.rb:248:in `process_action'
/opt/rh/cfme-gemset/gems/activerecord-5.0.0.1/lib/active_record/railties/controller_runtime.rb:18:in `process_action'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/abstract_controller/base.rb:126:in `process'
/opt/rh/cfme-gemset/gems/actionview-5.0.0.1/lib/action_view/rendering.rb:30:in `process'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_controller/metal.rb:190:in `dispatch'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_controller/metal.rb:262:in `dispatch'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_dispatch/routing/route_set.rb:50:in `dispatch'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_dispatch/routing/route_set.rb:32:in `serve'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_dispatch/journey/router.rb:39:in `block in serve'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_dispatch/journey/router.rb:26:in `each'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_dispatch/journey/router.rb:26:in `serve'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_dispatch/routing/route_set.rb:725:in `call'
/opt/rh/cfme-gemset/gems/secure_headers-3.0.3/lib/secure_headers/middleware.rb:10:in `call'
/opt/rh/cfme-gemset/gems/rack-2.0.1/lib/rack/etag.rb:25:in `call'
/opt/rh/cfme-gemset/gems/rack-2.0.1/lib/rack/conditional_get.rb:38:in `call'
/opt/rh/cfme-gemset/gems/rack-2.0.1/lib/rack/head.rb:12:in `call'
/opt/rh/cfme-gemset/gems/rack-2.0.1/lib/rack/session/abstract/id.rb:222:in `context'
/opt/rh/cfme-gemset/gems/rack-2.0.1/lib/rack/session/abstract/id.rb:216:in `call'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_dispatch/middleware/cookies.rb:613:in `call'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_dispatch/middleware/callbacks.rb:38:in `block in call'
/opt/rh/cfme-gemset/gems/activesupport-5.0.0.1/lib/active_support/callbacks.rb:97:in `__run_callbacks__'
/opt/rh/cfme-gemset/gems/activesupport-5.0.0.1/lib/active_support/callbacks.rb:750:in `_run_call_callbacks'
/opt/rh/cfme-gemset/gems/activesupport-5.0.0.1/lib/active_support/callbacks.rb:90:in `run_callbacks'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_dispatch/middleware/callbacks.rb:36:in `call'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_dispatch/middleware/remote_ip.rb:79:in `call'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_dispatch/middleware/debug_exceptions.rb:49:in `call'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_dispatch/middleware/show_exceptions.rb:31:in `call'
/opt/rh/cfme-gemset/gems/railties-5.0.0.1/lib/rails/rack/logger.rb:36:in `call_app'
/opt/rh/cfme-gemset/gems/railties-5.0.0.1/lib/rails/rack/logger.rb:26:in `call'
/opt/rh/cfme-gemset/gems/request_store-1.3.1/lib/request_store/middleware.rb:9:in `call'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_dispatch/middleware/request_id.rb:24:in `call'
/opt/rh/cfme-gemset/gems/rack-2.0.1/lib/rack/method_override.rb:22:in `call'
/opt/rh/cfme-gemset/gems/rack-2.0.1/lib/rack/runtime.rb:22:in `call'
/opt/rh/cfme-gemset/gems/activesupport-5.0.0.1/lib/active_support/cache/strategy/local_cache_middleware.rb:28:in `call'
/opt/rh/cfme-gemset/gems/actionpack-5.0.0.1/lib/action_dispatch/middleware/executor.rb:12:in `call'
/opt/rh/cfme-gemset/gems/rack-2.0.1/lib/rack/sendfile.rb:111:in `call'
/opt/rh/cfme-gemset/gems/railties-5.0.0.1/lib/rails/engine.rb:522:in `call'
/opt/rh/rh-ruby23/root/usr/share/gems/gems/puma-3.3.0/lib/puma/configuration.rb:224:in `call'
/opt/rh/rh-ruby23/root/usr/share/gems/gems/puma-3.3.0/lib/puma/server.rb:561:in `handle_request'
/opt/rh/rh-ruby23/root/usr/share/gems/gems/puma-3.3.0/lib/puma/server.rb:406:in `process_client'
/opt/rh/rh-ruby23/root/usr/share/gems/gems/puma-3.3.0/lib/puma/server.rb:271:in `block in run'
/opt/rh/rh-ruby23/root/usr/share/gems/gems/puma-3.3.0/lib/puma/thread_pool.rb:111:in `block in spawn_thread'
[----] I, [2016-10-13T02:33:53.688746 #11878:1044efc]  INFO -- :   Rendered layouts/_exception_contents.html.haml (0.4ms)
[----] I, [2016-10-13T02:33:53.690728 #11878:1044efc]  INFO -- : Completed 200 OK in 83ms (Views: 3.5ms | ActiveRecord: 0.0ms)