Solution for association error

1.1 Problem phenonmenons

After the configuration association is updated, an error is reported in the update log. An example of the error report is shown in the following figure:

• Error: Association generation error-The association generation between Package/FRDemo_Employe_copy[Address] and Package/FRDemo_Employe1[Address] failed, and the associated field [Address] data is duplicated, as shown in the following figure:

• Error: RelationPrimaryFieldNotDistinctException: Error code: 62400405Package/FRDemo_Employe_copy[Address] (and Package/FRDemo_Employe1[Address]) does not conform to the one-to-many/many-to-one/one-to-one relationship, and the relationship cannot be successfully generated: packageName:Package entryInfoName :FRDemo_Employe_copy.

• Error: The same data appears repeatedly in the left and right merge or the total number of data rows increases.

1.2 Cause analysis

Duplicate data appears, and the only field in this field is not the only one, resulting in an error.

In the example of this chapter, the relationship between the table "FRDemo_Employe_copy" and the table "FRDemo_Employe1" is shown in the following figure:

2.1 Add components

1) Make a group table with the two related tables separately, add the associated fields or the left and right merge fields to the horizontal axis, and the "Counter" to the vertical axis, as shown in the following figure:

After adding the components, as shown in the figure below:

2) Sort the records of the two components in "Descending", as shown in the figure below:

The maximum number of records after sorting is in the first row, as shown in the following figure:

2.2 Troubleshoot

Troubleshoot table problems by viewing the maximum number of records:

1) If "N:1" or "1:N" association is used, in the group table component at one end of the association table, the maximum record value is 1, otherwise an error will be reported.

2) If a "1:1" association is used, the maximum number of table records at both ends of the association relationship must be less than or equal to 1, otherwise an error will be reported.

3) If the left merge is used, the field merged in the right table is unique, and the maximum number of records is 1; when the right merge is used, the field merged in the left table is unique, and the maximum number of records is 1, otherwise an error will be reported.

In this example, "FRDemo_Employe_copy": "FRDemo_Employe1"=1:1. Therefore, when the "Address" field in the two tables is unique, that is, when the maximum value in the "Counter" field is 1, no error will be reported.