Description of problem: Specifying --org <org-id> for spacewalk-export fails to export system-profiles Version-Release number of selected component (if applicable): spacewalk-utils-2.0.2-16.el6sat.noarch How reproducible: Try "spacewalk-export --org 1" Actual results: === ~ $ spacewalk-export --org 1 INFO: Processing users... INFO: Processing system-groups... INFO: Processing config-files... INFO: Processing repositories... INFO: Processing channels... Processing organization: RED HAT SATELLITE ENGINEERING INFO: Processing activation-keys... INFO: Processing kickstart-scripts... INFO: Processing system-profiles... Unknown column [org_id] in report [system-profiles]. INFO: Export-file created at /root/spacewalk-export-dir/spacewalk_export.tar.gz === Expected results: === ~ $ spacewalk-export --org 1 INFO: Processing users... INFO: Processing system-groups... INFO: Processing config-files... INFO: Processing repositories... INFO: Processing channels... Processing organization: RED HAT SATELLITE ENGINEERING INFO: Processing activation-keys... INFO: Processing kickstart-scripts... INFO: Processing system-profiles... INFO: Export-file created at /root/spacewalk-export-dir/spacewalk_export.tar.gz === Additional info: spacewalk-report system-profiles calls it 'organization_id' Workaround: Export system-profiles directly: # spacewalk-report --where-organization-id <ID> system-profiles > ~/spacewalk-export-dir/exports/system-profiles.csv
spacewalk commit 0310f02553ed4475ccedf93746631b2b832fe4a6
Reproduced with spacewalk-utils-2.0.2-27 using the reproducer in the initial report. # spacewalk-export --org 1 INFO: Processing users... INFO: Processing system-groups... INFO: Processing config-files... INFO: Processing repositories... INFO: Processing channels... Processing organization: Red Hat SatTeam QA INFO: Processing activation-keys... INFO: Processing kickstart-scripts... INFO: Processing system-profiles... Unknown column [org_id] in report [system-profiles]. INFO: Export-file created at /root/spacewalk-export-dir/spacewalk_export.tar.gz The file /root/spacewalk-export-dir/exports/system-profiles.csv is empty, and the same file in the /root/spacewalk-export-dir/spacewalk_export.tar.gz archive is empty as well (naturally). Updated to spacewalk-utils-2.0.2-28 # spacewalk-export --org 1 INFO: Processing users... INFO: Processing system-groups... INFO: Processing config-files... INFO: Processing repositories... INFO: Processing channels... Processing organization: Red Hat SatTeam QA INFO: Processing activation-keys... INFO: Processing kickstart-scripts... INFO: Processing system-profiles... INFO: Export-file created at /root/spacewalk-export-dir/spacewalk_export.tar.gz There is no error in the output. Checking the /root/spacewalk-export-dir/exports/system-profiles.csv shows correctly exported csv file, and the /root/spacewalk-export-dir/spacewalk_export.tar.gz archive contains correctly exported file as well. VERIFIED
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-1866.html
*** Bug 1275207 has been marked as a duplicate of this bug. ***