Thursday, August 11, 2016

OBIEE 11g : Presentation Server state is NONE

Recently i had an issue starting the Presentation Services in OBIEE 11g. Where the status is NONE. I tried restart of all OPMN components as well was presentation service alone but all my efforts went  in vain. Then i started looking at the sawlog and found something very annoying.

[OBIPS] [INCIDENT_ERROR:1] [] [saw.webextensionbase.init] [ecid: ] [tid: ] Invalid item /system/mktgcache/sawguidstate.[[
File:catalogimpl.cpp


the error is now where related to what i do and moreover i haven't made any changes to the configuration or any other thing in OBIEE. Then i started looking close at the error which states that the initialization is not happening. Then i realized the last time the system has been turned off without shutting down the services which has left the saw server in non responsive state. the error says the file sawguidstate id invalid.

So lets delete this file and .atr related to this and start the presentation service.

Below is the location of files

[INSTANCE_HOME]\bifoundation/bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\SampleAppLite\root\system\mktgcache


delete both sawguidstate  and sawguidstate.atr , if you don't want to delete them take a back up under this folder.

[INSTANCE_HOME]\bifoundation/bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog\SampleAppLite\root\system\mktgcache\{hostname}


Now start the Presentation server using the below statement

opmnctl startproc ias-component=coreapplication_obips1

Hope this resolves your error anything otherwise contact me.




Have a Good Day !!!!!



Monday, August 8, 2016

OBIEE 12c: Amazon RedShift ODBC configuration on Linux

Starting from OBIEE 12c Oracle has started supporting the Amazon Cloud database Redshift as a data source. This is very good news as there are lot of clients waiting for using the cloud data sources with OBIEE. Below are the high level steps on configuring the ODBC driver on Linux to use in connection pool.

 Below are the high level steps


  • Installing Driver 
  • Configuration of ODBC parameters
  • Configure Connection Pool

Installing the Driver


Download and install Amazon Redshift ODBC driver to access Amazon Redshift data warehouse. Follow the instructions provided in Amazon Redshift documentation.

Note: By default, Amazon Redshift drivers are installed in the following directories
/opt/amazon/redshiftodbc/lib/32 (for a 32-bit driver)
/opt/amazon/redshiftodbc/lib/64 (for a 64-bit driver)


Configure connectivity to Amazon Redshift

The following files has to be edited to configure Oracle BI server connectivity to Amazon Redshift :
1. odbc.ini
2. odbcinst.ini
3. amazon.redshiftodbc.ini
4. Copy dbfeatures.ini

Note: The following edits to files assume that the Amazon Redshift drivers are installed under “/opt/amazon/redshiftodbc/lib/64”.


1. odbc.ini


Add the following to odbc.ini file

[ODBC Data Sources]
.
.
.
RedShift=installed
[RedShift]
Description=Amazon Redshift ODBC
Driver=/opt/amazon/redshiftodbc/lib/64/libamazonredshiftodbc64.so(default location, once you upgrade or reinstall the driver, file name may change)
ServerName=
Port=
Database=
locale=en-US
QueryTimeout=2000
ProxyHost=
ProxyPort=

2. odbcinst.ini

Add the following to odbcinst.ini file

[ODBC Drivers]
.
.
.
RedShift=installed
[RedShift]
Description=Amazon Redshift ODBC Driver (64-bit)
Driver=/opt/amazon/redshiftodbc/lib/64/libamazonredshiftodbc64.so

3. amazon.redshiftodbc.ini

Edit “/opt/amazon/redshiftodbc/lib/64/amazon.redshiftodbc.ini” and update the following.

[Driver]

.
.
DriverManagerEncoding=UTF-16


4. dbfeatures.ini

Copy the attached dbfeatures.ini file to BI server config directory, /config/fmwconfig/biconfig/OBIS





Setting Up Database Objects and Connection Pools


Install Amazon Redshift ODBC driver for windows. Create a system DSN.



Set the database type to “ODBC Basic” or “ODBC Advanced” in connection pool properties



Set connection pool call interface to “ODBC 3.5”