My Oracle Support Banner

Fusion Applications OTBI: HTTP Error 500--Internal Server Error, Unable to connect to the BI Presentation Server, When I Tried To Create Analysis, caused by Stuck Threads (Doc ID 1633926.1)

Last updated on JANUARY 26, 2021

Applies to:

Oracle Fusion Common CRM Cloud Service - Version 11.1.5.0.0 and later
Oracle Fusion Application Toolkit - Version 11.1.1.5.1 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.5.0.0 and later
Information in this document applies to any platform.

Symptoms

Fusion Cloud 11.1.7 - error when attempt to Create Report/analysis

This was working fine yesterday


You encounter the error below when run from "Reports and Analytics" I try to Create an analysis

ERROR1
-------------

Error 500--Internal Server Error
From RFC 2068 Hypertext Transfer Protocol -- HTTP/1.1:
10.5.1 500 Internal Server Error

The server encountered an unexpected condition which prevented it from fulfilling the request.

You will find below the error msg that you can see from Sales Page...

ERROR 2
---------------

Unable to connect to the BI Presentation Server. Please ensure that it is running, configured properly, and that the connection details within this application are correct.Exceeded failed connection tries. ConnectionId=BIPresentationServer
Unable to connect to the BI Presentation Server. Please ensure that it is running, configured properly, and that the connection details within this application are correct.Exceeded failed connection tries. ConnectionId=BIPresentationServer

ERROR3
--------------

When you tried to connect to Analytics with the url https://<HostName>/analytics/saw.dll?catalog I received only a blank page with the message "Signing In ...."

 

DAGNOSTICS

--------------------

Cloud EM shows that all components are up and running 

Logs shows:


<Mar 7, 2014 1:34:57 PM UTC> <Error> <WebLogicServer> <BEA-000337> <[STUCK] ExecuteThread: '10' for queue: 'weblogic.kernel.Default (self-tuning)' has been busy for "638" seconds working on the request "Workmanager: default, Version: 0, Scheduled=true, Started=true, Started time: 638758 ms
[
POST /analytics-ws/saw.dll?SoapImpl=nQSessionService HTTP/1.1
Content-type: text/xml; charset=utf-8
Soapaction: "#impersonateex"
Accept: text/xml, multipart/related, text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2
User-Agent: Oracle JAX-WS 2.1.5
Content-Length: 3576
VIRTUAL_HOST_TYPE: internal
ECID-Context: 1.004x0GfncMrCKujK_2e9Uq0Pp0009Yd;kYjE0ZDLIPGJj1QRXSPUoPROnTBTnVBSXNUB^SOR
Connection: Keep-Alive
X-Forwarded-For: 
Proxy-Client-IP: 
X-WebLogic-KeepAliveSecs: 30
X-WebLogic-Request-ClusterInfo: true
x-weblogic-cluster-hash: TmWDOvdWrXJoDWhn/uy

]", which is more than the configured time (StuckThreadMaxTime) of "600" seconds. Stack trace:
Thread-230 "[STUCK] ExecuteThread: '10' for queue: 'weblogic.kernel.Default (self-tuning)'" <alive, in native, suspended, priority=1, DAEMON> {
 


>

FileName
----------------
biserver1.out

FileComment
----------------------
shows stuck threads during communications with OBIPS


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.