/
Timeclock Loading Error

Timeclock Loading Error

Problem

When the Timeclock form loads records for a user you get the following error:

Operator '/' is not defined for type 'DBNull' and type 'Integer'.

Solution

This error can be caused by timeclock records that are missing values, likely due to out of sync versions between the desktop app, the timeclock app and the API for the mobile app. First the apps must be updated to prevent future records from saving incorrectly, then existing records need to be fixed. To do this, follow the steps below.

  1. Verify that all stations running the Timeclock app have been updated to the latest version.

  2. If you have installed the web API for mobile apps to connect, update it to the latest version. Contact support for help with this.

  3. On the server, open Crows Nest DB Utility and run a DB Update to fix the existing records.

Users will be prevented from logging into Crows Nest during the update process.

Related articles

Related content

Troubleshooting articles
Troubleshooting articles
Read with this
How to use the Mobile Timeclock GPS Feature.
How to use the Mobile Timeclock GPS Feature.
More like this
Timesheets
More like this
Clock in/out - Main app
Clock in/out - Main app
More like this
Database Lagging and Timing Out
Database Lagging and Timing Out
More like this
Release: March 15, 2020
Release: March 15, 2020
More like this