Fusion Applications Financials Hyperion Workspace : Slow/hang when Accessing Workspace, log error Stuck Threads In Bi_server1 (Doc ID 1578193.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

Oracle Fusion Application Toolkit - Version 11.1.3.0.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version N/A and later
Oracle Fusion General Ledger Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Fusion Applications Financials 11.1.3.0.0 - Financial Reporting Workspace


Issue accessing the BI Workspace it was very slow or hanging, when we reviewed the logs, there were errors and stuck threads errors. After bouncing the full BI stack it worked fine.

Incident log mentions https://hostname/hr/modules/com/hyperion/reporting/web/reportViewer/HRHtmlReport

INFO: DFW-40101 An incident has been signalled with the incident facts: [problemKey=BEA-337 [WebLogicServer] incidentSource=SYSTEM incidentTime=Thu Apr 11 10:51:48 SAST 2013 errorMessage=BEA-337 executionContextId=004qX718M2rEWNd5lfP5iZ0001bT0004FC]
INFO: incident 254 created with problem key "BEA-337 [WebLogicServer]"

[INFO ][memory ][Thu Apr 11 10:51:50 2013][1365670310095][22536] [YC#61] 116047.702-116047.826: YC 7848539KB->5020243KB (8388608KB), 0.125 s, sum of pauses 124.331 ms, longest pause 124.331 ms.
INFO: 02101 Blocking request due to missing or invalid CSRF token: /workspace/logon/ping


INFO: PERF: 0000300013 ReportStoreManagerImpl retrieveObject(/shared/Financials/CFR/RFA/RFA_TB in IS & BS Format, 2)
INFO: PERF: 0000300013 ReportStoreManagerImpl retrievePersistentObject(/shared/Financials/CFR/RFA/RFA_TB in IS & BS Format, 2)
ERROR:
com.hyperion.reporting.util.HyperionReportException: ; nested exception is:
  java.lang.NullPointerException
  at com.hyperion.reporting.reportstore.ReportStoreManagerImpl.retrieveObject(Unknown Source)
  at com.hyperion.reporting.reportstore.ReportStoreManagerImpl.retrievePersistentObject(Unknown Source)
  at com.hyperion.reporting.webviewer.WebDynamicReport.getCurrDesign(Unknown Source)
  at com.hyperion.reporting.webviewer.WebDynamicReport.buildUserPov(Unknown Source)
  at com.hyperion.reporting.webviewer.WebDynamicReport.getUserPOV(Unknown Source)
  at com.hyperion.reporting.webviewer.WebDynamicReport.getUserPOVXML(Unknown Source)
  at jsp_servlet._modules._com._hyperion._reporting._web._reportviewer.__hrrunjob._jspService(__hrru
  
  
  
  
  WARNING: SawUtil.impersonate: [saw user name:FUSION_APPS_BI_SYSTEM_APPID, impersonate id: om05871]
WARNING: java.rmi.RemoteException: User name: FUSION_APPS_BI_SYSTEM_APPID, Impersonate id: om05871; Authentication error. Couldn't complete authentication within specified timeout.; nested exception is:
javax.xml.ws.soap.SOAPFaultException: Authentication error. Couldn't complete authentication within specified timeout.
at oracle.xdo.service.report.saw.wrapper.v7.AbstractSawSessionService.impersonateex(AbstractSawSessionService.java:141)
at oracle.xdo.service.report.saw.wrapper.v7.SawSessionServiceImpl.impersonateex(SawSessionServiceImpl.java:141)
at oracle.xdo.service.report.saw.SawUtil.impersonate(SawUtil.java:284)
at oracle.xdo.servlet.data.SawDataSourceImpl.getSessionId(SawDataSourceImpl.java:301)
at oracle.xdo.service.report.saw.SawUtil.getSessionId(SawUtil.java:928)
at oracle.xdo.service.report.saw.SawUtil.setSessionId(SawUtil.java:1079)
at oracle.xdo.servlet.security.BaseSecurityHandler.handleBIEECatalogIntegration(BaseSecurityHandler.java:1344)
at oracle.xdo.servlet.security.SecurityFilter.handleContainerSecurity(SecurityFilter.java:886)
at oracle.xdo.servlet.security.SecurityFilter.handleSSO(SecurityFilter.java:659)
at oracle.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:149)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
at oracle.xdo.servlet.init.InitCheckingFilter.doFilter(InitCheckingFilter.java:64)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:57)
at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:27)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused by: javax.xml.ws.soap.SOAPFaultException: Authentication error. Couldn't complete authentication within specified timeout.
at com.siebel.analytics.web.jaxwsutils.DirectSoapCaller.invokeSoapMethod(DirectSoapCaller.java:222)
at com.siebel.analytics.web.jaxwsutils.SAWSOAPTcpConnector.invokeSoapMethod(SAWSOAPTcpConnector.java:77)
at com.siebel.analytics.web.jaxwsutils.SOAPInterfaceProxy.invoke(SOAPInterfaceProxy.java:206)
at $Proxy199.impersonateex(Unknown Source)
at oracle.xdo.service.report.saw.wrapper.v7.AbstractSawSessionService.impersonateex(AbstractSawSessionService.java:135)
... 29 more

[INFO ][memory ][Thu Apr 11 11:21:41 2013][1365672101458][22536] [YC#67] 117839.156-117839.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms