[Spacewalk-list] ProtocolError XMLRPC: 500 Internal Server Error when syncing to profile

[Jan Pazdziora]

On Thu, Mar 24, 2011 at 09:18:03PM +1300, Craig Ward wrote:
> Seems to be complaining of an invalid table name??
> 
> Exception reported from server
> Time: Thu Mar 24 15:51:09 2011
> Exception type <CENSORED!>.server.rhnSQL.sql_base.SQLStatementPrepareError
> Exception while handling function queue.get Request object information:
> URI: /XMLRPC
> Remote Host: wagertst02.testcell.tab.co.nz Server Name: server:0
> Headers passed in:
>        Accept-Encoding: identity
>        Content-Length: 2726
>        Host: server
>        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,packages.verifyAll(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,osad.ping(1)=1,packages.verifyAll(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.3.12-1.el5
> Extra information about this error:
> SQL Error generated: ('ORA-00903: invalid table name\n', 903, 'select
> tro.label as operation, pn.name, pe.version, pe.release, pe.epoch,
> pa.label as package_arch from rhnPackageDeltaElement pde,
> rhnTransactionPackage rp left join rhnPackageArch pa on
> rp.package_arch_id = pa.id, rhnTransactionOperation tro,
> rhnPackageName pn, rhnPackageEVR pe, where pde.package_delta_id =

Please use patch from

	http://git.fedorahosted.org/git/?p=spacewalk.git;a=commitdiff;h=659d27036cf7f4b43afaacbf8de3c726453ae6e2

Yours,

-- 
Jan Pazdziora
Principal Software Engineer, Satellite Engineering, Red Hat