Skip to main content

Notifications

Microsoft Dynamics RMS forum

database error while upgrading to FP1

Posted on by 745

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: database error while upgrading to FP1

    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

  • desmon Profile Picture
    desmon 745 on at
    Re: database error while upgrading to FP1

    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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: database error while upgrading to FP1

    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!

  • desmon Profile Picture
    desmon 745 on at
    Re: database error while upgrading to FP1

    Done that already

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    Re: database error while upgrading to FP1

    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.

  • desmon Profile Picture
    desmon 745 on at
    Re: database error while upgrading to FP1

    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

  • Jeff @ Check Point Software Profile Picture
    Jeff @ Check Point ... 13,380 on at
    Re: database error while upgrading to FP1

    Dave,

    Pretty sure that that is not an RMS column.  Do you have any add-ons installed?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,818 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,147 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans