Bug 1039519

Summary: ISE when adding Red Hat errata to a channel
Product: [Community] Spacewalk Reporter: Jiří Mikulka <jmikulka>
Component: WebUIAssignee: Tomas Lestach <tlestach>
Status: CLOSED WORKSFORME QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 2.1CC: rvdwees, xdmoon
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-01-24 10:27:40 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Bug Depends On:    
Bug Blocks: 1484117    

Description Jiří Mikulka 2013-12-09 10:33:35 UTC 
Description of problem:
Adding a Red Hat errata to a custom channel on Spacewalk 2.1 nightly @ Oracle ends up with ISE and traceback in catalina.out.

Version-Release number of selected component (if applicable):
Spacewalk 2.1 nightly
spacewalk-java-2.1.90-1.fc19.noarch

How reproducible:
always

Steps to Reproduce:
1. create some custom channel <channel>
2. go to Channels -> Manage Software Channels -> <channel> -> Errata -> Add -> Add Red Hat Errata

Actual results:
ISE occurs + traceback in catalina.out

[...]
Caused by: java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: ORA-00911: invalid character

	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:394)
	at com.redhat.rhn.common.db.NamedPreparedStatement.execute(NamedPreparedStatement.java:140)
	at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:467)
	at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:443)
	at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:345)
	at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:351)
	at com.redhat.rhn.common.db.datasource.CachedStatement.execute(CachedStatement.java:287)
	at com.redhat.rhn.common.db.datasource.SelectMode.execute(SelectMode.java:110)
	at com.redhat.rhn.manager.channel.ChannelManager.findErrataFromRhnSetForTarget(ChannelManager.java:2339)
	at com.redhat.rhn.frontend.action.channel.manage.AddRedHatErrataAction.getData(AddRedHatErrataAction.java:324)
	at com.redhat.rhn.frontend.action.channel.manage.AddRedHatErrataAction.execute(AddRedHatErrataAction.java:215)
	at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:425)
	... 41 more
[...]
Expected results:
no ISE, no traceback, one is able to add a Red Hat errata to the channel

Additional info:
only Oracle issue
Comment 1 Tomas Lestach 2014-01-24 10:27:40 UTC 
Closing, as neither me, not Jiri can reproduce the issue any more.
Comment 2 Eric Herget 2017-09-28 18:09:15 UTC 
This BZ closed some time during 2.5, 2.6 or 2.7.  Adding to 2.7 tracking bug.