OBIEE 11g Architecture

In this article we will briefly explain the new OBIEE 11g architecture and its components.

BIEE11gArchitecture

We can identify two main component types the OBIEE 11g: The A) Java Components and the B) System Components.

 

A) Java Components: These are basically J2EE applications running in Weblogic Server. There are two subcomponents here: 1. Admin Server and 2. Managed Server. Each of them running in a dedicated Java virtual machine (JVM).
  1. Admin Server: This is nothing more than a set of J2EE applications that will help us Administering the system:
  • Admin Console (WLS) — An adminstrative user interface that provides advanced management for Weblogic, JEE components, and security
  • Fusion Middleware Control — An administrative user interface that is used to manage the BI domain.
  • JMX MBeans — Java components that provide programmatic access for managing a BI domain.
  1. Managed Server: These are J2EE applications which will help the functioning of the BIEE System (highlighted in RED):
  • BI Plugin — It routes HTTP and SOAP requests to BI Presentation Services.
  • BI Security — It enables the integration of BIEE Server and Fusion Middleware security platform through webservices calls.
  • BI Action Services — It provides the dedicated Web services that are required by the Action Framework (a nice introduction can be found here, another example of use is here and here) and that enable an administrator to manually configure which Web service directories can be browsed by users when they create actions.
  •  Webservices SOA — This component provides Web services for objects in the BIEE Presentation Catalog, to invoke analysis, agents, and conditions.
  • BI Office — This component provides the integration between Oracle Business Intelligence and Microsoft Office products.

and finally

  • Two particular applications: BI Publisher (Reporting System) and RTD (technology platform which enable the analysis of data and provides insight by using data mining algorithms and techniques in real time).

B) System Components: These are non-J2EE components, such as processes and services written in C++ and java.

  • BI Server — It provides capabilities to query and access data as well as services for accessing and managing the RPD file (BIEE Metadata).
  • BI Presentation Services — It provides the framework and interface for the presentation of business intelligence data to Web clients. It maintains an Oracle BI Presentation Catalog service on the file system for the customization of this presentation framework.
  • BI Scheduler — Provides extensible scheduling for analyses to be delivered to users at specified times. (BI Publisher has its own scheduler.)
  • BI JavaHost — It enables BI Presentation Services to support various components: Java tasks for BI Scheduler, BI Publisher, and Graph generation.
  • BI Cluster Controller — It distributes requests to the BI Server, ensuring requests are evenly load-balanced across all BI Server process instances in the BI domain.

In addition, the BI Domain requires a set of configuration files, the repository (RPD) file, the Presentation Catalog files, etc. Likewise, BIEE System uses a set of metadata tables stored in a relational database like Oracle.

How to Start BIEE System: There are multiple ways to start the BIEE System, but it must follow certain order. Based on the description given above we need to :

1. Start NodeManager : By default in Windows it runs when the OS starts (Reference about NodeManager can be found here)
2. Start Admin Server : Initiate Weblogic Server.
3. Start Managed Server : Initiate the main applications. Based on the picture above, these are highlighted in Red : BI Plugin, BI Security, BI Action Service, BI Webservices SOA. If you are planning to use BI Publisher or RTD then it must also be started.
4. Start BIEE Services : These are the main BIEE processes which are controlled by OPMN: BI Server, BI Presentation Server, BI JavaHost. If you are planning to use BI Scheduler then also start it. Or if your instance is a clustered environment then also start the BI Cluster Controller.

Posted in OBIEE 11g | Tagged , , | Leave a comment

[nQSError: 75027] Failed to open connection to SMTP Server, scheduler error

Sometime back I had configured a scheduler in OBIEE 11g and everything was perfect. I was able to catch alerts on the dashboard but I had not been able to send mails even though mail configuration was seemed to be correct.

When we run the agent we are getting an error like [nQSError: 75027] Failed to open connection to SMTP Server

At first I thought there was a problem with SMTP server name and the port. So I decided to run the Telnet session using the given SMTP server and port and it worked. Hence it confirmed that SMTP server name and the port number was all right.

After some research I found that the Antivirus ( McAfee in my case ) was blocking the SMTP port 25 and the SMTP server  did not want the username and password to get authenticated. So I did the following and I could receive the mails.

Steps to resolve this issue

Go to All programs ->McAfee->VirusScan Console and click on Access Protection and uncheck the do the following as shown in the snap below.

IMG04

Apply the changes and say OK.

Thanks,
Naveen

 

Posted in OBIEE 11g | Tagged , | Leave a comment

Nqserror: 75005 Failed to send AUTH command. 5.7.3 Authentication unsuccessful. scheduler error

when running Agent, the following error message is seen:

Failed to send AUTH command. 5.7.3 Authentication unsuccessful

The above error message is seen if the BI scheduler cannot ping the mail server specified in the scheduler configuration. In this case, customer is able to ping and telnet the mail server.

The other scenario where the error message is seen is if Username and password are specified in the scheduler configuration.

To view this setting, log in to enterprise manager > Business Intelligence > Coreapplication > Deployment > Mail and you will notice Username, password. If the values are specified for Username and password then Failed to Send Auth Command error is seen.

In this case, Username and password for the scheduler configuration have values.

Once the values are entered, these values cannot be deleted from the EM. In order to delete the values for Username and Password specified in mail configuration,

Steps to delete Username and Password fields in mail configuration.

Log in to Enterprise manager. You have to remove the mail.server key.

Follow the steps as shown below.
 IMG01
 Delete the key mail.server
 IMG02

Check your mail tab in the Deployment: Username and Password would have gone.
IMG03Restart the services.

After deleting the credential, we can able to run the agents successfully.

 

Thanks,

Naveen

Posted in OBIEE 11g | Tagged , | 5 Comments

Steps to start Weblogic node manager and OBIEE 11g manually

Steps involved to start Weblogic node manager and OBIEE11g is as follows.

In order to start all the services your Oracle database need to be up and running.

Start Weblogic Node Manager

run the below tag in command prompt.

ORACLE_BIEE_HOME/wlserver_10.3/server/bin/startNodeManager.cmd

Steps to Manually Start Oracle BIEE 11g

Run the following commands in command prompt
1. ORACLE_BIEE_HOME/user_projects/domains/bifoundation_domain/bin/startWebLogic.cmd

2. ORACLE_BIEE_HOME/user_projects/domains/bifoundation_domain/bin/startManagedWebLogic.cmd bi_server1

3. ORACLE_BIEE_HOME/instances/instance1/bin/opmnctl startall

Steps to Manually Stop Oracle BIEE 11g

Run the following commands in command prompt
1. ORACLE_BIEE_HOME/instances/instance1/bin/opmnctl shutdown

2. ORACLE_BIEE_HOME/user_projects/domains/bifoundation_domain/bin/stopManagedWebLogic.cmd bi_server1

3.ORACLE_BIEE_HOME/user_projects/domains/bifoundation_domain/bin/stopWebLogic.cmd

Thanks,
Naveen Kumar

Posted in OBIEE 11g | Leave a comment

Weblogic Server Log Locations in OBIEE11G

BI Managed Server:

OBIEE_HOME\user_projects\domains\bifoundation_domain\servers\bi_server1\logs

bi_server1.log – For any issues related to bi_server1

Admin Server:

OBIEE_HOME\user_projects\domains\bifoundation_domain\servers\AdminServer\logs

AdminServer.log – For any issues related to AdminServer

 

Thanks,
Naveen Kumar

 

 

Posted in OBIEE 11g | Leave a comment