Extraction of HFM Metadata to RDBMS Fails With Error: "LiveLinkException [HR#13503]: Region extract failed"

(Doc ID 2184196.1)

Last updated on MAY 30, 2018

Applies to:

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

Symptoms

Extraction of metadata from HFM application to RDBMS is failing with Error "LiveLinkException [HR#13503]: Region extract failed"

EAL.log

LiveLinkException [HR#13503]: Region extract failed

DSS.log

ODBC: HR#13538: error in open calling SQLNumResultCols ([Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'View'. [state=37000 code=156]).

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