Intermittent Environment Issues,OBIEE Server Inaccessible In OBIEE 11g

(Doc ID 1491358.1)

Last updated on OCTOBER 09, 2017

Applies to:

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

Symptoms

You are finding that you are getting 20-25 nqsserver log files generated per day. You believe that the BI Server is restarting periodically which occurs at the same time that the log file is generated. At this time the users are not able to login however if they wait 10-15 minutes they then can login fine.

Clarifying two issues, which are likely related:

1.  Automatic restarts of NQserver

This application has requested the runtime to terminate it in an unusual way.
Please contact the application's support team for more information.
ORA-24550: signal received: Unhandled exception: Code=c0000005 Flags=0

2. Services are up, but login doesn't happen

[2012-06-19T12:48:14.000+00:00] [OracleBIClusterControllerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 178] Cluster Controller initialized
[2012-06-19T12:48:14.000+00:00] [OracleBIClusterControllerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 183c] [71070] A connection with Oracle BI Scheduler HBGNNEUAS22:9705 (monitor port 9708) was established.
[2012-06-19T12:48:16.000+00:00] [OracleBIClusterControllerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 7c4] [71021] An attempt to establish a connection with Oracle BI Server HBGNNEUAS22:9703 (monitor port 9701) failed.
[2012-06-19T12:48:19.000+00:00] [OracleBIClusterControllerComponent] [ERROR:1] [] [] [ecid: ] [tid: 183c] [71069] The connection with Oracle BI Scheduler HBGNNEUAS22:9705 (monitor port 9708) was lost.
[2012-06-19T12:48:19.000+00:00] [OracleBIClusterControllerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 183c] [71068] Oracle BI Scheduler HBGNNEUAS22:9705 has transitioned to offline state.
[2012-06-19T12:48:24.000+00:00] [OracleBIClusterControllerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 183c] [71070] A connection with Oracle BI Scheduler HBGNNEUAS22:9705 (monitor port 9708) was established.
[2012-06-19T13:02:31.000+00:00] [OracleBIClusterControllerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 810] [71026] Cluster Controller exiting.
[2012-06-19T13:02:31.000+00:00] [OracleBIClusterControllerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 810] [71026] Cluster Controller exiting.

 

In summary, the BI Server is crashing intermittently, however, the services are re-starting automatically and it is not obvious there is a NQServer crash occurring.


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