My Oracle Support Banner

ODBC Error While Extracting The Data Using AZURE DB. (Doc ID 2962026.1)

Last updated on JULY 19, 2023

Applies to:

Hyperion Financial Management - Version 11.2.12.0.000 and later
Information in this document applies to any platform.

Symptoms

While loading data into applications through DSN it is failing with below error(Azure Database).

[XFM] [ERROR:1] [EPMHFM-07392] [XFM] [ecid: ] [File: XfmODBC.cpp] [Line: 234] [userId: ] [Msg arguments: ] [appName: <APPNMAE>] [pid: 12452] [tid: 12180] [host: <NAME>] [nwaddr: [fe80::ce7b:5812:bb33:7059]:0;10.192.86.100:0;] [errorCode: 800402B5] [srcException: 0] [errType: 1] [dbUpdate: 2] [11.2.12.1.000.8] An unknown error occurred in an ODBC object. [[1 record: SQLSTATE = 42000; NATIVE ERROR = 229; MSG = [Oracle FM][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]The SELECT permission was denied on the object 'HFM_EA_EXTRACT', database '<DB NAME>', schema 'dbo'.]]
[XFM] [ERROR:1] [EPMHFM-07392] [XFM] [ecid: ] [File: XfmODBC.cpp] [Line: 234] [userId: ] [Msg arguments: ] [appName: <APPNMAE>] [pid: 12452] [tid: 12180] [host: <NAME>] [nwaddr: [fe80::ce7b:5812:bb33:7059]:0;10.192.86.100:0;] [errorCode: 800402B5] [srcException: 0] [errType: 1] [dbUpdate: 2] [11.2.12.1.000.8] An unknown error occurred in an ODBC object. [[1 record: SQLSTATE = 42000; NATIVE ERROR = 229; MSG = [Oracle FM][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]The SELECT permission was denied on the object 'HFM_EA_EXTRACT', database '<DB NAME>', schema 'dbo'.2 record: SQLSTATE = 42000; NATIVE ERROR = 229; MSG = [Oracle FM][ODBC SQL Server Wire Protocol driver]

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.