Data Model load failed

Question

Hi everyone,I received the following error message during the last few data uploads:The load failed: Load failed. Error Message: Could not execute foreign key join: there are duplicates on both sides of the specified key relationship. Table "PM_AFRU": key columns ("MANDT", "AUFPL", "APLZL"), key ('100', '1016228353', '00000001'), rows 0 and 1. Table "AFVC": key columns ("MANDT", "AUFPL", "APLZL"), key ('100', '1018097598', '00000001'), rows 1603274 and 1608762.Everything was working fine about a year ago, and I have checked the table relationships—they are correct. What could be the issue?Can anyone help?THX, M

abhishek.chatu14 · Answer

There are duplicates in either PM_AFRU or AFVC.Run the following query to identify them. Removing the duplicates should help you reload the data model. The issue may be due to a structural change or unintended data duplication.Check for duplicates in PM_AFRUSELECT "MANDT", "AUFPL", "APLZL", COUNT(*) AS duplicate_count FROM PM_AFRU GROUP BY "MANDT", "AUFPL", "APLZL" HAVING COUNT(*) > 1;Check for duplicates in AFVCSELECT "MANDT", "AUFPL", "APLZL", COUNT(*) AS duplicate_count FROM AFVC GROUP BY "MANDT", "AUFPL", "APLZL" HAVING COUNT(*) > 1;

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN