- 17.9K All Categories
- 3.3K Industry Applications
- 3.2K Intelligent Advisor
- 59 Insurance
- 534.1K On-Premises Infrastructure
- 137.6K Analytics Software
- 38.5K Application Development Software
- 5.3K Cloud Platform
- 109.1K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 70.8K Infrastructure Software
- 105.1K Integration
- 41.5K Security Software
OBIEE 11g BI Scheduler issue with 12c Databse on Node1
The initialization blocks in rpd fail when they try to connect and run queries on node1 of BI Server and given below error in nqserver.log
But these same initialization blocks run without issues when run on node 2 of BI Server.
We verified by shutting down node 2 and node 1 alternately and testing a BI scheduler report.
How can we debug why the DB connections from Node 1 of OracleBIServerComponent fails intermittently ?
As mentioned in the post details above this is a Windows based OBIEE 11g trying to connect to a PDB in Oracle 12c.
[2021-09-16T13:14:12.546+00:00] [OracleBIServerComponent] [ERROR:1]   [ecid: 0000Njij^QM4ykQyu^gskH1XGUuc000Ggq,0:1:1:6:6] [tid: 2dd4] [nQSError: 60009] The user request exceeded the maximum query governing execution time. [[
Business Intelligence Suite Enterprise Edition 220.127.116.11.200714
OS Version 2012 R2
Oracle 12c DB
Any hints and clues would really help to find out what is going on with the BI Server component on node 1.