TN DocumentTypes not getting listed in MWS TN console in 9.9

Abir_Banerjee1 · May 3, 2016, 4:35pm

Hi Team,

I am facing an issue in webMethods 9.9 TN/MWS . When I am searching for any document type in TN it is not listing any documents at all. It is giving an error message,

9999:wm.tn.portal.queries:getQueryResults 9999:wm.tn.portal.queries:getQueryResults

I am attaching a document with the details. Kindly please share your inputs on the same.

Thanks and Regards
Abir Banerjee
TN DocType Issue.docx (158 KB)

Holger_von_Thomsen · May 3, 2016, 6:17pm

Hi Abir,

any further messages in IS server or error logs?
Or in one of the MWS logs?

Does doing an empty search return any results?

Please check if TN_9.9_MWS_Fix1 has been applied to MWS.

Regards,
Holger

MR_as173d · May 3, 2016, 6:39pm

Please share complete log message. Also, try to increase Cache memory both in IS & MWS servers.

Thanks,

Venkata_V · May 4, 2016, 12:27am

Which database are U using? I observed this issue myself when using MSSQLSERVER 2014

Abir_Banerjee1 · May 4, 2016, 9:35am

@Holger

Please find the MWS logs below. We are getting error there.

We have installed TN_9.9_MWS_Fix1 in MWS.
We are not getting any results with empty search also.
We are not getting any results when we are trying to search transactions also.

full.log

2016-05-04 03:28:55 EDT (jsf:INFO) [RID:21235] - 9999:wm.tn.portal.queries:getQueryResults

9999:wm.tn.portal.queries:getQueryResults

2016-05-04 03:28:55 EDT (jsf:INFO) [RID:21235] - com.webMethods.portlet.tn.utils.TNException: 9999:wm.tn.portal.queries:getQueryResults

9999:wm.tn.portal.queries:getQueryResults

at com.webmethods.portlet.tn.utils.TNException.getNewException(TNException.java:52)
at com.webmethods.portlet.tn.utils.TNException.getNewException(TNException.java:40)
at com.webmethods.caf.wm_tn_dt_searchresults.Wm_tn_dt_searchResultsDefaultviewView.getCurrentPage(Wm_tn_dt_searchResultsDefaultviewView.java:243)
at com.webmethods.caf.wm_tn_dt_searchresults.Wm_tn_dt_searchResultsDefaultviewView.getLatestPage(Wm_tn_dt_searchResultsDefaultviewView.java:369)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.sun.el.parser.AstValue.invoke(AstValue.java:254)
at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:302)
at com.sun.faces.application.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:87)
at com.webmethods.caf.faces.application.CAFMethodBinding.invoke(CAFMethodBinding.java:70)
at com.webmethods.caf.faces.data.object.PageableTableContentProvider.refreshPage(PageableTableContentProvider.java:220)
at com.webmethods.caf.faces.data.object.PageableTableContentProvider.callPageService(PageableTableContentProvider.java:203)
at com.webmethods.caf.faces.data.object.PageableTableContentProvider.isRowAvailable(PageableTableContentProvider.java:175)
at com.webmethods.caf.faces.component.table.html.DataTable.isRowAvailable(DataTable.java:200)
at com.webmethods.caf.faces.component.table.html.DataTable.setRowIndex(DataTable.java:371)
at com.webmethods.caf.faces.render.html.table.DataTotalRenderer.startTotal(DataTotalRenderer.java:128)
at com.webmethods.caf.faces.render.html.table.DataTotalRenderer.encodeBegin(DataTotalRenderer.java:56)
at javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:864)
at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:302)
at com.sun.faces.renderkit.html_basic.GroupRenderer.encodeChildren(GroupRenderer.java:114)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:889)
at com.webmethods.caf.faces.component.util.ComponentUtils.renderComponent(ComponentUtils.java:97)
at com.webmethods.caf.faces.render.html.panel.BlockEdgePanelRenderer.encodeEnd(BlockEdgePanelRenderer.java:62)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:919)
at com.webmethods.caf.faces.component.util.ComponentUtils.renderComponent(ComponentUtils.java:105)
at com.webmethods.caf.faces.component.util.ComponentUtils.renderComponent(ComponentUtils.java:102)
at com.webmethods.caf.faces.render.BaseRenderer.renderComponent(BaseRenderer.java:303)
at com.webmethods.caf.faces.render.html.table.TableRenderer.writeTableHeader(TableRenderer.java:344)
at com.webmethods.caf.faces.render.html.table.TableRenderer.encodeBegin(TableRenderer.java:104)
at javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:864)
at javax.faces.component.UIData.encodeBegin(UIData.java:1133)
at com.webmethods.caf.faces.component.table.html.DataTable.encodeBegin(DataTable.java:681)
at com.webmethods.caf.faces.component.table.html.AsyncTable.encodeBegin(AsyncTable.java:84)
at com.webmethods.caf.faces.component.util.ComponentUtils.renderComponent(ComponentUtils.java:94)
at com.webmethods.caf.faces.component.util.ComponentUtils.renderComponent(ComponentUtils.java:102)
at com.webmethods.caf.faces.render.BaseRenderer.renderComponent(BaseRenderer.java:303)
at com.webmethods.caf.faces.render.BaseRenderer.encodeChildren(BaseRenderer.java:44)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:889)
at com.webmethods.caf.faces.component.panel.BaseHideablePanel.encodeChildren(BaseHideablePanel.java:177)
at com.webmethods.caf.faces.component.util.ComponentUtils.renderComponent(ComponentUtils.java:97)
at com.webmethods.caf.faces.component.util.ComponentUtils.renderComponent(ComponentUtils.java:102)
at com.webmethods.caf.faces.component.util.ComponentUtils.renderComponent(ComponentUtils.java:102)
at com.webmethods.caf.faces.component.util.ComponentUtils.renderComponent(ComponentUtils.java:102)
at com.webmethods.caf.faces.view.CafViewDeclarationLanguage.renderResponse(CafViewDeclarationLanguage.java:186)
at com.webmethods.caf.faces.view.CafViewDeclarationLanguage.renderView(CafViewDeclarationLanguage.java:121)
at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:133)
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:337)
at com.webmethods.caf.faces.portlet.PortletViewHandler.renderView(PortletViewHandler.java:66)
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:337)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:120)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
at com.webmethods.caf.faces.portlet.PortletLifecycle.phase(PortletLifecycle.java:297)
at com.webmethods.caf.faces.portlet.PortletLifecycle.render(PortletLifecycle.java:240)
at com.webmethods.caf.faces.portlet.FacesPortlet.render(FacesPortlet.java:459)
at com.webmethods.portal.framework.portletcontainer.impl.PortletApplicationHandler.process(PortletApplicationHandler.java:540)
at com.webmethods.portal.framework.portletcontainer.servlet.PortletServlet.service(PortletServlet.java:60)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:595)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.Dispatcher.include(Dispatcher.java:115)
at com.webmethods.portal.framework.portletcontainer.PortletContainer.dispatch(PortletContainer.java:223)
at com.webmethods.portal.framework.portletcontainer.PortletContainer.process(PortletContainer.java:132)
at com.webmethods.portal.framework.portletcontainer.PortletContainer.renderPortlet(PortletContainer.java:105)
at com.webmethods.portal.framework.portletcontainer.beans.PortletBean.processRequest(PortletBean.java:195)
at com.webmethods.portal.framework.portletcontainer.beans.PortletBean.getContentInternal(PortletBean.java:83)
at com.webmethods.portal.framework.portlet.beans.BasicPortletBean.getContent(BasicPortletBean.java:151)
at com.webmethods.portal.mech.portlet.impl.PortletMechanics.getPortletContent(PortletMechanics.java:96)
at com.webmethods.portal.mech.storage.page.PortletHelper.initializeRuntimeProperties(PortletHelper.java:270)
at com.webmethods.portal.mech.storage.page.PortletHelper.initializeRuntimeProperties(PortletHelper.java:329)
at com.webmethods.portal.mech.storage.page.PortletHelper.getFullyInitializedBean(PortletHelper.java:385)
at com.webmethods.portal.mech.portlet.impl.PortletMechanics.resolveWiringProperty(PortletMechanics.java:626)
at com.webmethods.portal.mech.portlet.impl.PortletMechanics.resolveWiring(PortletMechanics.java:605)
at com.webmethods.portal.mech.storage.page.PortletHelper.initializeWiredProperties(PortletHelper.java:251)
at com.webmethods.portal.mech.storage.page.PortletHelper.getInitializedBean(PortletHelper.java:361)
at com.webmethods.portal.mech.storage.page.PortletHelper.getInitializedBean(PortletHelper.java:346)
at com.webmethods.portal.framework.presentation.renderers.PortalPageSubRenderer.findMaximizedPortlet(PortalPageSubRenderer.java:557)
at com.webmethods.portal.framework.presentation.renderers.PortalPageSubRenderer.renderContent(PortalPageSubRenderer.java:133)
at com.webmethods.portal.framework.presentation.renderers.PortalPageSubRenderer.subrender(PortalPageSubRenderer.java:124)
at com.webmethods.portal.framework.presentation.renderers.NoodleRenderer.renderPageContent(NoodleRenderer.java:67)
at com.webmethods.portal.framework.presentation.renderers.DefaultRenderer.render(DefaultRenderer.java:341)
at com.webmethods.portal.framework.presentation.PresentationManager.handlePres(PresentationManager.java:434)
at com.webmethods.portal.framework.dispatch.DispatchManager.pres(DispatchManager.java:705)
at com.webmethods.portal.framework.dispatch.DispatchManager.handle(DispatchManager.java:535)
at com.webmethods.portal.framework.dispatch.DispatchManager.handleDispatch(DispatchManager.java:434)
at com.webmethods.portal.framework.impl.PortalServlet.service(PortalServlet.java:325)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:83)
at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:364)
at com.webmethods.caf.faces.servlet.GZIPFilter.doFilter(GZIPFilter.java:48)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
at com.webmethods.portal.framework.impl.NTLMV1Filter.doFilter(NTLMV1Filter.java:67)
at com.webmethods.portal.framework.impl.NTLMFilter.doFilter(NTLMFilter.java:26)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
at com.webmethods.portal.framework.impl.RequestFilter.doFilter(RequestFilter.java:63)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
at com.webmethods.portal.framework.impl.JsfPartialAjaxRequestFilter.doFilter(JsfPartialAjaxRequestFilter.java:77)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
at com.webmethods.portal.framework.impl.SpnegoFilterWrapper.doFilter(SpnegoFilterWrapper.java:85)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:110)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at com.webmethods.portal.webapp.jetty7.MwsServer.handle(MwsServer.java:127)
at org.eclipse.jetty.server.Server.handle(Server.java:497)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
at java.lang.Thread.run(Thread.java:745)

2016-05-04 03:28:55 EDT (jsf:INFO) [RID:21235] - 9999:wm.tn.portal.queries:getQueryResults

9999:wm.tn.portal.queries:getQueryResults

: 9999:wm.tn.portal.queries:getQueryResults

9999:wm.tn.portal.queries:getQueryResults

2016-05-04 03:28:55 EDT (jsf:INFO) [RID:21235] - No result(s).

: No result(s).

2016-05-04 03:28:57 EDT (Framework:INFO) [RID:21236] - Request [23n15ne4la9g5nlsdvdbuvc6:Administrator] http://localhost:8585/ (GET)
2016-05-04 03:28:58 EDT (Framework:INFO) [RID:21237] - Request [23n15ne4la9g5nlsdvdbuvc6:Administrator] http://localhost:8585/wm_timezone.settimezone (GET)
2016-05-04 03:29:02 EDT (Framework:INFO) [RID:21238] - Request [23n15ne4la9g5nlsdvdbuvc6:Administrator] http://localhost:8585/meta/default/wm_xt_fabricfolder/0000008084 (POST)
2016-05-04 03:29:02 EDT (Framework:INFO) [RID:21239] - Request [23n15ne4la9g5nlsdvdbuvc6:Administrator] http://localhost:8585/meta/default/wm_xt_fabricfolder/0000008084 (GET)
2016-05-04 03:29:02 EDT (Framework:INFO) [WS:282] - WebService Request: http://www.oasis-open.org/committees/security completed in 4
2016-05-04 03:29:02 EDT (Framework:INFO) [WS:283] - WebService Request: http://www.oasis-open.org/committees/security completed in 3
2016-05-04 03:29:02 EDT (Framework:INFO) [WS:284] - WebService Request: http://www.oasis-open.org/committees/security completed in 2
2016-05-04 03:29:02 EDT (Framework:INFO) [WS:285] - WebService Request: http://www.oasis-open.org/committees/security completed in 2
2016-05-04 03:29:02 EDT (jsf:INFO) [RID:21239] - No result(s).

: No result(s).

2016-05-04 03:29:03 EDT (Framework:INFO) [RID:21240] - Request [23n15ne4la9g5nlsdvdbuvc6:Administrator] http://localhost:8585/ (GET)

Abir_Banerjee1 · May 4, 2016, 9:37am

@Venkata

We are using Oracle 11g.

Venkata_V · May 4, 2016, 9:45am

What O/S and version are you using? Are U using AWS?

I would raise it with Software AG on this.

There is a similar topic with no resolution.

Abir_Banerjee1 · May 4, 2016, 9:46am

SQL in server.log while querying for TN transactions

[5680]2016-05-04 03:42:36 EDT [TNS.0004.1012T] Requested page is not available
[5679]2016-05-04 03:42:36 EDT [TNS.0002.1082T] Query thread started. Repo path: TNPortalQueryResults_5f603b00ahtbfsl10000000n
[5678] d.DocTimestamp DESC
[5677]ORDER BY
[5676] d.ReceiverID = r.PartnerID
[5675] d.SenderID = s.PartnerID AND
[5674] d.DocTypeID = t.TypeID AND
[5673]WHERE
[5672] BizDoc d
[5671] Partner r,
[5670] Partner s,
[5669] BizDocTypeDef t,
[5668]FROM
[5667] d.DocTypeID
[5666] d.UserStatus,
[5665] d.RoutingStatus,
[5664] r.OrgUnitName AS ReceiverUnit,
[5663] r.CorporationName AS ReceiverCorp,
[5662] d.ReceiverID,
[5661] s.OrgUnitName AS SenderUnit,
[5660] s.CorporationName AS SenderCorp,
[5659] d.SenderID,
[5658] t.TypeName,
[5657] d.DocTimestamp,
[5656] d.DocID,
[5655]2016-05-04 03:42:36 EDT [TNS.0000.2097T] SELECT
[5654]2016-05-04 03:42:36 EDT [TNS.0000.2097T] >>>BasicData:Hides=[GroupID, ConversationID, NativeID, Comments, JobStatus, SenderProfileGroup, ReceiverProfileGroup],AttribQueries=,Shows={},AggregatingQuery=null,SortBy=[0][Ljava.lang.String;@725644cd,IntervalType=-1<<<
[5653]2016-05-04 03:42:36 EDT [TNS.0000.2063T] Querying document store.

logs in the full.log in MWS

2016-05-04 03:42:36 EDT (jsf:INFO) [RID:21495] - 9999:wm.tn.portal.queries:getQueryResults

9999:wm.tn.portal.queries:getQueryResults

2016-05-04 03:42:36 EDT (jsf:INFO) [RID:21495] - com.webMethods.portlet.tn.utils.TNException: 9999:wm.tn.portal.queries:getQueryResults

9999:wm.tn.portal.queries:getQueryResults

at com.webmethods.portlet.tn.utils.TNException.getNewException(TNException.java:52)
at com.webmethods.portlet.tn.utils.TNException.getNewException(TNException.java:40)
at com.webmethods.portlet.wm_tn_ta_searchresults.Wm_tn_ta_searchResultsViewPage.getCurrentPage(Wm_tn_ta_searchResultsViewPage.java:499)
at com.webmethods.portlet.wm_tn_ta_searchresults.Wm_tn_ta_searchResultsViewPage.getLatestPage(Wm_tn_ta_searchResultsViewPage.java:541)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at com.sun.el.parser.AstValue.invoke(AstValue.java:254)
at com.sun.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:302)
at com.sun.faces.application.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:87)
at com.webmethods.caf.faces.application.CAFMethodBinding.invoke(CAFMethodBinding.java:70)
at com.webmethods.caf.faces.data.object.PageableTableContentProvider.refreshPage(PageableTableContentProvider.java:220)
at com.webmethods.caf.faces.data.object.PageableTableContentProvider.callPageService(PageableTableContentProvider.java:203)
at com.webmethods.caf.faces.data.object.PageableTableContentProvider.isRowAvailable(PageableTableContentProvider.java:175)
at com.webmethods.caf.faces.component.table.html.DataTable.isRowAvailable(DataTable.java:200)
at com.webmethods.caf.faces.component.table.html.DataTable.setRowIndex(DataTable.java:371)
at com.webmethods.caf.faces.render.html.table.DataTotalRenderer.startTotal(DataTotalRenderer.java:128)
at com.webmethods.caf.faces.render.html.table.DataTotalRenderer.encodeBegin(DataTotalRenderer.java:56)
at javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:864)
at com.sun.faces.renderkit.html_basic.HtmlBasicRenderer.encodeRecursive(HtmlBasicRenderer.java:302)
at com.sun.faces.renderkit.html_basic.GroupRenderer.encodeChildren(GroupRenderer.java:114)
at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:889)
at com.webmethods.caf.faces.component.util.ComponentUtils.renderComponent(ComponentUtils.java:97)
at com.webmethods.caf.faces.render.html.panel.BlockEdgePanelRenderer.encodeEnd(BlockEdgePanelRenderer.java:62)
at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:919)
at com.webmethods.caf.faces.component.util.ComponentUtils.renderComponent(ComponentUtils.java:105)
at com.webmethods.caf.faces.component.util.ComponentUtils.renderComponent(ComponentUtils.java:102)
at com.webmethods.caf.faces.render.BaseRenderer.renderComponent(BaseRenderer.java:303)
at com.webmethods.caf.faces.render.html.table.TableRenderer.writeTableHeader(TableRenderer.java:344)
at com.webmethods.caf.faces.render.html.table.TableRenderer.encodeBegin(TableRenderer.java:104)
at javax.faces.component.UIComponentBase.encodeBegin(UIComponentBase.java:864)
at javax.faces.component.UIData.encodeBegin(UIData.java:1133)
at com.webmethods.caf.faces.component.table.html.DataTable.encodeBegin(DataTable.java:681)
at com.webmethods.caf.faces.component.table.html.AsyncTable.encodeBegin(AsyncTable.java:84)
at com.webmethods.caf.faces.component.util.ComponentUtils.renderComponent(ComponentUtils.java:94)
at com.webmethods.caf.faces.component.util.ComponentUtils.renderComponent(ComponentUtils.java:102)
at com.webmethods.caf.faces.component.util.ComponentUtils.renderComponent(ComponentUtils.java:102)
at com.webmethods.caf.faces.component.util.ComponentUtils.renderComponent(ComponentUtils.java:102)
at com.webmethods.caf.faces.component.util.ComponentUtils.renderComponent(ComponentUtils.java:102)
at com.webmethods.caf.faces.view.CafViewDeclarationLanguage.renderResponse(CafViewDeclarationLanguage.java:186)
at com.webmethods.caf.faces.view.CafViewDeclarationLanguage.renderView(CafViewDeclarationLanguage.java:121)
at com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:133)
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:337)
at com.webmethods.caf.faces.portlet.PortletViewHandler.renderView(PortletViewHandler.java:66)
at javax.faces.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:337)
at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:120)
at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
at com.webmethods.caf.faces.portlet.PortletLifecycle.phase(PortletLifecycle.java:297)
at com.webmethods.caf.faces.portlet.PortletLifecycle.render(PortletLifecycle.java:240)
at com.webmethods.caf.faces.portlet.FacesPortlet.render(FacesPortlet.java:459)
at com.webmethods.portal.framework.portletcontainer.impl.PortletApplicationHandler.process(PortletApplicationHandler.java:540)
at com.webmethods.portal.framework.portletcontainer.servlet.PortletServlet.service(PortletServlet.java:60)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:587)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:595)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.Dispatcher.include(Dispatcher.java:115)
at com.webmethods.portal.framework.portletcontainer.PortletContainer.dispatch(PortletContainer.java:223)
at com.webmethods.portal.framework.portletcontainer.PortletContainer.process(PortletContainer.java:132)
at com.webmethods.portal.framework.portletcontainer.PortletContainer.renderPortlet(PortletContainer.java:105)
at com.webmethods.portal.framework.portletcontainer.beans.PortletBean.processRequest(PortletBean.java:195)
at com.webmethods.portal.framework.portletcontainer.beans.PortletBean.getContentInternal(PortletBean.java:83)
at com.webmethods.portal.framework.portlet.beans.BasicPortletBean.getContent(BasicPortletBean.java:151)
at com.webmethods.portal.mech.portlet.impl.PortletMechanics.getPortletContent(PortletMechanics.java:96)
at com.webmethods.portal.mech.storage.page.PortletHelper.initializeRuntimeProperties(PortletHelper.java:270)
at com.webmethods.portal.mech.storage.page.PortletHelper.initializeRuntimeProperties(PortletHelper.java:329)
at com.webmethods.portal.mech.storage.page.PortletHelper.getFullyInitializedBean(PortletHelper.java:385)
at com.webmethods.portal.mech.portlet.impl.PortletMechanics.resolveWiringProperty(PortletMechanics.java:626)
at com.webmethods.portal.mech.portlet.impl.PortletMechanics.resolveWiring(PortletMechanics.java:605)
at com.webmethods.portal.mech.storage.page.PortletHelper.initializeWiredProperties(PortletHelper.java:251)
at com.webmethods.portal.mech.storage.page.PortletHelper.getInitializedBean(PortletHelper.java:361)
at com.webmethods.portal.mech.storage.page.PortletHelper.getInitializedBean(PortletHelper.java:346)
at com.webmethods.portal.framework.presentation.renderers.PortalPageSubRenderer.findMaximizedPortlet(PortalPageSubRenderer.java:557)
at com.webmethods.portal.framework.presentation.renderers.PortalPageSubRenderer.renderContent(PortalPageSubRenderer.java:133)
at com.webmethods.portal.framework.presentation.renderers.PortalPageSubRenderer.subrender(PortalPageSubRenderer.java:124)
at com.webmethods.portal.framework.presentation.renderers.NoodleRenderer.renderPageContent(NoodleRenderer.java:67)
at com.webmethods.portal.framework.presentation.renderers.DefaultRenderer.render(DefaultRenderer.java:341)
at com.webmethods.portal.framework.presentation.PresentationManager.handlePres(PresentationManager.java:434)
at com.webmethods.portal.framework.dispatch.DispatchManager.pres(DispatchManager.java:705)
at com.webmethods.portal.framework.dispatch.DispatchManager.handle(DispatchManager.java:535)
at com.webmethods.portal.framework.dispatch.DispatchManager.handleDispatch(DispatchManager.java:434)
at com.webmethods.portal.framework.impl.PortalServlet.service(PortalServlet.java:325)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:808)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1669)
at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:83)
at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:364)
at com.webmethods.caf.faces.servlet.GZIPFilter.doFilter(GZIPFilter.java:48)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
at com.webmethods.portal.framework.impl.NTLMV1Filter.doFilter(NTLMV1Filter.java:67)
at com.webmethods.portal.framework.impl.NTLMFilter.doFilter(NTLMFilter.java:26)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
at com.webmethods.portal.framework.impl.RequestFilter.doFilter(RequestFilter.java:63)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
at com.webmethods.portal.framework.impl.JsfPartialAjaxRequestFilter.doFilter(JsfPartialAjaxRequestFilter.java:77)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
at com.webmethods.portal.framework.impl.SpnegoFilterWrapper.doFilter(SpnegoFilterWrapper.java:85)
at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1652)
at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:585)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1127)
at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1061)
at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:110)
at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
at com.webmethods.portal.webapp.jetty7.MwsServer.handle(MwsServer.java:127)
at org.eclipse.jetty.server.Server.handle(Server.java:497)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:310)
at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
at java.lang.Thread.run(Thread.java:745)

2016-05-04 03:42:36 EDT (jsf:INFO) [RID:21495] - 9999:wm.tn.portal.queries:getQueryResults

9999:wm.tn.portal.queries:getQueryResults

: 9999:wm.tn.portal.queries:getQueryResults

9999:wm.tn.portal.queries:getQueryResults

Venkata_V · May 4, 2016, 9:52am

Check this empower post

https://empower.softwareag.com/sl24sec/SecuredServices/KCFullTextASP/viewing/view.asp?KEY=121682-9095968&DSN=PIVOTAL&DST=TCD&HL=1&QUERY=IS_9.9_Core_Fix2&SessionID=222087731

Abir_Banerjee1 · May 4, 2016, 10:56am

Hi All,

The issue has been resolved. The below property set to -1.

tn.query.threshold=-1

Thanks all for your responses.

Regards
Abir