Skip to main content
Question

Data model Error

  • April 4, 2022
  • 5 replies
  • 97 views
E
Level 6
Forum|alt.badge.img+14

I got the following message. but I do not know how should I solve the problem. Could you please explain the detail?

 

Data model load failed during load to engine: Could not load data model. Load failed. Error Message: Could not execute foreign key join: there are duplicates on both sides of the specified key relationship. Table "A": key column ("E"), key ('00058B2D25244258B806'), rows 1 and 2. Table "B": key column ("E"), key ('EEE3E74B186040F48522'), rows 29 and 35. Celonis Support ID: e9012fd3-bf7c-4e59-9d7a-6b92484458a2

andrew.yen

5 replies

Z
Level 5
  • z.b
  • Level 5
  • April 4, 2022

Hi Eri,

 

You are getting this issue because while joining the tables in the data model, it is not able to establish a 1:N relationship.

Here in your case, you have duplicates on both sides Dimension Table(1) as well as in the Fact Table (N).

Your Dimension table is Table A and Fact Table is Table B.

 

Try applying the Best practices while joining tables in a Data Model. (More can be found in the help section"Data Model Best Practices")

Screen Shot attached.

 

Hope this helps.

 

Regards,

JayB

 

 

 

 

 

1 Attachments
E
Level 6
Forum|alt.badge.img+14
  • e.n
  • Author
  • Level 6
  • April 4, 2022

@z.b  Hi, thank you for your reply and helpful information. The problem was resolved! I really appreciate your help.

T
Level 1

How did you fix this issue?

J
Level 7

I would like to know the resolution. I am having the same case and could not solve yet :(

andrew.yen
Level 1
Forum|alt.badge.img
  • andrew.yen
  • Level 1
  • November 20, 2024

Hello! I am also experiencing this issue in our environment and the link to the Best Practices has been deprecated, can someone link to the current location of it?

Community Code of ConductAccessibility statement