Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Updated RMS to 2.0.100...
Microsoft Dynamics RMS (Archived)

Updated RMS to 2.0.1006 and then upgrading database from 2.00 to 2.05 - stuck on 2.02

(0) ShareShare
ReportReport
Posted on by RMS Goddess 170
Having an issue where we have updated RMS Store Operations to 2.0.1006 - took a backup of the database to test (prior to do doing this live). Tried to update from 2.00 to 2.05 and got the following error - "An error occurred while attempting to update the database. Subquery returned more than 1 value. This is not permitted when the subquery follows =,|=,,>= or when the subquery is used as an expression. " I decided to use a stepped approach to updating the database to determine where the problem was. Updated fine from 2.00 to 2.01 but is now stuck on 2.02. Anyone have any experience with this issue and how to get past it? As an aside, the database was previously on SQL 2005 and was just updated to SQL 2008R2.

*This post is locked for comments

  • RMS Goddess Profile Picture
    RMS Goddess 170 on at
    RE: Updated RMS to 2.0.1006 and then upgrading database from 2.00 to 2.05 - stuck on 2.02

    Thought I would update this.  There was a trigger from one of the add-ons which was causing the failure.  Disabled the trigger and then it upgraded fine. 

  • Spencer McCandless Profile Picture
    Spencer McCandless 2,085 on at
    RE: Updated RMS to 2.0.1006 and then upgrading database from 2.00 to 2.05 - stuck on 2.02

    Maybe use a profiler to run a trace and see what command it's failing on? Anjlab used to offer a free one for express 2008, but it looks like it's been wrapped up in some pay software made by datawizard ( www.datawizard.com ) now.

  • RMS Goddess Profile Picture
    RMS Goddess 170 on at
    RE: Updated RMS to 2.0.1006 and then upgrading database from 2.00 to 2.05 - stuck on 2.02

    It is on a 2003 server.  However, I don't believe the OS is the issue.  I did successful upgrades on 3 out of 4 databases.  Only one failed, so it must be DB specific.  Problem is that I don't know what I am looking for that would cause the update to fail.  Any ideas?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Updated RMS to 2.0.1006 and then upgrading database from 2.00 to 2.05 - stuck on 2.02

    If you could tell us what OS you are using to upgrade the RMS, would help.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,711 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans