Hello, I've done some more research. The same exception occurs when you want to search errata by issue date (without putting any keywords in the "Search For" field). In fact, it fails when, on postgresql, any of the two queries defined in file errata_handler.xml. I think that the following part of the query requires an explicit cast: ps.id = #sessionId# and
How could I debug this? Thanks, Pierre 2013/1/23 Steve Meier <em...@steve-meier.de> > 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@redhat.com > https://www.redhat.com/mailman/listinfo/spacewalk-list > > > > _______________________________________________ > Spacewalk-list mailing list > Spacewalk-list@redhat.com > https://www.redhat.com/mailman/listinfo/spacewalk-list >
_______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list
