Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.
This message pops up when attempting to open a customer work order, what had happened was a workstation as well as the main frame were updating customer information at the same time. Have restarted the server but still no access. Any help would be great with this matter.
Failed to open Order
- mopar-mechanic
- Member
- Posts: 20
- Joined: Wed Mar 11, 2020 4:26 pm
- Location: ALBERTA
- Contact:
Failed to open Order
Garage owner/operator entrepreneur
Shopkey Pro Se with Bolt-on addition
Shopkey Pro Se with Bolt-on addition
- mopar-mechanic
- Member
- Posts: 20
- Joined: Wed Mar 11, 2020 4:26 pm
- Location: ALBERTA
- Contact:
Re: Failed to open Order
Update, tech support was a great help although difficult to get through to, phone lines are still glitched since the cyber attack. Shut down all the work stations, backed up the database again, rebooted and installed another soft update, still had work order lock out, then tech performed a database utility run. Which apparently corrects glitches in any of the written code, and voila, problem solved.
Garage owner/operator entrepreneur
Shopkey Pro Se with Bolt-on addition
Shopkey Pro Se with Bolt-on addition
- ricmorin
- 5K Holy Smokes Contributor
- Posts: 5970
- Joined: Mon Jul 25, 2005 10:11 am
- Location: New Hampshire
- Contact:
Re: Failed to open Order
Nice. I've had a similar issue and that final utility did the trick.
Ric Morin - Volunteer Forum Moderator, Shop Owner, ASE Master L1
Motorcar Alternatives, LLC
603-622-6434 x203
www.motorcaralternatives.com
I find my life is a lot easier when I use Special Orders
Motorcar Alternatives, LLC
603-622-6434 x203
www.motorcaralternatives.com
I find my life is a lot easier when I use Special Orders