---
title: "Troubleshooting locating a Lease or Agreement record"
canonical: "https://servicedesk.maxgeo.com/space/LC/1264091179/Troubleshooting%20locating%20a%20Lease%20or%20Agreement%20record"
format: markdown
---
<u>**Objective:**</u>

Determine if a Lease or Agreement record is (still) in LeaseControl, and if not: why not.

<u>**Troubleshooting:**</u>

The following troubleshooting is undertaken from within the LeaseControl software:

1. Close all open screens within LeaseControl (using the small 'x' in the top-righthand corner).  You should be left with a blank light grey screen.  Either use the CTRL+R function, or from the "Tools" menu select "refresh".  Now try finding the record you are after.
  - If this resolves the issue, refer **Cause 1**.
2. Try variants of the Lease/Agreement ID (including searching by Lease/Agreement Name), search under both Leases and Agreements, and search from the Lease/Agreement Browser.  **TIP:** open this by using the menus at the top to ensure you aren't looking at the Actions Browser - this is a common error).
  - If this resolves the issue, refer **Cause 2**.
3. Browse through the archived Leases and Agreements to see if you can find a variant of the ID/Name.
  - If you find the Lease/Agreement, refer **Cause 3**.

<u><span style="color: #bf2600">**Warning**</span></u><span style="color: #bf2600">: The following troubleshooting requires access to the SQL database, which should only be undertaken by appropriately experienced and trained persons.  If you do not have access to such a person, please contact servicedesk.maxgeo.com for assistance.</span>

1. Search the tables dbo.LMS_TENEMT_Tenement and dbo.LMS_AGRMNT_Agreement for the TENEMT_ID /  AGRMNT_Number and TENEMT_Name / AGRMNT_Name columns.  **Tip:** try variants and part of the ID/name provided.  You can check results with the User to see if any similar ID/Names are the one they want.
  - If it does appear in one of these, tell the User if it is a Lease or Agreement, and whether it is an ID or Name, and ask them to check again.
    - If this resolves the issue, refer **Cause 2**.
    - If the User cannot find it, check the correpsonding TENEMT_Deleted / AGRMNT_Deleted column field.
      - If this is '1', refer **Cause 3**.
2. From the dbo.LMS_DBAUDT_DatabaseAudit table search the DBAUDT_OldValue for the ID/Name provided.  **Tip:** As per 1. above, try variants of the ID/Name.
  - If it does appear in this column, look for the corresponding value in DBAUDT_NewValue and refer **Cause 4**.
3. From the dbo.LMS_DBAUDT_DatabaseAudit table search the DBAUDT_NewValue for the ID/Name provided.  **Tip:** As per 1. above, try variants of the ID/Name.
  - If it does appear in this column, refer **Cause 5**.
  - If it does not appear in this column, refer **Cause 6**.

<u>**Cause:**</u>

1. For some reason you database wasn't syncing with what other Users had entered, which had prevented the Lease/Agreement from being visible.
2. What you were searching for doesn't match how it is recorded in LeaseControl.
3. The Lease/Agreement has been archived.  Refer **Solution 1**.
4. The Lease/Agreement ID/name has been changed.  Refer **Solution 2**.
5. The Lease/Agreement has been deleted.  Refer **Solution 3**.  If you are using an old version of LeaseControl and/or are using the software on a terminal server, you may wish to also refer to related article[ Leases deleted instead of Actions](https://maxgeo.atlassian.net/wiki/spaces/LC/pages/1263403173).
6. The Lease/Agreement never existed in this database.  Refer **Solution 4**.

<u>**Solution:**</u>

1. Restore the archived Lease/Agreement, then refresh your screens.
2. Search by the new ID/name.
3. You will need to either recreate the record and/or, if you cannot satisfy yourself that the deletion was conducted validly and intentionally, place an enquiry with servicedesk.maxgeo.com to investigate how it occurred.
  - **NOTE**: You should immediately audit that no further records are missing, independently of Maxwell GeoServices, to enable cross-checking of investigation outcomes and ensure against any immediate business requirements.
4. Check other LeaseControl databases.  If you have evidence that the record once existed in this specific database, please treat this as per **Solution 3**.