Common Error – Failed to Enable Constraints

Table of Contents

Error Message #

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

failed to enable constraints one or more rows 1

Note: This error message normally appears when syncing a new product from Sitegiant to Autocount.

Solution #

Step 1: Check the “New Item Code” assigned to the new product.

Step 2: Make sure the length of the “New Item Code” is not more than 30 characters.

Step 3: Sync the products again. If success, the products’ data in “New Item Code” and “New UOM” will be transferred to “Item Code” and “UOM” respectively.

Note: If the problem is not solved, please contact your AutoCount support team.

Credits: Webstation.my
Related Posts: How to Attach Account Book in AutoCount?

Powered by BetterDocs