Division Order - Missing Contract_Anchor_id on Lines of Interest
🤔 Problem
Clients may encounter an issue when attempting to process a transfer that involves lines of interest. The error message states:
Line of Interest has a missing contract_anchor_id in the database. To proceed, please remove this DO from the transfer and contact Support to correct the database.
As a result, the transfer will continue to fail because the contract_anchor_id linked to the Line of Interest is no longer available in the database.
🌱 Solution
To restore the contract_anchor_id's to the Line of Interest, please follow the sequence of scripts provided below, as the order of execution is crucial.
Scripts 1 and 2 are designed to verify the existence of Lines of Interest Records that lack a Contract Anchor ID.
1. Query to find missing Contract Link Records (2).sql 2. Query to find LOIs with missing Contracts 1 (1).sql
If the scripts above yield results, please proceed to execute the subsequent scripts in the specified order.
Run Scripts 3-8
After executing all scripts, please re-run scripts 1 and 2 to verify that there are no remaining records lacking contract_anchor_ids. Additionally, always confirm that the transfer will be submitted internally before sharing the scripts with the client.