Bug 657295 - systems/Overview.do fails if more than one system has a monitoring probe enabled
Summary: systems/Overview.do fails if more than one system has a monitoring probe enabled
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Spacewalk
Classification: Community
Component: WebUI
Version: 1.2
Hardware: x86_64
OS: Linux
low
medium
Target Milestone: ---
Assignee: Jan Pazdziora
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space12
TreeView+ depends on / blocked
 
Reported: 2010-11-25 11:57 UTC by wolf
Modified: 2010-11-26 15:39 UTC (History)
1 user (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2010-11-26 15:39:06 UTC
Embargoed:

Attachments (Terms of Use)
Traceback EMail (9.39 KB, text/plain)
2010-11-25 11:57 UTC, wolf 		no flags Details
View All

Description wolf 2010-11-25 11:57:31 UTC 
Created attachment 462876 [details]
Traceback EMail

Description of problem:

 If more then one system has a monitoring probe enabled, the systems/Overview.do page fails to load, generating the following error:

java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

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


How reproducible:

 easy

Steps to Reproduce:
1. create at least two hosts
2. create at least one probe for at least two hosts
3. goto the systems overview screen
  
Actual results:

 Page fails to load and generates error email


Expected results:

 Page loads and shows probe status etc. for all monitored systems
Additional info:
Comment 1 Jan Pazdziora 2010-11-26 13:30:33 UTC 
I believe this issue was fixed in 8fc790513588228feb21b97b590e63fa01bf64b and backported to Spacewalk 1.2 in 90c046fee5ec0d35d3672456f25294edf4f5490f.

Could you please upgrade your Spacewalk 1.2 with spacewalk-java-1.2.114-1?
Comment 2 wolf 2010-11-26 13:55:18 UTC 
After upgrading to spacewalk-java-1.2.114-1 the issue seems to be resolved.
Comment 3 Jan Pazdziora 2010-11-26 15:39:06 UTC 
Great, thanks for the info. Closing with CURRENTRELEASE.
Note You need to log in before you can comment on or make changes to this bug.