web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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 172
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

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

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

  • RMS Goddess Profile Picture
    RMS Goddess 172 on at

    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?

  • Spencer McCandless Profile Picture
    Spencer McCandless 2,087 on at

    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 172 on at

    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. 

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans