Skip to main content
Skip table of contents

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.

  1. 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.

  1. Run Scripts 3-8

    1. 3. Query to combine LOIs and Links - for blank Links 1 (1).sql

    2. 4. Update Sql - Contract Links Table - JIB Cycles 1 (1).sql

    3. 5. Update Sql - Contract Links Table - Rev Cycles Part2 1 (2).sql

    4. 6. Update Sql - Contract Links Table - Old Cycles 1 (1).sql

    5. 7. Update Sql - Contract Links Table - Rev Cycles 1 (1).sql

    6. 8. Update Sql - LOIs - Add Contract to DB (4).sql

  1. 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.

📎 Related articles

WESS-15546

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.