OBIEE 11g: Error: "<BEA-000337> <[STUCK] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "1,276" seconds working on the request" and BI Server Crashes

(Doc ID 1495747.1)

Last updated on JANUARY 31, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.6.0 and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

You have installed OBIEE 11.1.1.6.0.  Often you suffer very slow performance or BI Server crashes.  To recover the system, you must re-start WebLogic Server, OPMN and then all the BI services.

If you examine bi_server1.log file, you see an error like the following repeating:

<Aug 18, 2012 11:49:53 AM EDT> <Error> <WebLogicServer> <CATL0AS461> <bi_server1> <[STANDBY] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <> <> <145c494ec18dcc31:76b19d11:139338e5633:-7ff9-000000000003b49d> <1345304993019> <BEA-000337> <[STUCK] ExecuteThread: '7' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "1,276" seconds working on the request "weblogic.servlet.internal.ServletRequestImpl@5a28b93[
GET /analytics/saw.dll?Dashboard&portalPath=%2fSHARED%2fCOXBI%2f_PORTAL%2fCOXBI HTTP/1.1
Connection: keep-alive
User-Agent: Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.79 Safari/537.1
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
Accept-Encoding: gzip,deflate,sdch
Accept-Language: en-US,en;q=0.8
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.3
Cookie: ORA_BIPS_LBINFO=1393a279ee0; JSESSIONID=R8SKQvnWfvZ9RNGn0Ht6NyXTrrT6Znn0Nw8Thl3pyMkptfc2f8Hr!1793161829; _WL_AUTHCOOKIE_JSESSIONID=fRpw7Ao5gukx6GxD14jj; ORA_BIPS_NQID=qeq9qd1a4834iuq86rgch8khb6uls7t0pjnfmg2zOr07UFe9WeFAU9; s_vi=[CS]v1|26F0719C05010924-60000110000005FA[CE]; __qca=P0-183808791-1306591827586; SMIDENTITY=6/9U4lLbKRw9lWt7PHJ3H5UxduErG5O3eMWFnPJGW3VFe/FmU9CF6bJRCGpBveiw1tTtIW4u8Fted6FWWQqLfV0EXXAjA0On5a3KEvz7t9YcnaKyY+KbU7YynIjYIOI7lsWlabqKuBjYd+fX7tnX1EgPS0MZ/Lm/1VO7RQ0q7+Rk4a6OvKgbkkZM7S1m7gNIWY/f0NUB4WAg2ncTe2QBAGpJ0uIuhtuvB7rEQvd6Gug/qvA+CYLj8Kr1K0u3FwHY0Zm09axRrVOlMlsKAawyoOZP3x13LNtT527yqzTx7MA2DDTDJv5QLQEFcbInWp7nvGVfZF8oGJLRemTagVmbQl8JHhpf1D49sv10uOVDR1Qrsj86wjTj6LrJwTXFxXbniBMh0DU52a7swr8WYogqONY86MTzSvcvkAdjhLf+7/DXu2YCwyYMRGxMJC9yQ35dI7WVx+8HAvok/HiY9BaGp18Ar4C/LhBATEUUcYbMDbTIfo8zx9oUMEZVGMfduGMpciDoq0PARBxVtnJiuVoAgM7fvblMN1431YX0RrqmMwBHZjcQiZjKZnam5bt7o6r9sv80P6GAialXASzKLZACLESqoklI0QFN8XketbeQFpW1lC1EydYzMlxnaJbkAddsZH3dAmTv9QPpUu2KBC3g4ybXvwrWmChqOeRghCcqSu+zPnAUfoDRmk+FOW7xbaio; __utma=93474114.2046001181.1331770854.1331770854.1331770854.1; __utmz=93474114.1331770854.1.1.utmcsr=ww2.cox.com|utmccn=(referral)|utmcmd=referral|utmcct=/residential/rhodeisland/tv/pay-per-view.cox; s_ev41=%5B%5B'sp_watch_pay-per-view_0312'%2C'1338031363180'%5D%2C%5B'ppvr_mc_2_ppv-ufc-146_5712'%2C'1338031371270'%5D%5D; location=RI+-+New+England; cox-current-zipcode=02895; coxwebmail=RI; cox-fontsize=small; cox-cart=cbecomm_items; cox-locale=Wj0wMjg5NV58XlQ9Ul58Xkw9XnxeSD1odHRwOi8vd3cyLmNveC5jb20vcmVzaWRlbnRpYWwvcmhvZGVpc2xhbmQvaG9tZS5jb3g; coxlocale=rhodeisland%3Ben_US; cox-current-site=rhodeisland; s_lv=1343501929371; s_vnum=1348788904896%26vn%3D9; s_ev20=%5B%5B'rhicr_sem_z_bun_bundle-deal'%2C'1341012902732'%5D%2C%5B'rhicr_sem_z_bun_bundle-deal'%2C'1343162174851'%5D%2C%5B'rhimv_ban_z_bun_q3_12q3'%2C'1343501929375'%5D%5D; cox-javascript=ajax; NSC_cj.dpy.dpn*443=ffffffff0948d70f45525d5f4f58455e445a4a4213d8
If-Modified-Since: Sat, 18 Aug 2012 14:33:58 GMT

]", which is more than the configured time (StuckThreadMaxTime) of "1,200" seconds. Stack trace:
java.net.SocketInputStream.socketRead0(Native Method)
java.net.SocketInputStream.read(SocketInputStream.java:129)
com.siebel.analytics.web.sawconnect.SAWConnection$NotifyInputStream.read(SAWConnection.java:165)
java.io.BufferedInputStream.fill(BufferedInputStream.java:218)
java.io.BufferedInputStream.read(BufferedInputStream.java:237)
com.siebel.analytics.web.sawconnect.sawprotocol.SAWProtocol.readInt(SAWProtocol.java:188)
com.siebel.analytics.web.sawconnect.sawprotocol.SAWProtocolInputStreamImpl.readChunkHeader(SAWProtocolInputStreamImpl.java:268)
com.siebel.analytics.web.sawconnect.sawprotocol.SAWProtocolInputStreamImpl.startReadingNewMessage(SAWProtocolInputStreamImpl.java:49)
com.siebel.analytics.web.sawconnect.SAWServletHttpBinding.forwardResponse(SAWServletHttpBinding.java:201)
com.siebel.analytics.web.SAWBridge.processRequest(SAWBridge.java:189)
com.siebel.analytics.web.SAWBridge.doGet(SAWBridge.java:224)
javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
com.siebel.analytics.web.integration.HyperionCSSAuthenticatorFilter.doFilter(HyperionCSSAuthenticatorFilter.java:106)
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
com.siebel.analytics.web.integration.ApplCoreSessionIntegrationFilter.doFilter(ApplCoreSessionIntegrationFilter.java:209)
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
com.siebel.analytics.web.integration.LoadBalancerHTTPFilter.doFilter(LoadBalancerHTTPFilter.java:177)
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)
java.security.AccessController.doPrivileged(Native Method)
oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:442)
oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)
oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)
oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:139)
weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
weblogic.work.ExecuteThread.run(ExecuteThread.java:178)

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