Bug 831057 - Displaying long error message on clicking monitor page for Global profile user
Summary: Displaying long error message on clicking monitor page for Global profile user
Keywords:
Status: CLOSED ERRATA
Alias: None
Product: CloudForms Cloud Engine
Classification: Retired
Component: aeolus-conductor
Version: 1.0.0
Hardware: Unspecified
OS: Unspecified
unspecified
medium
Target Milestone: rc
Assignee: Scott Seago
QA Contact: Rehana
URL:
Whiteboard:
Depends On:
Blocks: 832541
TreeView+ depends on / blocked
 
Reported: 2012-06-12 06:08 UTC by Rehana
Modified: 2012-12-04 15:10 UTC (History)
6 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
An ambiguous column name for ordering caused a long error message to appear when viewing the Monitor page for a Global Profile User. This bug fix corrects the database query. No error message appears when viewing the Monitor page.
Clone Of:
: 832541 (view as bug list)
Environment:
Last Closed: 2012-12-04 15:10:26 UTC
Embargoed:


Attachments (Terms of Use)
error_msg (267.03 KB, image/png)
2012-06-12 06:08 UTC, Rehana
no flags Details
Rails_log (21.03 KB, text/plain)
2012-06-12 06:08 UTC, Rehana
no flags Details


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHEA-2012:1516 0 normal SHIPPED_LIVE CloudForms Cloud Engine 1.1 update 2012-12-04 19:51:45 UTC

Description Rehana 2012-06-12 06:08:11 UTC
Created attachment 591098 [details]
error_msg

Description of problem:


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


How reproducible:
100%

Steps to Reproduce:
1.Create new user with Global profile user (default role)
2.Login to Conductor as Global profile user
3.Start a new VM
4.When the VM is in pending state, click on monitor
  
Actual results:
It will display a long error message on the UI

Expected results:
It should not display any error message on click of monitor .

PFA: attacher error screen shot (error_msg.png) and rails log(Rails_log)

Additional info:
 rpm -qa | grep aeolus
aeolus-configure-2.5.7-1.el6_3.noarch
aeolus-all-0.8.27-1.el6_3.noarch
aeolus-conductor-0.8.27-1.el6_3.noarch
aeolus-conductor-doc-0.8.27-1.el6_3.noarch
aeolus-conductor-daemons-0.8.27-1.el6_3.noarch
rubygem-aeolus-image-0.3.0-12.el6.noarch
rubygem-aeolus-cli-0.3.3-1.el6_3.noarch

Comment 1 Rehana 2012-06-12 06:08:48 UTC
Created attachment 591100 [details]
Rails_log

Comment 2 Rehana 2012-06-13 13:26:33 UTC
this error is observed for global zone user also

Comment 3 Scott Seago 2012-06-15 15:42:04 UTC
Subject: [PATCH conductor] bug 831057: fix ambiguous order by name

https://bugzilla.redhat.com/show_bug.cgi?id=831057

There was a deployments 'order by' clause that just listed 'name'
which was ambiguous (since the joined pool and pool_families models
also have a 'name' column)
---
 src/app/models/pool.rb |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/src/app/models/pool.rb b/src/app/models/pool.rb
index 6bd3605..c4acbce 100644
--- a/src/app/models/pool.rb
+++ b/src/app/models/pool.rb
@@ -124,7 +124,7 @@ class Pool < ActiveRecord::Base
 
     if options[:with_deployments]
       result[:deployments] = deployments.list_for_user(options[:current_user], Privilege::VIEW).
-                                         order('name asc').
+                                         order('deployments.name asc').
                                          paginate(:page => options[:page], :per_page => options[:per_page]).
                                          map {|d| d.as_json}
     end
--

Comment 4 Scott Seago 2012-06-15 16:15:17 UTC
Pushed to 1.0.1 at 22ffc7b96288a21b09f558c852309488025df0a3

Comment 6 Aziza Karol 2012-09-20 11:53:43 UTC
No error displayed when clicked  on monitor page while the VM is pending.

verified:
rpm -qa | grep aeolus
rubygem-aeolus-image-0.3.0-12.el6.noarch
aeolus-conductor-daemons-0.13.8-1.el6cf.noarch
rubygem-aeolus-cli-0.7.1-1.el6cf.noarch
aeolus-conductor-doc-0.13.8-1.el6cf.noarch
aeolus-configure-2.8.6-1.el6cf.noarch
aeolus-all-0.13.8-1.el6cf.noarch
aeolus-conductor-0.13.8-1.el6cf.noarch

Comment 8 errata-xmlrpc 2012-12-04 15:10:26 UTC
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

http://rhn.redhat.com/errata/RHEA-2012-1516.html


Note You need to log in before you can comment on or make changes to this bug.