Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 657295

Summary: systems/Overview.do fails if more than one system has a monitoring probe enabled
Product: [Community] Spacewalk Reporter: wolf
Component: WebUIAssignee: Jan Pazdziora (Red Hat) <jpazdziora>
Status: CLOSED CURRENTRELEASE QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: medium Docs Contact:
Priority: low    
Version: 1.2CC: jpazdziora
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2010-11-26 15:39:06 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Bug Depends On:    
Bug Blocks: 623772    
Attachments:
Description Flags
Traceback EMail none

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 (Red Hat) 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 (Red Hat) 2010-11-26 15:39:06 UTC
Great, thanks for the info. Closing with CURRENTRELEASE.