How_do_I_search_for_errors_

How do I search for errors?

Searching for errors in the database helps ensure the system remains accurate, reliable, and safe to use—especially for billing and compliance.

 

What it’s for

It identifies inconsistencies, missing data, or invalid records that could affect how licenses, payments, and reports behave.

 

Why you would do it

You’d run an error search as part of routine maintenance or when something doesn’t look right:

  • Protect data integrity
    Catch issues like broken links between records, duplicate entries, or incomplete data.

  • Prevent billing problems
    Ensure charges, payments, and balances calculate correctly.

  • Support accurate reporting
    Clean data leads to reliable financial and operational reports.

  • Resolve system issues
    Troubleshoot unexpected behavior or errors users encounter.

  • Prepare for audits or updates
    Validate data before upgrades, migrations, or formal reviews.

 

In practice

Error searches are a proactive check. They help you find and fix small issues before they become larger problems—keeping the system stable and trustworthy for daily use.

 

Step 1: Running Checkout

1. Open Connect Animal License > Organization > Checkout.

2. Do you want to search for owners who do not have a license?

  • Yes, search for owners who do not have a license. Select the Check for Owners Without a License checkbox.

  • No, skip this search. Leave blank the Check for Owners Without a License checkbox.

3. Do you want to search the database for duplicate owner records?

  • Yes, search for duplicate owner records. Select the Check for Duplicate Owners checkbox. Then, determine how to filter the duplicate owner records. You can sort the duplicate owner records by the owner's name or the owner's address.

  • No, skip this search. Do not select the checkbox titled Check for Duplicate Owners.

4. Click GO (CTRL+G).

The Checkout is finished. The Checkout Report prints a list of the errors.

 

Step 2: Reviewing the Checkout Report

When the Checkout is finished running, the system will print the Checkout report. You can review the Checkout report to find out if the Animal License database is error-free, or if there are items in the database that need your attention.

 

Step 3: Running Recalculate

If the Checkout report lists an error followed by "- run Recalculate," then you need to run the Recalculate program to correct the error.


Do this...

1. Back up the Animal License database.

How do I back up a database? Open Connect System Management > System Tools > Backup Databases. Select the server, AL0 database, and destination. Then, run the program as usual.

2. Open Connect Animal License > Organization > Recalculate.

3. Click GO (CTRL+G).

4. Run Checkout again.

5. Review the Checkout report to make sure the recalculated items are fixed.  

The Recalculate routine is finished.

 

 


    • Related Articles

    • How do I search for errors? (2022.11)

      Follow the steps in this help topic to run Checkout, review the Checkout Report for errors, and run Checkout again to make sure the errors are fixed. Step 1: Run Checkout 1. Open Connect Timekeeping > Organization > Checkout. 2. Select the options on ...

    • How do I search for errors? (Checkout)

      Searching the database for errors helps identify missing, incorrect, or inconsistent information within the system. This process helps maintain accurate records and supports reliable reporting, billing, tax collection, and account management. You ...

    • How do I search for errors? (Checkout)

      Use Checkout to search for errors in the database. Watch a webinar Learn how to use Checkout to search for errors and correct them. Step 1: Run Checkout Search the database for errors. Do this... 1. Open Connect Court Management > Organization > ...

    • How do I search for errors? (Checkout)

      Search for errors in the database to identify and resolve data issues that could affect account balances, billing calculations, payment processing, reporting, or system performance. Regular error checks help maintain the accuracy and integrity of ...

    • How do I search for errors? (Checkout)

      Use Checkout to search the Backflow Management database for errors. Step 1: Run Checkout Search the database for errors. Do this... 1. Open Connect Backflow Management > Organization > Checkout. 2. Set up the Selection Criteria. 3. Set up the ...