Failed to open Order

Manager SE specific technical issues
Post Reply
User avatar
mopar-mechanic
Member
Posts: 20
Joined: Wed Mar 11, 2020 4:26 pm
Location: ALBERTA
Contact:

Failed to open Order

Post by mopar-mechanic »

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.
Garage owner/operator entrepreneur
Shopkey Pro Se with Bolt-on addition
User avatar
mopar-mechanic
Member
Posts: 20
Joined: Wed Mar 11, 2020 4:26 pm
Location: ALBERTA
Contact:

Re: Failed to open Order

Post by mopar-mechanic »

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
User avatar
ricmorin
5K Holy Smokes Contributor
5K Holy Smokes Contributor
Posts: 5967
Joined: Mon Jul 25, 2005 10:11 am
Location: New Hampshire
Contact:

Re: Failed to open Order

Post by ricmorin »

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
Post Reply

Return to “Technical Issues”