Troubleshooting¶

Common Issues¶

Common Issue Reference¶
Symptom	Likely Cause	Action
Missing property column	Property added post initial sync	Run `spMFSynchronizeProperties`
Lookup column NULL after update	Foreign key not resolved / value list drift	Sync value lists; verify mapping
Repeated failures in batch	Mixed data types or illegal characters	Use `fnMFReplaceSpecialCharacter` on inbound
Hyperlink build errors	GUID/ObjID mismatch	Verify source table integrity

Diagnostic Queries¶

-- Orphan property columns not in MFClassProperty
SELECT c.name AS ColumnName
FROM sys.columns c
WHERE c.object_id = OBJECT_ID('dbo.MFCustomer')
  AND c.name NOT IN (SELECT Property_Column FROM dbo.MFClassProperty WHERE ClassTableName = 'MFCustomer');

ProcessBatch Review¶

Use detailed logging insertion when troubleshooting custom automation. Refer: - spMFProcessBatchDetail_Insert

Escalation Checklist¶

Reproduce with a minimal row set.
Re-run related metadata sync.
Validate lookups / value lists.
Apply sanitation functions.
Capture ProcessBatch end state.