Bug 1302817

Summary: rhn-satellite-exporter is using broken queries for --whole-errata option
Product: Red Hat Satellite 5 Reporter: Jan Dobes <jdobes>
Component: ServerAssignee: Jan Dobes <jdobes>
Status: CLOSED ERRATA QA Contact: Radovan Drazny <rdrazny>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 570CC: dyordano, psegedy, pstudeni, rdrazny, tkasparek, tlestach
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: spacewalk-backend-2.3.3-35-sat Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-03-17 13:51:18 UTC Type: Bug
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: 1127217    

Description Jan Dobes 2016-01-28 17:03:47 UTC 
Description of problem:
When running rhn-satellite-exporter with --start-date, --end-date and --whole-errata parameters, there are various issues.

1. When exporting with --use-sync-date parameter, rhn-satellite-exporter crashes.
2. When exporting with --use-rhn-date parameter (or none parameter), package ids without any errata are not included in channel XML, even the packages themselves XMLs are included in package directory.

Version-Release number of selected component (if applicable):
spacewalk-backend-2.3.3-33.el6sat.noarch

How reproducible:
always

Steps to Reproduce:
1. Have custom channel with errata and packages, and some packages without relevant errata.
2. Experiment with rhn-satellite-exporter with parameters described above.

Actual results:
results described above

Expected results:
no crashes, even packages without related errata are exported
Comment 1 Jan Dobes 2016-01-28 17:14:26 UTC 
fixed in spacewalk master:

0455d0877eebbed84d7a6dcfed5adab4a754095d
e7346ca9b385e1a5913299cd9983b6d2cddb67fa
Comment 4 Jan Dobes 2016-02-19 10:05:53 UTC 
*** Bug 863093 has been marked as a duplicate of this bug. ***
Comment 7 errata-xmlrpc 2016-03-17 13:51:18 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.

https://rhn.redhat.com/errata/RHBA-2016-0461.html