"oracle.bam.adc.kernel.datasets.Dataset.acquireViewsetLock" Cross Tab Report Performance is Slow With Large Number of Records Results Stuck Threads (Doc ID 1443983.1)

Last updated on JUNE 01, 2015

Applies to:

Oracle BAM (Business Activity Monitoring) - Version 11.1.1.5.0 to 11.1.1.5.0 [Release 11gR1]
Information in this document applies to any platform.
***Checked for relevance on 25-September-2013***

Symptoms

While accessing a report with cross tab view, report is getting hung results stuck threads on the server.

Stuck Thread:

"[STUCK] ExecuteThread: '377' for queue: 'weblogic.kernel.Default (self-tuning)'" daemon prio=7 tid=600000000e7c4400 nid=5411 lwp_id=6017144 in Object.wait() [9ffffffc83ffc000]
java.lang.Thread.State: WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
at oracle.bam.system.threading.WaitHandle.waitOne(WaitHandle.java:277)
- locked <9ffffffe03468568> (a oracle.bam.system.threading.AutoResetEvent)
at oracle.bam.system.threading.AutoResetEvent.waitOne(AutoResetEvent.java:51)
- locked <9ffffffe03468568> (a oracle.bam.system.threading.AutoResetEvent)
at oracle.bam.adc.kernel.datasets.Dataset.acquireViewsetLock(Dataset.java:1179)
at oracle.bam.adc.kernel.viewsets.ViewsetManager.openViewsets(ViewsetManager.java:453)
at oracle.bam.adc.kernel.server.DataStoreServer.openViewsets(DataStoreServer.java:1158)
at oracle.bam.adc.ejb.BamAdcServerBean.openViewsets(BamAdcServerBean.java:869)
at sun.reflect.GeneratedMethodAccessor806.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at com.bea.core.repackaged.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:310)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at com.bea.core.repackaged.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at com.bea.core.repackaged.springframework.jee.intercept.MethodInvocationInvocationContext.proceed(MethodInvocationInvocationContext.java:104)
at oracle.bam.adc.ejb.BamAdcServerBean.interceptor(BamAdcServerBean.java:266)

...................




"[STUCK] ExecuteThread: '375' for queue: 'weblogic.kernel.Default (self-tuning)'" daemon prio=7 tid=600000000e7c1000 nid=5409 lwp_id=6017142 in Object.wait() [9ffffffc857fc000]
java.lang.Thread.State: TIMED_WAITING (on object monitor)
at java.lang.Object.wait(Native Method)
at weblogic.work.commonj.CommonjWorkManagerImpl$Callback.waitForAll(CommonjWorkManagerImpl.java:138)
- locked <9ffffffe529e1d18> (a weblogic.work.commonj.CommonjWorkManagerImpl$Callback)
at weblogic.work.commonj.CommonjWorkManagerImpl.waitForAll(CommonjWorkManagerImpl.java:72)
at oracle.bam.web.reportserver.views.ViewStreamer.getViewsInOneRoundTrip(ViewStreamer.java:123)
at sun.reflect.GeneratedMethodAccessor8055.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.bam.web.shared.WebPage.invokeWebMethod(WebPage.java:502)
at oracle.bam.web.shared.WebPage.processRequest(WebPage.java:436)
at oracle.bam.web.shared.WebPage.reportServerDefault(WebPage.java:1154)
at jsp_servlet._15008._reportserver.__default._jspService(__default.java:71)
at weblogic.servlet.jsp.JspBase.service(JspBase.java:34)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.bam.web.cache.ClientSideCache.doFilter(ClientSideCache.java:93)
.................



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