Red Hat Bugzilla – Bug 997027
spacewalk-report host-guests failed - external oracle
Last modified: 2013-10-01 17:48:58 EDT
Description of problem:
I upgraded satellite from 5.5 to 5.6 (external oracle with customer's data).
Spacewalk-report with parameter host-guests is new feature in Satellite 5.6 and it doesn't work.
Version-Release number of selected component (if applicable):
always with backup customer database
Steps to Reproduce:
1. register some guests to satellite
2. run spacewalk-report host-guests
>>> spacewalk-report host-guests
SQL error occurred, traceback follows...
Traceback (most recent call last):
File "/usr/bin/spacewalk-report", line 198, in <module>
File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 163, in execute
return apply(self._execute_wrapper, (self._execute, ) p, kw)
File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 108, in _execute_wrapper
retval = apply(function, p, kw)
File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 217, in _execute
return self._execute_(args, kwargs)
File "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 161, in _execute_
self._real_cursor.execute(*(None, ), **params)
spacewalk.server.rhnSQL.sql_base.SQLStatementPrepareError: ('ORA-00911: invalid character\n', 911, 'select host_system_id as server_id, virtual_system_id as guests from rhnvirtualinstance where host_system_id is not null and virtual_system_id is not null order by server_id;')
Committed to Spacewalk master:
Satellite 5.6 has been released. This bug was tracked under the release.
This bug was either VERIFIED or RELEASE_PENDING (re-verified prior shortly
Moving to CLOSED CURRENT_RELEASE.
Text from Upgrade Erratum follows:
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.