| Summary: |
Sorting "Total Configured Systems" in Inventory Groups under Ansible Tower Provider fails. |
| Product: |
Red Hat CloudForms Management Engine
|
Reporter: |
Aziza Karol <akarol> |
| Component: |
UI - OPS | Assignee: |
Patrik Kománek <pkomanek> |
| Status: |
CLOSED
CURRENTRELEASE
|
QA Contact: |
Pavol Kotvan <pakotvan> |
| Severity: |
high
|
Docs Contact: |
|
| Priority: |
high
|
|
|
| Version: |
5.6.0 | CC: |
cpelland, gmccullo, hkataria, jhardy, jprause, mpovolny, obarenbo, simaishi
|
| Target Milestone: |
GA | Keywords: |
TestOnly, ZStream |
| Target Release: |
5.7.0 | |
|
| Hardware: |
Unspecified | |
|
| OS: |
Unspecified | |
|
| Whiteboard: |
ui:tower |
|
Fixed In Version:
|
5.7.0.0
|
Doc Type:
|
If docs needed, set a value
|
|---|
|
Doc Text:
|
|
Story Points:
|
---
|
|---|
|
Clone Of:
|
|
|---|
|
:
|
1353647 1356131
(view as bug list) |
Environment:
|
|
|
Last Closed:
|
2017-01-11 20:19:16 UTC
|
Type:
|
Bug
|
|---|
|
Regression:
|
---
|
Mount Type:
|
---
|
|---|
|
Documentation:
|
---
|
CRM:
|
|
|---|
|
Verified Versions:
|
|
Category:
|
Bug
|
|---|
|
oVirt Team:
|
---
|
RHEL 7.3 requirements from Atomic Host:
|
|
|---|
|
Cloudforms Team:
|
---
|
Target Upstream Version:
|
|
|---|
|
Embargoed:
|
|
| |
|---|
| Bug Depends On: |
|
|
|
| Bug Blocks: |
1353647, 1356131
|
|
|
| Attachments: |
|
Created attachment 1172765 [details] snpshot Description of problem: Version-Release number of selected component (if applicable): 5.6.0.13 How reproducible: 100% Steps to Reproduce: 1.Navigate to configuration management and add ansible tower provider 2.click on ansible tower configuration manager in Ansible tower provider 3.sort with "Total Configured Systems" in Inventory Groups under Ansible Tower Provider Actual results: sorting does not work for Total configured Systems. Expected results: sorting should work Additional info: production.log [----] I, [2016-06-27T01:53:23.854470 #3017:10f0144] INFO -- : Started POST "/provider_foreman/explorer?sortby=2&" for 127.0.0.1 at 2016-06-27 01:53:23 -0400 [----] I, [2016-06-27T01:53:23.856800 #3017:10f0144] INFO -- : Processing by ProviderForemanController#explorer as JS [----] I, [2016-06-27T01:53:23.856951 #3017:10f0144] INFO -- : Parameters: {"sortby"=>"2"} [----] F, [2016-06-27T01:53:23.902223 #3017:10f0144] FATAL -- : Error caught: [ActiveRecord::StatementInvalid] PG::UndefinedColumn: ERROR: column ems_folders.total_configured_systems does not exist LINE 1: ...FROM "ems_folders" WHERE (ems_id IN (3)) ORDER BY "ems_folde... ^ : SELECT "ems_folders".* FROM "ems_folders" WHERE (ems_id IN (3)) ORDER BY "ems_folders"."total_configured_systems" ASC LIMIT $1 OFFSET $2 /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:598:in `async_exec' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:598:in `block in exec_no_cache' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:566:in `block in log' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activesupport/lib/active_support/notifications/instrumenter.rb:21:in `instrument' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract_adapter.rb:560:in `log' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:598:in `exec_no_cache' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/postgresql_adapter.rb:587:in `execute_and_clear' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/postgresql/database_statements.rb:103:in `exec_query' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:373:in `select' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract/database_statements.rb:41:in `select_all' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:68:in `block in select_all' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:83:in `cache_sql' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/connection_adapters/abstract/query_cache.rb:68:in `select_all' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/querying.rb:39:in `find_by_sql' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/relation.rb:699:in `exec_queries' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/relation.rb:580:in `load' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/relation.rb:260:in `records' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/relation.rb:256:in `to_a' /var/www/miq/vmdb/app/models/miq_report/generator.rb:350:in `build_table' /var/www/miq/vmdb/app/models/miq_report/search.rb:114:in `paged_view_search' /var/www/miq/vmdb/app/controllers/application_controller.rb:1590:in `get_view' /var/www/miq/vmdb/app/controllers/application_controller/ci_processing.rb:1398:in `process_show_list' /var/www/miq/vmdb/app/controllers/provider_foreman_controller.rb:1169:in `process_show_list' /var/www/miq/vmdb/app/controllers/provider_foreman_controller.rb:594:in `provider_node' /var/www/miq/vmdb/app/controllers/provider_foreman_controller.rb:614:in `provider_list' /var/www/miq/vmdb/app/controllers/provider_foreman_controller.rb:544:in `get_node_info' /var/www/miq/vmdb/app/controllers/provider_foreman_controller.rb:835:in `leaf_record' /var/www/miq/vmdb/app/controllers/provider_foreman_controller.rb:820:in `replace_right_cell' /var/www/miq/vmdb/app/controllers/provider_foreman_controller.rb:424:in `explorer' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_controller/metal/basic_implicit_render.rb:4:in `send_action' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/abstract_controller/base.rb:188:in `process_action' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_controller/metal/rendering.rb:30:in `process_action' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/abstract_controller/callbacks.rb:20:in `block in process_action' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activesupport/lib/active_support/callbacks.rb:126:in `call' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activesupport/lib/active_support/callbacks.rb:126:in `call' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activesupport/lib/active_support/callbacks.rb:506:in `block (2 levels) in compile' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activesupport/lib/active_support/callbacks.rb:455:in `call' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activesupport/lib/active_support/callbacks.rb:455:in `call' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activesupport/lib/active_support/callbacks.rb:101:in `__run_callbacks__' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activesupport/lib/active_support/callbacks.rb:750:in `_run_process_action_callbacks' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activesupport/lib/active_support/callbacks.rb:90:in `run_callbacks' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/abstract_controller/callbacks.rb:19:in `process_action' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_controller/metal/rescue.rb:20:in `process_action' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_controller/metal/instrumentation.rb:32:in `block in process_action' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activesupport/lib/active_support/notifications.rb:164:in `block in instrument' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activesupport/lib/active_support/notifications/instrumenter.rb:21:in `instrument' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activesupport/lib/active_support/notifications.rb:164:in `instrument' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_controller/metal/instrumentation.rb:30:in `process_action' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_controller/metal/params_wrapper.rb:248:in `process_action' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activerecord/lib/active_record/railties/controller_runtime.rb:18:in `process_action' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/abstract_controller/base.rb:126:in `process' /opt/rh/cfme-gemset/gems/actionview-5.0.0.rc2/lib/action_view/rendering.rb:30:in `process' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_controller/metal.rb:190:in `dispatch' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_controller/metal.rb:262:in `dispatch' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_dispatch/routing/route_set.rb:50:in `dispatch' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_dispatch/routing/route_set.rb:32:in `serve' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_dispatch/journey/router.rb:39:in `block in serve' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_dispatch/journey/router.rb:26:in `each' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_dispatch/journey/router.rb:26:in `serve' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_dispatch/routing/route_set.rb:725:in `call' /opt/rh/cfme-gemset/gems/omniauth-1.3.1/lib/omniauth/strategy.rb:186:in `call!' /opt/rh/cfme-gemset/gems/omniauth-1.3.1/lib/omniauth/strategy.rb:164:in `call' /opt/rh/cfme-gemset/gems/omniauth-1.3.1/lib/omniauth/builder.rb:63: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.0.rc1/lib/rack/etag.rb:25:in `call' /opt/rh/cfme-gemset/gems/rack-2.0.0.rc1/lib/rack/conditional_get.rb:38:in `call' /opt/rh/cfme-gemset/gems/rack-2.0.0.rc1/lib/rack/head.rb:12:in `call' /opt/rh/cfme-gemset/gems/rack-2.0.0.rc1/lib/rack/session/abstract/id.rb:222:in `context' /opt/rh/cfme-gemset/gems/rack-2.0.0.rc1/lib/rack/session/abstract/id.rb:216:in `call' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_dispatch/middleware/cookies.rb:613:in `call' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_dispatch/middleware/callbacks.rb:38:in `block in call' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activesupport/lib/active_support/callbacks.rb:97:in `__run_callbacks__' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activesupport/lib/active_support/callbacks.rb:750:in `_run_call_callbacks' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activesupport/lib/active_support/callbacks.rb:90:in `run_callbacks' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_dispatch/middleware/callbacks.rb:36:in `call' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_dispatch/middleware/remote_ip.rb:79:in `call' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_dispatch/middleware/debug_exceptions.rb:49:in `call' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_dispatch/middleware/show_exceptions.rb:31:in `call' /opt/rh/cfme-gemset/gems/railties-5.0.0.rc2/lib/rails/rack/logger.rb:36:in `call_app' /opt/rh/cfme-gemset/gems/railties-5.0.0.rc2/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/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_dispatch/middleware/request_id.rb:24:in `call' /opt/rh/cfme-gemset/gems/rack-2.0.0.rc1/lib/rack/method_override.rb:22:in `call' /opt/rh/cfme-gemset/gems/rack-2.0.0.rc1/lib/rack/runtime.rb:22:in `call' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/activesupport/lib/active_support/cache/strategy/local_cache_middleware.rb:28:in `call' /opt/rh/cfme-gemset/bundler/gems/rails-3d9d4f56c1ee/actionpack/lib/action_dispatch/middleware/executor.rb:12:in `call' /opt/rh/cfme-gemset/gems/rack-2.0.0.rc1/lib/rack/sendfile.rb:111:in `call' /opt/rh/cfme-gemset/gems/railties-5.0.0.rc2/lib/rails/engine.rb:522:in `call' /opt/rh/rh-ruby22/root/usr/share/gems/gems/puma-3.3.0/lib/puma/configuration.rb:224:in `call' /opt/rh/rh-ruby22/root/usr/share/gems/gems/puma-3.3.0/lib/puma/server.rb:561:in `handle_request' /opt/rh/rh-ruby22/root/usr/share/gems/gems/puma-3.3.0/lib/puma/server.rb:406:in `process_client' /opt/rh/rh-ruby22/root/usr/share/gems/gems/puma-3.3.0/lib/puma/server.rb:271:in `block in run' /opt/rh/rh-ruby22/root/usr/share/gems/gems/puma-3.3.0/lib/puma/thread_pool.rb:111:in `call' /opt/rh/rh-ruby22/root/usr/share/gems/gems/puma-3.3.0/lib/puma/thread_pool.rb:111:in `block in spawn_thread' /opt/rh/cfme-gemset/gems/logging-1.8.2/lib/logging/diagnostic_context.rb:323:in `call' /opt/rh/cfme-gemset/gems/logging-1.8.2/lib/logging/diagnostic_context.rb:323:in `block in create_with_logging_context' [----] I, [2016-06-27T01:53:23.904130 #3017:10f0144] INFO -- : Rendered layouts/_exception_contents.html.haml (0.2ms) [----] I, [2016-06-27T01:53:23.904980 #3017:10f0144] INFO -- : Completed 200 OK in 48ms (Views: 1.8ms | ActiveRecord: 0.0ms)