"Cannot connect to the provider because: The request timed out. Contact your administrator to increase netRetryCount and netRetryInterval

This is on version 11.1.1.3

Increased netRetryCount and netDelay in Essbase.cfg
NetDelay 2000
NetRetryCount 6000 

Increased the timeout and network settings in the \Hyperion\Products\Essbase\aps\bin\essbase.properties file:

netRetryCount=600 TO 6000
netConnectRetry=3 TO 30
netDelay=200 TO 2000
netSocketTimeOut=200 TO 20000

But still getting the error "Cannot connect to the provider because: The request timed out. Contact your administrator to increase netRetryCount and netRetryInterval 

Implemented the below steps to resolve this issue

i) Add the Provider server details under the provider servers tab and the Essbase server as a standalone server in EAS console.

ii) Implement the below in both APS and Essbase server:

1. Open the Windows Registry.

2. Navigate to HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\TCPIP\Parameters.

3. Add new
DWORD Value named "TcpTimedWaitDelay"
Select "decimal" radio button, type in 30.

The default value forTcpTimedWaitDelay is 2 minutes. This is how long it will take for a TCP/IP port that was used by the network for a connection to be released and made available again. 30 seconds is the minimum allowed by Microsoft

4. Add new
DWORD Value named MaxUserPort
Select "decimal" radio button, type in 65534.

The default value forMaxUserPort is 5000. This determines the highest port number TCP can assign when an application requests an available user port from the system.

5. Add new
DWORD Value named MaxFreeTcbs
Select decimal radio button, type in 6250.

The default value for MaxFreeTcbs is 2000. This determines the number of TCP control blocks(TCBs) the system creates to support active connections. Since each connection requires a control block, this value determines how many active connections TCP can support simultaneously. If all control blocks are used and more connection requests arrive, TCP can prematurely release connections in the TIME_WAIT state in order to free a control block for a new connection

6. Re-start the machine.

7. Re-start the Hyperion Services including the Analytic Provider Services Service.

iii) On the client machine, update/add the following registry keys:

1. Open the Registry, Start -> Run -> Regedit.

2. Locate the following section:

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings]\

3.Create the following new DWORD keys with decimal values:

ReceiveTimeout=480000

KeepAliveTimeout=180000

ServerInfoTimeout=180000

In this example, the ReceiveTimeout setting is 8 minutes. The KeepAliveTimeout and ServerInfoTimeout settings are 3 minutes. Set these to greater than the longest running request.

4. Restart the machine for the new settings to take effect. 

Now "Cannot connect to the provider" issue has been resolved.

ASO Cube Spreadsheet Extractor Error

We got this issue on ASO cube which is having huge data.

Getting the below error while trying to connect through SmartView.

"OLAP_error (1020004): An error [1130203] occurred in Spreadsheet Extractor"

Checked the Essbase Log and Application log
In Application log we found 

Info(1020089) Ignoring span Hybrid Analysis option. Spanning into Hybrid Analysis Relational Source has been disabled. See the essbase.cfg file

Info(1020055) Spreadsheet Extractor Elapsed Time : [29.734] seconds

Error(1013289) Command [SpreadsheetOperation] failed due to memory allocation failure

Increased the Java Heap size for APS as below:

1. From "Start" ->run->regedit and enter.

2. In the registry look for the HKEY_LOCAL_MACHINE->Software->Hyperion Solutions->aps->HyS9aps

3. For this node you should see several keys, several are jvmoptions.

4. Locate the Xmx and -Xms which are the maximum and minimum heap respectively.

NOTE: You can also change or add the stack size setting -Xss here as well.

5. These can be changed by right-click-> and select modify.

6.For both Xms and Xmx, modify the value as 1024m

Now the values are 
JVMOption10 REZ_SZ -Xms1024m
JVMOption11 REZ_SZ -Xmx1024m
JVMOption12 REZ_SZ -Xss256m
-Xss1024m. 

7. After changing these settings you will need to stop and start the Hyperion Analytic Provider Server windows service.

Now tried with the retrieval using Smart view, we are not getting this error.

Changing RDBMS Server for Hyperion Essbase

Take the backup of old databases and restore in new database server

Navigate to \Oracle\Middleware\user_projects\epmsystem1\bin

Run resetConfigTask.bat to release the configuration with old RDBMS server

Navigate to Oracle/Middleware/user_projects/epmsystem1/bin and run the

epmsys_registry.bat to generate report (to check the details of Hyperion Products and RDBMS information)

Run the EPMSystemConfiguration with new Database Server name.

Check reg.properties file whether this updated the RDBMS server or not.

reg.properties file will be located under \Oracle\Middleware\user_projects\epmsystem1\config\foundation\11.1.2.0

Restart the EPMSystem

To check whether Essbase is running or not run the below command through Command Prompt

\Oracle\Middleware\user_projects\epmsystem1\bin>opmnctl status

Places where changes happened

Table Name : dbo.HSS_COMPONENT 
In this table in two places updated old server name with new server name

Table Name : dbo.HSS_COMPONENT_PROPERTY_VALUES 

In this table in 3 places updated old server name with new server name

Updated reg.properties file with new RDBMS server name

Now i have changed RDBMS server successfully and everything working fine.

The expression must be of type 'string' - Alias issue in Essbase Studio

Encountered this issue while creating alias(new binding)

Reason : Due to different data type in Binding expression(expression must be of type 'String')

Converted binding expression to String using the below

'abs'(connection : \'TestingStudio'::'AgentInfo.dbo.EssbaseTestLoad'.'AgentId').toString

Now i have successfully created a new binding.

ORA-12638: credential retrieval failed

Got this error while connecting to Oracle Database

This looks like entered wrong password, but actually its not.

Problem will be the Oracle server is not configured to support Windows authentication
or The credentials used to login are not sufficient to allow to login to the server.

Workaround
Goto %Oracle Home%\NETWORK\ADMIN in my case it is 
C:\app\prathap\product\11.2.0\dbhome_1\NETWORK\ADMIN

Open sqlnet.ora file and modify 
SQLNET.AUTHENTICATION_SERVICES= (NTS) to
SQLNET.AUTHENTICATION_SERVICES= (NONE)


It worked for me.

Configuring MapViewer in OBIEE 11g

Download Navteq spatial SampleApp data from the below link

http://download.oracle.com/technology/products/bi/files/SampleApp_Navteq_dmp.zip

Login to SQL Plus and Create obiee_navteq user to create schema in Oracle Database

Grant permission to obiee_navteq user

Unzip SampleApp and Import into Oracle database(i have unzipped file to C:\)

Open command prompt and execute below command

imp obiee_navteq/obiee_navteq file=C:\obiee_navteq.dmp FULL=Y

Login to SQL Plus and Execute the following insert statements to insert data

Logon to Oracle MapViewer using http://localhost:9704/mapviewer/mvlogon.jsp

Click on “Configuration” to edit mapViewerConfig.xml file

Find “Security Configuration” section and add the below code

<disable_direct_info_request> true </disable_direct_info_request>
<disable_info_request> true </disable_info_request>
<disable_csf>true</disable_csf>
<enforce_security_role> true </enforce_security_role>

In “Security Configuration” section enter the server name

Go to the bottom of mapViewerConfig.xml file and check for “Predefined Data Sources“ section. Add the below code to this section

Keep the exclamation mark (!) before the password. It will encrypt the password next time the MapViewer instance is restarted.

<map_data_source name="obiee_navteq"

                      jdbc_host="localhost"

                      jdbc_sid="orcl"

                      jdbc_port="1521"

                      jdbc_user="obiee_navteq"

                      jdbc_password="!obiee_navteq"

                      jdbc_mode="thin"

                     number_of_mappers="3"

                     allow_jdbc_theme_based_foi="false"

                     editable="false" />

Click on “Save” button to save the changes. Do not click on “Save & Restart”

Restarting the services for these changes to take effect:

Stop Order:
a) BI Components using Oracle Enterprise Manager FMC console
b) The BI Managed Server using the WebLogic console.

Start Order:
a) The BI Managed Server using the WebLogic console.
b) BI Components using Oracle Enterprise Manager FMC console

Start & Stop BI Components Using Oracle Enterprise Manager FMC console

http://localhost:7001/em/

Start & Stop The BI Managed Server Using Oracle WebLogic Admin console

http://localhost:7001/console/

Logon to http://localhost:9704/mapviewer/mvlogon.jsp

Click on data sources, here it will show the data source name which we have created.

Login to obiee console using http://localhost:9704/analytics/

Go to Administration -> Manage Map Data

Here select the Layers and background maps

Successfully Configured MapViewer with OBIEE. Now we can use Maps in Analysis in OBIEE

Step by step Installation of OBIEE 11.1.1.7.0

Prerequisites to install OBIEE
1. Database (Oracle Database Installation)
2. Repository Creation Utility(RCU Installation)

Once we are done with prerequisites installation then start OBIEE installation.

Download all the necessary files and extract to one folder.

Right click on “setup.exe” and click on “Run as administrator” to start installation

Click on “Run” to continue

Here it will check for prerequisites… if it is passed it will go to next screen

This is the installer welcome screen. Click “Next” to continue installation

For product updates it is good to provide Oracle support user name and password if you have, Otherwise select “Skip software updates” and continue

In this screen select the type of Installation
I am going with “Enterprise Install” option

Here it will do the prerequisite checks. Once it is successful click “Next” to continue

Select “Create New BI System” option as we are creating for the first time and enter password for the “weblogic” user and clink “Next” to continue

Select “Oracle Middleware Home Location” to install OBIEE. Once it is selected remaining will be filled automatically.
We can change “Oracle Instance Name” if required.

In this screen select the Components to install. I have unchecked “Essbase Suite” option since we have separate “Essbase Environment”

If you need to install “Essbase Suite” also then check that option and continue with installation

In this screen select the Components to install. I have unchecked “Essbase Suite” option since we have separate “Essbase Environment”

If you need to install “Essbase Suite” also then check that option and continue with installation

Here we have to enter MDS Schema Username and password

Select “Auto Port Configuration” then Installer will do the port configuration automatically.

If you want to select different ports then go with option “Specify ports using Configuration file”.

I am going with Auto Port Configuration 

It is good to enter Oracle support user name and password to inform critical security issues. If you don’t want to receive any security updates leave it blank and continue

This screen shows the summary of installation that is going to happen. Save the file as a reference for installation summary and Click on “Install” to start installation of OBIEE. 

This screen will shows the Installation progress

After installing OBIEE here it will start the Configuration of each task. Once it is successful (100%) click “Next” to continue.

We have successfully installed and configured OBIEE 11.1.1.7.0 on Windows.

Click “Finish” to close the Installer screen.