[Spacewalk-list] Spacewalk 1.4 and Oracle 11g

[BUPE(Peter Burgstaller)]

Another issue that arose today:

Exception reported from spacewalk.myhost.com
Time: Thu May  5 18:45:49 2011
Exception type spacewalk.server.rhnSQL.sql_base.SQLError
Exception while handling function registration.add_packages
Request object information:
URI: /XMLRPC
Remote Host: 10.5.1.10
Server Name: spacewalk.myhost.com:443
Headers passed in:
Accept-Encoding: identity
Content-Length: 242019
Host: spacewalk.myhost.com:443
content-type: text/xml
user-agent: rhn.rpclib.py/$Revision$
x-client-version: 1
x-info: RPC Processor (C) Red Hat, Inc (version $Revision$)
x-rhn-client-capability:
osad.ping(1)=1,caneatCheese(1)=1,packages.extended_profile(2)=1,osad.rhn_check(1)=1,reboot.reboot(1)
=1,packages.verify(1)=1,packages.runTransaction(1)=1,packages.update(2)=2,packages.rollBack(1)=1
x-rhn-transport-capability: follow-redirects=3
x-transport-info: Extended Capabilities Transport (C) Red Hat, Inc (version $Revision$)
x-up2date-version: 1.4.16-1.el5
Extra information about this error:
SQL Error generated: (2291, 'ORA-02291: integrity constraint
(SPACEWALK.RHN_CLIENTCAP_CAP_NID_FK) violated - parent key not found\n', 'insert into
rhnClientCapability (server_id, capability_name_id, version) values (:server_id,
LOOKUP_CLIENT_CAPABILITY(:capability), :version)')

Exception Handler Information
Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/spacewalk/server/apacheRequest.py", line 119, in
call_function
    response = apply(func, params)
  File "/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 822, in add_packages
    packages = self._normalize_packages(system_id, packages)
  File "/usr/share/rhn/server/handlers/xmlrpc/registration.py", line 926, in
_normalize_packages
    rhnCapability.update_client_capabilities(self.server_id)
  File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnCapability.py", line 157, in
update_client_capabilities
    apply(h.executemany, (), inserts)
  File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/sql_base.py", line 172,
in executemany
    return apply(self._execute_wrapper, (self._executemany, ) + p, kw)
  File "/usr/lib/python2.4/site-packages/spacewalk/server/rhnSQL/driver_cx_Oracle.py",
line 127, in _execute_wrapper
    raise apply(sql_base.SQLError, ret)
SQLError: (2291, 'ORA-02291: integrity constraint (SPACEWALK.RHN_CLIENTCAP_CAP_NID_FK)
violated - parent key not found\n', 'insert into rhnClientCapability (server_id,
capability_name_id, version) values (:server_id, LOOKUP_CLIENT_CAPABILITY(:capability),
:version)')
... output cut ...

Seems a related problem.
Anyone know how to fix that?

--
DI Peter Burgstaller
-----------------------------------
Head of Hosted Services

SKIDATA AG
Untersbergstraße 40
A-5083 Grödig, Salzburg
[p] +43 (0) 6246 888-4155
[f] +43 (0) 6246 888-7
[e] peter.burgstaller at skidata.com
[w] http://www.skidata.com