---
title: "Troubleshooting entry of new records"
canonical: "https://servicedesk.maxgeo.com/space/LC/1263599693/Troubleshooting%20entry%20of%20new%20records"
format: markdown
---
<u>**Objective:**</u>

To determine why a new record could not be saved.  You may find that once basic troubleshooting is complete you are redirected to more specific troubleshooting for greater support.

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

1. Confirm that "Edit Mode" is ON (refer bottom right of the LeaseControl screen).  For further information refer article "Edit Mode", or if you are unable to turn Edit Mode ON, try the article Troubleshooting Edit Mode.
2. Confirm that all compulsory fields (those highlighted yellow or (if you are editing a grid) those column headers in red text) have been completed.  For further information, refer to the article "Guided Tour" noting you will need to navigate to the sub-article relevant to your edits.
3. Confirm that valid data is in each of the fields (e.g. valid date for a date field, numerics where the field is for numeric data, etc.).  If not, refer **Cause 5**.
4. Delete data from non-compulsory fields and try saving.  If this enables saving, refer** Cause 4**.
5. If you still can't save, cancel out of the screen and try again.  If it now saves, refer **Cause 5 **or **6**.
6. Check to see if there is a Lease or Agreement that already uses the ID you are trying to enter ensuring you check archived Leases and Agreements as well.  Importantly: you have to check both Leases and Agreements regardless of which module it is being entered into.  If there is a record matching this ID, refer **Cause 7**.
7. You need to go to access the SQL Database for this next step - only experienced and qualified persons should be accessing the SQL Database, and no changes should be made.  If you don't have access to a suitably experienced and qualified person, contact [servicedesk.maxgeo.com](http://servicedesk.maxgeo.com) for assistance.
  - For a Lease or Agreement: In the database causing the issue, open up the table dbo.LMS_TENEMT_Tenement and dbo.LMS_AGRMNT_Agreement.  If you don't have this table, you're not in a LeaseControl database.
    - Filter the TENEMT_ID or AGRMNT_Number column for the exact string being used as the Lease / Agreement ID by the User (copy and paste - you need all spacing etc.)  If this ID is in use, refer **Cause 7**.
  - For a Project: In the database causing the issue, open up the table dbo.LMS_PROJCT_Project.  If you don't have this table, you're not in a LeaseControl database.
    - Filter the PROJCT_ID column for the exact string being used as the new Project name by the User (copy and paste - you need all spacing etc.).  If this ID is in use, refer **Cause 7**.
  - For an Account: In the database causing the issue, open up the table dbo.LMS_ACCONT_Account.  If you don't have this table, you're not in a LeaseControl database.
    - Filter the ACCONT_ID column for the exact string being used as the new Account ID by the User (copy and paste - you need all spacing etc.).  If this ID is in use, refer **Cause 7**.

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

1. You are using a Browser Licence, rather than an Admin Licence.  Refer **Solution 2**.
2. Your database is locked from editing due to third party data being imported into the database.  Refer **Solution 3**.
3. You have not completed the fields with valid data.  Refer **Solution 4**.
4. Sometimes if you don't tab through the fields it doesn't recognise the data selection.  It happens randomly, not consistently.  Refer **Solution 4**.
5. The ID is not unique.  Refer **Solution 5**.
  - If the User is confused, as they can't see this record in LeaseControl (ensuring they checked archived records) you may find that the record has been renamed, however the historic record remains.  If not is not acceptable to the User, refer **Solution 6**.

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

1. Turn Edit Mode ON by clicking it.  If it doesn't turn on, refer **Cause 2**.
2. Either:
  - (if your company has an admin licence) Switch to an Admin Licence.
  - (if your company does not have an admin licence, or it is not available to you) Contact [sales@maxgeo.com](mailto:sales@maxgeo.com) for additional licencing.
3. You have to choose between third party data import, and editing your database.  If you choose to edit  your database, you can create a new database and, if required, contact [sales@maxgeo.com](mailto:sales@maxgeo.com) to migrate your data.
4. Complete each field using valid characters (e.g. numeric characters only for a financial field).  For avoidance of doubt, select from a drop down menu (when there is one) and TAB between fields.
5. Use a different ID.
6. Contact [servicedesk.maxgeo.com](http://servicedesk.maxgeo.com)  to delete the original record.  You should take this option up with a great deal of caution, and backup the database prior to deletion.  This deletion cannot be undone, and we cannot advise as to the appropriateness of this solution.