Bug 1039519 - ISE when adding Red Hat errata to a channel
Summary: ISE when adding Red Hat errata to a channel
Keywords:
Status: CLOSED WORKSFORME
Alias: None
Product: Spacewalk
Classification: Community
Component: WebUI
Version: 2.1
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
Assignee: Tomas Lestach
QA Contact: Red Hat Satellite QA List
URL:
Whiteboard:
Depends On:
Blocks: space27
TreeView+ depends on / blocked
 
Reported: 2013-12-09 10:33 UTC by Jiří Mikulka
Modified: 2017-09-28 18:09 UTC (History)
2 users (show)

Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2014-01-24 10:27:40 UTC
Embargoed:


Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Bugzilla 1053436 1 None None None 2021-01-20 06:05:38 UTC

Internal Links: 1053436

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.


Note You need to log in before you can comment on or make changes to this bug.