Hyperion Financial Management (HFM) Error Loading from FDMEE: “[ODBC Oracle Wire Protocol driver][Oracle]ORA-00001: unique constraint violated]]” or "[ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Violation of PRIMARY KEY constraint]"
(Doc ID 2880203.1)
Last updated on JULY 06, 2022
Applies to:
Hyperion Financial Management - Version 11.1.2.4.210 and laterInformation in this document applies to any platform.
Symptoms
HFM 11.1.2.4.210 errors during FDMEE data load:
MS SQL:
[XFM] [TRACE:1] [EPMHFM-07400] [XFM] [ecid: ] [File: XfmODBC.cpp] [Line: 139] [userId: ] [Msg arguments: ] [appName: <APPNAME>] [pid: ] [tid: ] [host: <SERVERNAME>] [nwaddr:] [errorCode: 800402BD] [srcException: NotSpec] [errType: 1] [dbUpdate: 2] [11.1.2.4.210.31] An error occurred in executing the previously prepared ODBC command. [[[DataDirect][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Violation of PRIMARY KEY constraint ''. Cannot insert duplicate key in object]]
Oracle:
[XFM] [TRACE:1] [EPMHFM-07400] [XFM] [ecid: ] [File: XfmODBC.cpp] [Line: 139] [userId: ] [Msg arguments: ] [appName: <APPNAME>] [pid: ] [tid: ] [host: <SERVERNAME>] [nwaddr: ] [errorCode: 800402BD][srcException: NotSpec] [errType: 1] [dbUpdate: 2] [11.1.2.4.210.31] An error occurred in executing the previously prepared ODBC command. [[[DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00001: unique constraint violated]]
Changes
Applied 11.1.2.4.210
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 |