Manual relationship column not found
Published 06 March 2025
A manual relationship is defined as using a column that cannot be found.
How to fix
- Check your options file - locate the manual relationship under
manualRelationships
- Verify column names in both
sourceColumns
andtargetColumns
arrays - Check spelling and casing - column names are case-sensitive
- Confirm the columns exist in their respective tables
Common Issues
Wrong column name: "sourceColumns": ["UserId"]
when column is actually user_id
Case sensitivity: "targetColumns": ["ID"]
when column is actually Id
Typos: "sourceColumns": ["Costumer_Id"]
instead of "Customer_Id"
Wrong table reference: Column exists but in a different table than specified