1405048 – Upgrade from 5.7@Oracle to 5.8@EmbPosgres - monitoring ent. is not removed

Bug 1405048 - Upgrade from 5.7@Oracle to 5.8@EmbPosgres - monitoring ent. is not removed

Summary: Upgrade from 5.7@Oracle to 5.8@EmbPosgres - monitoring ent. is not removed

Keywords:
Status:	CLOSED CURRENTRELEASE
Alias:	None
Product:	Red Hat Satellite 5
Classification:	Red Hat
Component:	Upgrades
Sub Component:
Version:	580
Hardware:	Unspecified
OS:	Unspecified
Priority:	unspecified
Severity:	unspecified
Target Milestone:	---
Assignee:	Tomáš Kašpárek
QA Contact:	Ales Dujicek
Docs Contact:
URL:
Whiteboard:
Depends On:
Blocks:	sat580-upgrades
TreeView+	depends on / blocked

Reported:	2016-12-15 12:59 UTC by Ales Dujicek
Modified:	2017-06-21 12:10 UTC (History)
CC List:	1 user (show)
Fixed In Version:	rhn-upgrade-5.8.0.10-1-sat
Doc Type:	If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed:	2017-06-21 12:10:12 UTC
Target Upstream Version:
Embargoed:

Attachments	(Terms of Use)

Description Ales Dujicek 2016-12-15 12:59:01 UTC

Description of problem:

I upgraded 5.7 with Oracle database to 5.8 with embedded

./install.pl --upgrade --disconnected
succeeded

but now I get ISE on page /rhn/admin/multiorg/SystemEntitlements.do

/var/log/tomcat6/catalina.out

2016-12-15 13:40:23,317 [TP-Processor8] ERROR com.redhat.rhn.frontend.servlets.SessionFilter - Error during transaction. Rolling back
javax.el.ELException: Error reading 'name' on type com.redhat.rhn.frontend.dto.SystemEntitlementsDto
	at javax.el.BeanELResolver.getValue(BeanELResolver.java:66)
	at javax.el.CompositeELResolver.getValue(CompositeELResolver.java:54)
	at org.apache.el.parser.AstValue.getValue(AstValue.java:118)
	at org.apache.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
	at org.apache.jasper.runtime.PageContextImpl.proprietaryEvaluate(PageContextImpl.java:913)
	at org.apache.jsp.WEB_002dINF.pages.admin.multiorg.sys_005fentitlements_jsp._jspx_meth_rl_005fcolumn_005f0(Unknown Source)
	at org.apache.jsp.WEB_002dINF.pages.admin.multiorg.sys_005fentitlements_jsp._jspx_meth_rl_005flist_005f0(Unknown Source)
	at org.apache.jsp.WEB_002dINF.pages.admin.multiorg.sys_005fentitlements_jsp._jspx_meth_rl_005flistset_005f0(Unknown Source)
	at org.apache.jsp.WEB_002dINF.pages.admin.multiorg.sys_005fentitlements_jsp._jspService(Unknown Source)
	at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:646)
	at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
	at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
	at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
	at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor.java:1083)
	at org.apache.struts.action.RequestProcessor.processForwardConfig(RequestProcessor.java:396)
	at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:232)
	at com.redhat.rhn.frontend.struts.RhnRequestProcessor.process(RhnRequestProcessor.java:105)
	at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
	at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:449)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.redhat.rhn.frontend.servlets.AuthFilter.doFilter(AuthFilter.java:127)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.opensymphony.sitemesh.webapp.SiteMeshFilter.obtainContent(SiteMeshFilter.java:129)
	at com.opensymphony.sitemesh.webapp.SiteMeshFilter.doFilter(SiteMeshFilter.java:77)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.redhat.rhn.frontend.servlets.LocalizedEnvironmentFilter.doFilter(LocalizedEnvironmentFilter.java:67)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.redhat.rhn.frontend.servlets.EnvironmentFilter.doFilter(EnvironmentFilter.java:101)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.redhat.rhn.frontend.servlets.SessionFilter.doFilter(SessionFilter.java:57)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at com.redhat.rhn.frontend.servlets.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:97)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:299)
	at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
	at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
	at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:769)
	at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:698)
	at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:891)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
	at java.lang.Thread.run(Thread.java:809)
Caused by: 
java.lang.NullPointerException
	at com.redhat.rhn.frontend.dto.SystemEntitlementsDto.getName(SystemEntitlementsDto.java:68)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:95)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:56)
	at java.lang.reflect.Method.invoke(Method.java:620)
	at javax.el.BeanELResolver.getValue(BeanELResolver.java:62)
	... 58 more
2016-12-15 13:40:25,521 [TP-Processor7] ERROR com.redhat


and system list page /rhn/systems/Overview.do leaves lot of localization errors in log

2016-12-15 13:40:25,521 [TP-Processor7] ERROR com.redhat.rhn.common.localization.LocalizationService - *** ERROR: Message with id: [monitoring_entitled] not found.*** called by com.redhat.rhn.frontend.dto.SystemOverview.getEntitlementLevel(SystemOverview.java:511)
2016-12-15 13:40:25,521 [TP-Processor7] ERROR com.redhat.rhn.common.localization.LocalizationService - *** ERROR: Message with id: [monitoring_entitled] not found.*** called by com.redhat.rhn.frontend.dto.SystemOverview.getEntitlementLevel(SystemOverview.java:511)


It looks like monitoring entitlement was not removed during upgrade


Version-Release number of selected component (if applicable):
rhn-upgrade-5.8.0.3-1.el6sat.noarch
satellite-schema-5.8.0.16-1.el6sat.noarch

Comment 4 Ales Dujicek 2017-01-04 12:32:35 UTC

I still see this monitoring related record in database after ugrade
not sure if it causes any problems but new 5.8 schema does not contain that

rhnschema=# select * from rhnorgentitlementtype ;
  2 | rhn_monitor                 | Red Hat Network Monitoring              | 2
016-06-09 02:35:03.123639-04 | 2016-06-09 02:35:03.123692-04


spacewalk-schema-2.5.1-27.el6sat.noarch
satellite-schema-5.8.0.17-1.el6sat.noarch
rhn-upgrade-5.8.0.7-1.el6sat.noarch

Comment 5 Ales Dujicek 2017-01-04 13:59:44 UTC

one more monitoring..

rhnschema_dup=# select * from rhnusergrouptype;
 11 | monitoring_admin     | Monitoring Administrator     | 2017-01-02 05:30:52-
05 | 2017-01-02 05:30:52-05

Comment 6 Ales Dujicek 2017-01-05 10:59:14 UTC

and monitoring related records in rhnfeature table

Data in [rhnfeature] for [rhnuser@DBNAME=RHNSCHEMA_DUP] and [rhnuser@DBNAME=SPACESCHEMA_CLWY4O]
select label, name from rhnfeature order by label, name
< ftr_probes Probes
< ftr_schedule_probe Schedule Probe

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