[Spacewalk-list] Errata search by CVE fails

[Steve Meier]

Dear all,

I have just checked this on my local installation (Spacewalk 1.8 / Postgres / CentOS 5.9) and
I get the same error. The CVE is properly assigned to a CESA but Advanced Search failes with

Could not execute query 'CVE-2013-1083'.

I hope somebody has an answer to this :-)

Kind regards,
  Steve

Am 23.01.2013 um 21:02 schrieb Pierre Casenove:

> Hello list,
> I'm using spacewalk 1.8 on a rhel 5 server.
> I've been trying to search an errata by CVE.
> In the search field, I put the name of the CVE (for example CVE-2012-0611) and select "Search by CVE" but it fails with error "could not execute query".
> In the catalina.out file, I've got the following error:
> 2013-01-23 16:32:27,138 [TP-Processor8] WARN  com.redhat.rhn.frontend.action.errata.ErrataSearchAction - Performing errata search
> redstone.xmlrpc.XmlRpcFault: redstone.xmlrpc.XmlRpcFault:
> --- The error occurred in com/redhat/satellite/search/db/errata_handler.xml.
> --- The error occurred while applying a parameter map.
> --- Check the listErrataByCVE-InlineParameterMap.
> --- Check the statement (query failed).
> --- Cause: org.postgresql.util.PSQLException: ERROR: operator does not exist: numeric = character varying
> 
> Is this a known issue?
> 
> Thanks in advance,
> 
> Pierre 
> _______________________________________________
> Spacewalk-list mailing list
> Spacewalk-list at redhat.com
> https://www.redhat.com/mailman/listinfo/spacewalk-list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20130123/7dfb21f2/attachment.htm>