osa-dispatcher error after Satellite upgrade from 5.4.1 to 5.5

Solution Verified - Updated -

Issue

  • After upgrading Satellite from 5.4.1 to 5.5, starting osa-dispatcher throws the following traceback:
Starting osa-dispatcher: RHN 7063 2012/09/27 15:51:53 -04:00: ('Error caught:',)
RHN 7063 2012/09/27 15:51:53 -04:00: ('Traceback (most recent call last):
File "/usr/share/rhn/osad/jabber_lib.py", line 117, in main
self.setup_config(config)  
File "/usr/share/rhn/osad/osa_dispatcher.py", line 115, in setup_config    
self._password = self.get_dispatcher_password(self._username)  
File "/usr/share/rhn/osad/osa_dispatcher.py", line 74, in get_dispatcher_password
h.execute(jabber_id = username + "%")
File "/usr/lib/python2.4/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.4/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 108, in _execute_wrapper
retval = apply(function, p, kw)
File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 217, in _execute
return self._execute_(args, kwargs)
File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py", line 161, in _execute_
self._real_cursor.execute(*(None, ), **params)\nSQLStatementPrepareError: (\'ORA-00904: "PASSWORD": invalid identifier\
\', 904, \'select id, password from rhnPushDispatcher where jabber_id like :jabber_id\')\n',)
  • The command # rhn-schema-version returns no value

Environment

  • Red Hat Enterprise Linux 5
  • Red Hat Network Satellite Server 5.4.1 to 5.5 upgrade

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content