You’re offline. This is a read only version of the page.
500
Hello,
I previously posted a question which has not been answered, so I thought I would try another way.
One of our store databases will not upgrade to version 2.06 from 2.05 (it is on sql server 2014)
When attempting the upgrade, I get the following error
An error occurred while attempting to upgrade the database: Invalid object name 'dbo.tr_ComputeQuantity'.
This particular object (trigger) is not present in the database. A little investigation showed that the other 5 store databases do indeed have this trigger present under the InventoryTransferLog table. In fact, all of the other databases have a total of 55 different triggers present, while the offending database does not have any at all. I'm not sure how this happened, but I sure would like to know how to fix it!!
Can anyone help?
*This post is locked for comments
Hi Roger,
And thanks for the update. Good to know you have fixed the problem and even more that Microsoft guys helped You. My only worrie is if the database was in use and with missing the trigger, maybe some data was not inserted, updated or deleter... or whatever the trigger is doing...
Best regards, A.
Hi Antonijo,
I did this and it would have worked, but we ended up calling Microsoft to fix the problem and they were able to add 3 triggers to the database that were not, for some reason, created when the database was set up. This solved the problem and saved having to manually enter several days worth of data. Thank you so much for your answer!
Thank you.
Hi Roger.
It's obvious something happend with that store database, it will be dificult to recreate them all, all the triggers, maybe something else is missing, etc.,...
What I would do, if your store is syncronized with HQ (sales, inventory, etc...), I would recreate / export it from HQ again, and then update it. When exporting it should create all the needed SQL components...
Do this in testing environment first, just export this store again, restored on different PC and try to update the database...
Kind regards, A.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (