OBIEE 11g BI Publisher error: unauthorized Access: Either you do not have the privilege, or you have not signed in

OBIEE 11g BI Publisher error: unauthorized Access: Either you do not have the privilege, or you have not signed in:

From log file:

access denied for user  to path /users/weblogic.; nested exception is: [[

Solution:

1. Delete the corresponding user folder and .atr from catalog->root->users folder
2.  Restart opmnctl.

Best Practices Guide for Infrastructure Tuning Oracle Business Intelligence Enterprise Edition 12c

https://blogs.oracle.com/pa/entry/obiee12c_best_practices_guide_for

Weblogic Admin Server for oam_domain failed during startup due to invalid boot.properties files- Server state changed to FORCE_SHUTTING_DOWN

When I try to start BI server, found below error from weblogic server.

Weblogic Admin Server for oam_domain failed during startup due to invalid boot.properties files.

Error:

<Notice> <Security> <BEA-090082> <Security initializing using security realm myrealm.>

<Critical> <Security> <BEA-090402> <Authentication denied for weblogic: Boot identity not valid; The user name and/or password from the boot identity file (boot.properties) is not valid. The boot identity may have been changed since the boot identity file was created. Please edit and update the boot identity file with the proper values of username and password. The first time the updated boot identity file is used to start the server, these new values are encrypted.>

weblogic.security.SecurityInitializationException: Authentication denied for weblogic: Boot identity not valid; The user name and/or password from the boot identity file (boot.properties) is not valid. The boot identity may have been changed since the boot identity file was created. Please edit and update the boot identity file with the proper values of username and password. The first time the updated boot identity file is used to start the server, these new values are encrypted.

at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.doBootAuthorization(Unknown Source)

at weblogic.security.service.CommonSecurityServiceManagerDelegateImpl.initialize(Unknown Source)

at weblogic.security.service.SecurityServiceManager.initialize(Unknown Source)

at weblogic.security.SecurityService.start(SecurityService.java:141)

at weblogic.t3.srvr.SubsystemRequest.run(SubsystemRequest.java:64)

at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

>

<Notice> <WebLogicServer> <BEA-000365> <Server state changed to FAILED>

<Error> <WebLogicServer> <BEA-000383> <A critical service failed. The server will shut itself down>

<Notice> <WebLogicServer> <BEA-000365> <Server state changed to FORCE_SHUTTING_DOWN>

<Info> <WebLogicServer> <BEA-000236> <Stopping execute threads.>

Sol:

1. Delete boot.properties (location: DOMAIN_HOME/servers/AdminServer/security)
2. Delete ldap directory (location: DOMAIN_HOME/servers/AdminServer/data)
3. Restart the weblogic server

Error [Security:090302]Authentication Failed: User BISystemUser denied

While Starting the weblogic server I am getting below error:

Caused by: oracle.security.jps.internal.jaas.module.AuthenticationException: [Security:090304]Authentication Failed: User BISystemUser javax.security.auth.login.FailedLoginException: [Security:090302]Authentication Failed: User BISystemUser denied at oracle.security.jps.wls.jaas.module.authentication.WlsUserAuthenticator.authenticate(WlsUserAuthenticator.java:61) Caused by: javax.security.auth.login.FailedLoginException: [Security:090304]Authentication Failed: User BISystemUser javax.security.auth.login.FailedLoginException: [Security:090302]Authentication Failed: User BISystemUser denied

Sol:

1. Create BISystemUser in weblogic console->Security Realms->myrealm and assign Administrator and Oracle System Groups.

2. Update  the password of BISystemUser in EM Console, BIFoundationDomain, Security, Credentials

3. Restart the BI Services

OBIEE Presentation services URL is not working

when ever i try to start the BI services. I am getting the error following error:

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.

I checked every service up and running. While seeing the log file I identified the url with different ip.

Solution:  

Update the FMW_SERVICE_URL to your system ip(make it as static IP)

How to start, stop and status of obiee 12c services

Go to below path:

ORACLE_HOME\user_projects\domains\bi\bitools\bin

Start.cmd command for starting the bi Services

Stop.cmd command for stopping the bi services.

Status.cmd command for Status of the Server

obiee 12c rpd onling opening issue (nQSError: 37001, nQSError: 12001, nQSError: 12010, nQSError: 12008)

While opening the rpd online mode experienced below error(nQSError: 12001, nQSError: 12010, nQSError: 12008)

Solution: verify the odbc connection port with the bi server port in enterprise manager.(note: make sure that both odbc port and biserver port needs to be same if not change the odbc connection port)

So Change the odbc dsn port to bi server port. It will work

Oracle Database 12c Installation

1. Download and unzip the installation files from oracle e delivery

2. Execute the setup.exe file

3. Un check the My Oracle Support Option and click on Next

4. Select the Create Database and Configure option → click on Next

5. Select Server Class and Click on Next

Trouble shoot: while starting bi server- error ORA-28001:The password has expired

While starting OBIEE Server getting below error because of schema password expiry.

Trouble Shoot: check the schema status

Solution:

1. Connect as sysdba to the database.

C:\Users\Siry>sqlplus / as sysdba

2. Set the password’s life time to unlimited.

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

4. Set the password for user.

SQL> ALTER USER user_name IDENTIFIED BY password;

6. Unlock the user account.

SQL> ALTER USER user_name ACCOUNT UNLOCK;

8. Make sure your user is not locked by executing below query.

SQL> SELECT USERNAME, ACCOUNT_STATUS FROM DBA_USERS;

Using OBIEE Variables - Over view(Part 1)

Variables holds the values

Types of variables

1. Repository Variables
2. Session Variables
3. Presentation Variables
4. Request Variables

Repository Variables: A repository variable has a single value at any point in time. There are two types of repository variables.

1. Static Repository Variables: The value of a static repository variable is assigned in the Variable dialog. This value is constant and does not change until an administrator decides to change it.

Example: you want to track your business performance against target value. Then you make at least your revenue makes 95% target. This 95% is constant until the you change it

2. Dynamic Repository Variables: The Values of Dynamic Repository Variable assigned through the initialization block. Initialization block refreshes the values by executing the queries

Example: Your report always shows current year values. Then you create a Dynamic Repository variable (CurrentYear). While executing the report these initialization blocks are executed and assign the values

SYNTAX : VALUEOF(<Variable Name>)

Session Variables: Session variables are created and assigned a value when each user logs on. There are two types of session variables

1. System Session Variables: System session variables are session variables that the Oracle BI Server and Oracle BI Presentation Services use for specific purposes. System session variables have reserved names that cannot be used for other kinds of variables

Example: USER→ holds the value the user enters as his or her logon name. This variable is typically populated from the LDAP profile of the user.

2. Nonsystem Session Variables: These are user defined variables

Example:  A common use for nonsystem session variables is setting user filters. For example, you could define a nonsystem variable called SalesRegion that would be initialized to the name of the sales region of the user.

SYNTAX: VALUEOF(NQSESSION.<Variable Name>)

Presentation Variables: A presentation variable can be created as part of the process for creating a column prompt or a variable prompt. When the presentation variable is part of a column prompt, it is associated with a specific column and takes on that column's value.

SYNTAX: @{<Variable Name>}

Request Variables: Request variables are override the session variable values for the single request. It is created same as the presentation variables. While creating the variable you need to give the name as session variable name

Oracle Data Integrator Installation

ODI Installation:

1. Download ODI Software from Oracle e-delivery (https://edelivery.oracle.com)  and Unzip the file
2. Install the Java SDK 7
3. Change the directory to jdk path and enter the below command. Installation screens find  below

Oracle Data Integrator Introduction & Architecture

Introduction:

Oracle Data Integrator provides a new declarative design approach to defining data transformation and integration processes, resulting in faster and simpler development and maintenance. Based on a unique E-LT architecture (Extract - Load Transform), Oracle Data Integrator not only guarantees the highest level of performance possible for the execution of data transformation and validation processes but is also the most cost-effective solution available today.

Here are the key reasons why companies choose Oracle Data Integrator for their data integration needs:

1. Faster and simpler development and maintenance: The declarative rules driven approach to data integration greatly reduces the learning curve of the product and increases developer productivity while facilitating ongoing maintenance
2. Data quality firewall: Oracle Data Integrator ensures that faulty data is automatically detected and recycled before insertion in the target application. This is performed without the need for programming, following the data integrity rules and constraints defined both on the target application and in Oracle Data Integrator.
3. Better execution performance: traditional data integration software (ETL) is based on proprietary engines that perform data transformations row by row, thus limiting performance. By implementing an E-LT architecture, based on your existing RDBMS engines and SQL, you are capable of executing data transformations on the target server at a set-based level, giving you much higher performance
4. Simpler and more efficient architecture: the E-LT architecture removes the need for an ETL Server sitting between the sources and the target server. It utilizes the source and target servers to perform complex transformations, most of which happen in batch mode when the server is not busy processing end-user queries.
5. Platform Independence: Oracle Data Integrator supports all platforms, hardware and OSs with the same software.
6. Data Connectivity: Oracle Data Integrator supports all RDBMSs including all leading Data Warehousing platforms such as Oracle, Exadata, Teradata, IBM DB2, Netezza, Sybase IQ and numerous other technologies such as flat files, ERPs, LDAP, XML.
7. Cost-savings: the elimination of the ETL Server and ETL engine reduces both the initial hardware and software acquisition and maintenance costs. The reduced learning curve and increased developer productivity significantly reduce the overall labor costs of the project, as well as the cost of ongoing enhancements

ODI Architecture:

Time Series Functions

Time Series Function are useful to evaluate and compare the business performance against time period, analyzing the data for multiple periods.

1. Ago:  calculates the aggregated value from the current time back to a specified time period.

Ex: Month Ago Revenue, Year Ago Revenue

Syntax: AGO(expr, [time_level], offset)

Expr is an expression that references at least one measure column.

Time_level is Level in the Time Hierarchy, such as quarter, month, or year.

Offset is an integer literal that represents the time shift amount.

2. ToDate: aggregates a measure attribute from the beginning of a specified time period to the current time

Ex: Year To Date Revenue (YTD), Mont To Date Revenue ( MTD)

Syntax: TODATE(expr, time_level)

3. Periodic Rolling: This function computes the sum of a measure over the period starting offset of time and ending offset of time from the current time

Ex: 3Month Rolling Revenue

Syntax: PERIODROLLING(expr, starting period offset [,ending period offset])

Practice: (Copied from Oracle Tutorial)

Identifying a Logical Dimension as a Time Dimension

1. Return to the Administration Tool and open the BISAMPLE repository in offline mode.
2. In the BMM layer, double-click the H1 Time logical dimension to open the Logical Dimension dialog box.

3. In the Structure section, select Time.

Time series functions operate on time-oriented dimensions. To use these functions on a particular dimension, you must designate the dimension as a Time dimension.

4. Click OK to close the Logical Dimension dialog box.

 Identifying Level Keys as Chronological Keys

1. Expand the H1 Time logical dimension and double-click the Time Detail level to open the Logical Level dialog box.
2. Click the Keys tab.

3. Select the Chronological Key check box for Calendar Date.