OBIA Essbase Configuration - Changed Existing SQL Server And Need To Configure Essbase to Communicate with the new Database (Doc ID 1995293.1)

Last updated on JUNE 12, 2015

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Symptoms

You have changed your database server to a new one and Essbase is still trying to talk to the old server name.
You have changed the location in the Weblogic Console (Services -> Data Sources) for all the data sources and also in the file located here D:\MIDDLEWARE_HOME\instances\instance1\EssbaseStudio\essbasestudio1\bin\server.properties. The log files are reporting it can not log on, but you have run Microsoft Process Monitor and it shows that Essbase is still trying to talk to the old Database server.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms