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?

      Use Checkout to search the database for errors. Since these errors may lead to inaccurate results, they should be taken care of regularly. Running Checkout will search the database for errors, which are reported on the Checkout Report. Some of these ...

    • How do I search for 1099 errors by tax year?

      You can search for errors in 1099 recipients by tax year. Limiting the date range to a specific year will take less time to process. Searching for 1099 errors by tax year 1. Open Connect Payroll > Government Reporting > Checkout 1099 Recipients. 2. ...

    • How do I search for errors? (Checkout) (2023.05)

      Use Checkout to search for errors in the database. Step 1: Run Checkout Search the database for errors. Do this... 1. Open Connect Cemetery Management > Organization > Checkout. 2. Select the options on the routine. 3. Click GO (CTRL+G). The routine ...

    • How do I search for errors on timesheet transactions? (2022.11)

      Use Checkout Timesheet Transactions to search the database for errors in timesheet transactions. Searching timesheet transactions for errors 1. Open Connect Timekeeping Organization Checkout. 2. Click to select the checkbox titled Checkout Timesheet ...