Division Order - Missing Contract Anchor ID Error for Transfers
🤔 Problem
Occasionally, a client will create and submit a transfer, only to encounter an error indicating that there are missing contract anchor ids on the Lines of Interest in the database. This error will need to be fixed with a set of scripts below.
🌱 Solution
To resolve this issue we will need to run the following set of scripts to add back the Contract Anchor ID to the database.
To identify records lacking a contract anchor ID, please execute Scripts 1 and 2. These scripts are designed to locate any entries missing the contract anchor ID field. After running them, check the results to confirm whether any records are indeed missing the anchor_ids
If Scripts 1 and 2 yield results, proceed to execute the remaining scripts in the specified sequence. It is essential to run all scripts in the exact order during execution.
After executing all scripts (3-8), please re-run scripts 1 and 2 as mentioned above to ensure that no results are being returned. This will confirm that the scripts have executed successfully.
Finally, please re-submit your transfer to ensure it completes with out errors and posts successfully.