If constraint violation columns appear on sync dashboard, try the following verifications and fixes. Once verified or updated, run another sync.
- Ensure you are in "Single User Mode"
- Verify that your role is a QuickBooks "Admin"
- Delete the current Sync Profile in the Bill.com Sync Dashboard
- Click New and add the company file again
- Run another sync