ETL Associations Error: "There is no value for property relationship. Value can't be empty."

Summary:

While testing the ETL functionality, users may encounter the following error during the loading of Associations:

Error: There is no value for property relationship. Value can't be empty.

This issue typically arises even if all fields appear to be filled, and Clients and Related Parties load successfully.

The error is due to a mismatch between the field name used in the ETL Policy and the expected field name .

Initially, the field relationshipType may be used based on assumption, but the correct field name as per the ETL user guide is relationship.

Ensure that your ETL Policies uses the correct field names as documented. Specifically:

Field Name	Category	Target Entity	Additional Info
`relationship`	Relationship Details	Related Party	Lookup Reference: Relationships
`controlPercentage`	Relationship Details	Related Party	Data Type: Number
`ownershipPercentage`	Relationship Details	Related Party	Data Type: Number