<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>I just performed an upgrade from 1.5 to 1.6. After the upgrade, I am unable to view upgrades under software for any system. I can list the packages, but when I select Upgrade, I get Internal Server Error. This is the snip out of catalina.out with the error:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>2012-01-05 08:03:07,676 [TP-Processor5] ERROR com.redhat.rhn.common.db.datasource.CachedStatement - Error while processing cached statement sql: SELECT PN.id AS id,<o:p></o:p></p><p class=MsoNormal> PN.id AS name_id,<o:p></o:p></p><p class=MsoNormal> lookup_evr(((latest.evr)).epoch, (latest.evr).version, (latest.evr).release) AS evr_id,<o:p></o:p></p><p class=MsoNormal> latest.arch_id AS arch_id,<o:p></o:p></p><p class=MsoNormal> (latest.evr).epoch AS epoch,<o:p></o:p></p><p class=MsoNormal> (latest.evr).version AS version,<o:p></o:p></p><p class=MsoNormal> (latest.evr).release AS release,<o:p></o:p></p><p class=MsoNormal> PN.name AS name,<o:p></o:p></p><p class=MsoNormal> PN.name ||'-'|| evr_t_as_vre_simple(latest.evr) || (CASE WHEN latest.arch_id IS NULL THEN '' ELSE '.' || latest.arch_label END) AS nvrea,<o:p></o:p></p><p class=MsoNormal> PN.name ||'-'|| evr_t_as_vre_simple(PE.evr) || (CASE WHEN SP.package_arch_id IS NULL THEN '' ELSE '.' || PA.label END) AS installed_package,<o:p></o:p></p><p class=MsoNormal> PN.id || '|' || lookup_evr((latest.evr).epoch, (latest.evr).version, (latest.evr).release)|| '|' || latest.arch_id AS id_combo<o:p></o:p></p><p class=MsoNormal> FROM rhnPackageName PN,<o:p></o:p></p><p class=MsoNormal> rhnServerPackage SP<o:p></o:p></p><p class=MsoNormal> INNER JOIN rhnPackageEVR PE on SP.evr_id = PE.id<o:p></o:p></p><p class=MsoNormal> LEFT JOIN rhnPackageArch PA on SP.package_arch_id = PA.id,<o:p></o:p></p><p class=MsoNormal> (<o:p></o:p></p><p class=MsoNormal> SELECT P.name_id AS name_id, MAX(PE.evr) evr,<o:p></o:p></p><p class=MsoNormal> P.package_arch_id as arch_id, PA.label as arch_label<o:p></o:p></p><p class=MsoNormal> FROM rhnServerNeededCache SNC inner join<o:p></o:p></p><p class=MsoNormal> rhnPackage P on SNC.package_Id = P.id inner join<o:p></o:p></p><p class=MsoNormal> rhnPackageEVR PE on P.evr_id = PE.id inner join<o:p></o:p></p><p class=MsoNormal> rhnPackageArch PA on PA.id = P.package_arch_id<o:p></o:p></p><p class=MsoNormal> WHERE SNC.server_id = ?<o:p></o:p></p><p class=MsoNormal> GROUP BY P.name_id, P.package_arch_id, PA.label<o:p></o:p></p><p class=MsoNormal> ) latest<o:p></o:p></p><p class=MsoNormal> WHERE latest.name_id = PN.id<o:p></o:p></p><p class=MsoNormal> AND SP.server_id = ?<o:p></o:p></p><p class=MsoNormal> AND SP.name_id = PN.id<o:p></o:p></p><p class=MsoNormal> AND (SP.package_arch_id IS NULL OR SP.package_arch_id =<o:p></o:p></p><p class=MsoNormal> -- If the server has more than one package of this name installed<o:p></o:p></p><p class=MsoNormal> -- Then group by arch, otherwise just use whever is there<o:p></o:p></p><p class=MsoNormal> CASE WHEN (select 1 from rhnServerPackage sp2<o:p></o:p></p><p class=MsoNormal> where<o:p></o:p></p><p class=MsoNormal> sp2.name_id = latest.name_id and<o:p></o:p></p><p class=MsoNormal> sp2.server_id = ?<o:p></o:p></p><p class=MsoNormal> group by sp2.name_id having count(*) > 1<o:p></o:p></p><p class=MsoNormal> ) IS NOT NULL THEN latest.arch_id<o:p></o:p></p><p class=MsoNormal> ELSE SP.package_arch_id END<o:p></o:p></p><p class=MsoNormal> )<o:p></o:p></p><p class=MsoNormal>ORDER BY UPPER(PN.name)<o:p></o:p></p><p class=MsoNormal>com.redhat.rhn.common.db.WrappedSQLException: ORA-03113: end-of-file on communication channel<o:p></o:p></p><p class=MsoNormal>Process ID: 0<o:p></o:p></p><p class=MsoNormal>Session ID: 382 Serial number: 39757<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Steve Kent<o:p></o:p></p></div>
<p><pre>
CONFIDENTIAL NOTICE : If you have received this email in error,
please immediately notify the sender by email at the address
shown above. This email may contain confidential or legally
privileged information that is intended only for the use of the
individual or entity named in this email. If you are not the
intended recipient, you are hereby notified that any
disclosure, copying, distribution or reliance upon the contents
of this email is strictly prohibited. Please delete from your
files if you are not the intended recipient. Thank you for your
compliance.
</pre></p>
</body></html>