search cancel

After upgrade to 21.2.4, 21.2.5 global search returns Undefined

book

Article ID: 228355

calendar_today

Updated On:

Products

CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

After upgrade to 21.2.4 or 21.2.5, global search returns Undefined for anything entered into the search box. 
This is the same behavior whether Scope is All or Scope is "Search Device and Interface Names"


Additionally in the PCService.log an error is seen :

WARN  | qtp1234567-123456     | YYYY-MM-DD HH:MM:SS,### | com.ca.im.portal.site.ModelMgr
      | Exception updating model 98098_1 to stage Initialize
java.util.NoSuchElementException: Template properties are not allowed for users. PageID=98098 ModelID=265
 at com.ca.im.portal.services.config.DBModelPropertiesImpl.Load(DBModelPropertiesImpl.java:465)
 at com.ca.im.portal.services.config.PageServiceImpl.getPageUserPropLevels(PageServiceImpl.java:357)
 at com.ca.im.portal.site.report.models.UniversalViewSearchModel.createView(UniversalViewSearchModel.java:625)
 at com.ca.im.portal.site.report.models.UniversalViewSearchModel.initialize(UniversalViewSearchModel.java:96)
 at com.ca.im.portal.site.ModelMgr.updateModels(ModelMgr.java:1061)
 at com.ca.im.portal.site.ModelMgr.updateModels(ModelMgr.java:1111)
 at com.ca.im.portal.site.ModelMgr.updateModels(ModelMgr.java:1111)
 at com.ca.im.portal.site.ModelMgr.updateModels(ModelMgr.java:1111)
 at com.ca.im.portal.site.ModelMgr.updateModels(ModelMgr.java:1111)
 at com.ca.im.portal.site.ModelMgr.updateModels(ModelMgr.java:1111)
 at com.ca.im.portal.site.ModelMgr.updateModels(ModelMgr.java:1111)
 at com.ca.im.portal.site.ModelMgr.updateModels(ModelMgr.java:1111)
 at com.ca.im.portal.site.ModelMgr.catchUpModels(ModelMgr.java:956)
 at com.ca.im.portal.site.ModelMgr.updateModels(ModelMgr.java:923)
 at com.ca.im.portal.render.desktop.DesktopRenderMgr.processClientRequest(DesktopRenderMgr.java:328)
 at com.ca.im.portal.desktop.PageData.doPost(PageData.java:167)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
 at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1443)
 at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:791)
 at org.eclipse.jetty.servlet.ServletHandler$ChainEnd.doFilter(ServletHandler.java:1626)
 at org.eclipse.jetty.websocket.server.WebSocketUpgradeFilter.doFilter(WebSocketUpgradeFilter.java:228)
 at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
 at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601)
 at com.ca.im.portal.common.web.security.RequestFilter.doFilter(RequestFilter.java:38)
 at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
 at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601)
 at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
 at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:106)
 at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
 at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601)
 at com.ca.im.portal.AuthenticationFilter.doFilterInner(AuthenticationFilter.java:216)
 at com.ca.im.portal.AuthenticationFilter.doFilter(AuthenticationFilter.java:86)
 at org.eclipse.jetty.servlet.FilterHolder.doFilter(FilterHolder.java:193)
 at org.eclipse.jetty.servlet.ServletHandler$Chain.doFilter(ServletHandler.java:1601)
 at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:548)
 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
 at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602)
 at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
 at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235)
 at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624)
 at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
 at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1435)
 at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
 at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501)
 at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594)
 at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
 at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1350)
 at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
 at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:191)
 at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146)
 at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
 at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:322)
 at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127)
 at org.eclipse.jetty.server.Server.handle(Server.java:516)
 at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388)
 at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633)
 at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380)
 at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277)
 at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
 at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
 at org.eclipse.jetty.io.ssl.SslConnection$DecryptedEndPoint.onFillable(SslConnection.java:540)
 at org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:395)
 at org.eclipse.jetty.io.ssl.SslConnection$2.succeeded(SslConnection.java:161)
 at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105)
 at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104)
 at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)
 at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)
 at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)
 at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)
 at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:383)
 at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:882)
 at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1036)
 at java.lang.Thread.run(Thread.java:748)

Environment

Dx NetOps Performance Management 21.2.4 and 21.2.5

 

Cause

A change in column settings

Resolution

Run the following in MySql, on the netops portal

1) Log into mysql:

mysql netqosportal -u netqos -p

Enter the mysql password when prompted.

2) Run:

use netqosportal;

delete from model_properties where pageid=98098 and tenantid=8 and userid<>0 and modelid=265;

exit

Additional Information

There should be no issues going forward, it's a 1 time upgrade issue.

The new column settings are being saved to diff pageids which don't cause an issue.