Essbase Analytics Links Error "Data Synchronization Server Database Cannot Be Created"

(Doc ID 1496807.1)

Last updated on JANUARY 12, 2018

Applies to:

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


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:


[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.


[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


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