FDMEE Data Load Mapping fails by Error Cannot insert duplicate key row in object 'dbo.TDATAMAP' with unique index 'PK_TDATAMAP_UI'
(Doc ID 2619745.1)
Last updated on SEPTEMBER 05, 2024
Applies to:
Hyperion Financial Data Quality Management, Enterprise Edition - Version 11.1.2.3.000 and laterInformation in this document applies to any platform.
Symptoms
Customer trying to import the Data Load Mapping(Data Management -> WorkFlow->Data Load Mapping) using Excel OR try to import Data Load Mapping using LCM process get fails at Import Process.
In UI can see below error
EPMLCM-14000: Error reported from FDM Enterprise Edition.
/Application Data/Consolidation Applications/<Application Name>/Data Load Mapping:- EPMFDM-140072:Import for Data Load Mapping failed.
+++AIF_WebAPP.log having following errors+++
[2019-12-09T14:16:46.867-05:00] [ErpIntegrator0] [ERROR] [] [oracle.apps.erpi.ui] [tid: 12] [userId: <anonymous>] [ecid: 00ixy1PTRd2Fw00Fzzw0w00001Rc000NGm,0:1:1] [APP: AIF#11.1.2.0] [SRC_CLASS: sun.reflect.NativeMethodAccessorImpl] [SRC_METHOD: invoke0] EPMFDM-140098:Unexpected error occurred.[[
java.lang.RuntimeException: EPMFDM-140098:Unexpected error occurred.
Caused by: java.lang.RuntimeException: EPMFDM-140274:Message - {0}
Caused by: java.sql.SQLIntegrityConstraintViolationException: [FMWGEN][SQLServer JDBC Driver][SQLServer]Cannot insert duplicate key row in object 'dbo.TDATAMAP' with unique index 'PK_TDATAMAP_UI'.
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 |
| Cause |
| Solution |