STUCK thread in OBIEE 11g — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

STUCK thread in OBIEE 11g

Received Response
83
Views
6
Comments
920799
920799 Rank 4 - Community Specialist
edited Aug 13, 2024 7:00PM in Oracle Analytics Cloud and Server

Hi All,

We have noticed OPMN crash and restart, while investigating, Noticed Biserver1 log (managed server log) there were some error STUCK

Error Log

####<Apr 12, 2016 8:09:05 AM CEST> <Info> <WorkManager> <host name> <bi_server1> <weblogic.timers.TimerThread> <<WLS Kernel>> <> <2e54f623ef1adad9:-466cf519:153c9970cbf:-8000-000000000001e18e> <1460441345534> <BEA-002936>

<maximum thread constraint weblogic.jms.BipJmsServer.Limited is reached>

####<Apr 12, 2016 8:35:21 AM CEST> <Error> <WebLogicServer> <host name> <bi_server1> <[ACTIVE] ExecuteThread: '13' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1460442921881> <BEA-000337> <[STUCK] ExecuteThread: '17' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "1,294" seconds working on the request "Workmanager: default, Version: 0, Scheduled=true, Started=true, Started time: 1294578 ms

[

GET /analytics/saw.dll?bieehome&startPage=1 HTTP/1.0

User-Agent: check_http/1.104 (nagios-plugins 1.4.9)

]", which is more than the configured time (StuckThreadMaxTime) of "1,200" seconds. Stack trace:

Thread-1929 "[STUCK] ExecuteThread: '17' for queue: 'weblogic.kernel.Default (self-tuning)'" <alive, in native, suspended, priority=1, DAEMON> {

    jrockit.net.SocketNativeIO.readBytesPinned(SocketNativeIO.java:???)

From Apr 12, 2016 8:15

we noticed OPMN started crashing one after one and restarted after some time.

does STUCK threads crash OPMN or Managed seeerver.

I checked all the logs, noticed no Errors which might caused the Crash.

Please provide me some details on this.

Thanks

Answers

  • Eric Min-Oracle
    Eric Min-Oracle Rank 2 - Community Beginner

    What is the exactly OBIEE version you are using?

    What is the oracle.bi.presentation.sawconnect.ConnectionPool.MaxConnections value of the parameter in file $middleware_home\user_projects\domains\bifoundation_domain\config\fmwconfig\biinstances\coreapplication\bridgeconfig.properties?

  • 920799
    920799 Rank 4 - Community Specialist

    Thanks for the Reply

    Oracle Business Intelligence Product Version 11.1.1.7.140715

    Below is the content of the file---  only 5 lines

    #This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control

    #Fri Mar 18 16:41:10 CET 2016

    oracle.bi.Secure=false

    oracle.bi.presentation.sawservers=199.6.###.###\:9710

    oracle.bi.presentation.OracleHardwareAcceleration=false

  • Eric Min-Oracle
    Eric Min-Oracle Rank 2 - Community Beginner

    Add oracle.bi.presentation.sawconnect.ConnectionPool.MaxConnections=512 to that file and see if that works.

    Ref: 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)

  • 920799
    920799 Rank 4 - Community Specialist

    Thanks Eric for the Reply..

    But We are fixing 2 reports which caused Stuck thread.

  • Eric Min-Oracle
    Eric Min-Oracle Rank 2 - Community Beginner

    Add oracle.bi.presentation.sawconnect.ConnectionPool.MaxConnections=512 you still get the same issue?

  • Adam Wickes
    Adam Wickes Rank 6 - Analytics Lead

    Just a thought but could the threads be stuck because OPMN crashed and not the cause of the crash itself?
    Also, what is your Java Heap Size set to?