Timeclock Loading Error

Owned by Paul Hitchcock, created
Nov 24, 2020
1 min read

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.