Essbase Analytics Links Error "Data Synchronization Server Database Cannot Be Created" (Doc ID 1496807.1)

Last updated on AUGUST 08, 2016

Applies to:

Oracle Essbase Analytics Link for HFM - Version 11.1.2.2.000 and later
Information in this document applies to any platform.
Jan 2016

Symptoms

In Essbase Analytics Link (EAL) when trying to create analytics link data from Data Synch tab of the bridge, the process ends with an error:

Data Synchronization Server database cannot be created.

Here are examples of the errors seen in the logs:

dss.log:

[30 Sep 2012 12:26:57] [dbmgr] ERROR: last message repeated 2 more times
...
[30 Sep 2012 12:27:28] [dbmgr] WARN : HR#03826: Directory "C:\oracle\product\EssbaseAnalyticsLink/Work/XOD/backUp_3" not found. Trying to create
[30 Sep 2012 12:27:28] [dbmgr] ERROR: ODBC: HR#01465: error in open calling SQLExecute ([Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'Finance_ACCOUNT_CUSTATTR'. [state=S0002 code=208]).
[30 Sep 2012 12:27:28] [dbmgr] ERROR: HR#00364: Cannot open source reader for "ACCOUNT"
[30 Sep 2012 12:27:28] [dbmgr] ERROR: HR#00627: Cannot create dimension: "ACCOUNT".
[30 Sep 2012 12:27:28] [dbmgr] ERROR: HR#07722: Cube 'main_cube' of application 'Finance' is not registered.


eal.log

[2012-Sep-30 12:27:28] (-6981) HR#07772: cannot register HDF
[2012-Sep-30 12:27:28] com.hyperroll.jhrapi.JhrapiException: (-6981) HR#07772: cannot register HDF
...
[2012-Sep-30 12:27:28] LiveLinkException [HR#09746]: Data Synchronization Server database cannot be created

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