Search
Search Practice CS Help and Support.

Error: System.Data.ConstraintException: Failed to enable constraints

Scenario

You might get this error when you open the
Generate Recurring Bills
screen in Practice CS.
System.Data.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraint

Cause

There is a recurring bill with a staff rate description greater than 30 characters.

Solution

  1. Select
    Setup
    , then
    Staff description rates
    .
  2. If any rate descriptions are longer than 30 characters, select
    Edit
    and shorten the description.
  3. Select
    Save
    .
After you shorten the rate description, the change will automatically apply to all entries that include the description. Go back to the
Billing
screen and the
Generate Recurring Bills
tab will open.

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close