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 laterInformation 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 |