I am currently on RMS 2.0.0.123 and installed FP1 with SP4 and all the hotfixes to 2.0.0.165. When I upgrade the database to the newer version under SO admin, I get this error: An error occurred while attempting to upgrade the database invalid object name 'dbo.tr_itemdeleted'
Does that have to do your permissions to the dbo objects and how do I fix that?
Thanks for your help
Dave
*This post is locked for comments
Dave,
Thanks for your fast answer to my prayers! I will try this fix in the morning. You are allowing me to open my store on time!
It makes sense; when I created a list of triggers, I see that dbo.tr_ItemDeleted does not exist. I wonder why this trigger is missing in my database (and missing from some other posters).
May I ask where you found this solution? I will mark your solution as the answer.
Best regards,
Steve
Just run this query and this will fix it..
CREATE TRIGGER [dbo].[tr_ItemDeleted] ON [dbo].[Item] FOR DELETE
AS
DECLARE @Rows INT
SELECT @Rows = @@ROWCOUNT
IF @Rows = 0 /* No rows deleted, exit trigger */
RETURN
INSERT INTO HQRecordDeletedLog (TableName, IDFieldName, RecordID, WhenDeleted)
SELECT 'Item', 'ID', ID, GetDate() FROM DELETED
Dave,
I am upgrading after hours (as recommended) and I am having the same issue "dbo.tr-ItemDeleted" Did you find a resolution? I am unable to upgrade my database to either 2.02 or 2.04.
THANK YOU!
Done that already
Ah, so it is, I overlooked it.
Assuming you have a backup of the database, if not make one.
Then go into SO Administrator | File | Connect | put in your password | Database | Check | Database | Re-index | exit. if all is OK , try the upgrade again.
Also make sure that you are upgrading the database on the machine it exists on, not a register or workstation.
they used to have newestech global customer edit program,but not anymore. I looked at rms sample db tables and under dbo.item table called triggers it has tr_itemdeleted, but this database I am trying to upgrade doesn't have anything under triggers. I tried copying the trigger query from the sample db and still same error under MSSQL studio express. Do you have another idea to get that trigger in there?
Thanks
Dave,
Pretty sure that that is not an RMS column. Do you have any add-ons installed?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,818 Super User 2024 Season 2
Martin Dráb 229,147 Most Valuable Professional
nmaenpaa 101,156