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) / cannot open RMS POS, e...
Microsoft Dynamics RMS (Archived)

cannot open RMS POS, error: row cannot be located for updating

(0) ShareShare
ReportReport
Posted on by Rongrong 220

I have restored the Store backup file (.bck) with collaton SQL_Latin1_CP1_CI_AS, I can open to use RMS POS without any problems.

However, after that I have changed the Store database collation to Thai_CI_AS, by using store admin>change collation, then I cannot open RMS POS, it pops up error "Row cannot be located for updating. Some values might have been changed since last read".   But the other RMS store apps i.e. Store manager works fine. Does anyone encounter this problem before?

My RMS is Version 2 with SP2  on SQL Sever 2005 SP2 and my master and temp database is Thai_CI_AS collation.

Is there anything concern on setup security in RMS or not? Because before I setup security in RMS, then change collation to Thai_CI_AS, POS works fine.  

Thank you for any help.

 

*This post is locked for comments

I have the same question (0)
  • Mirek Wieclawski Profile Picture
    Mirek Wieclawski 65 on at

    I have exacty the same problem, I changed collation of database to match server collation, then I can't open POS(I still can use Manager). When I'm trying to open POS I can see exactly the same message "Row cannot be located for updating. Some values might have been changed since last read"

     

    Anybod knows what can be wrong?

  • Community Member Profile Picture
    Community Member on at

    Hi, did you ever find the solution to this? I have the exact same problem come up today.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Hi  Run below query and it should fix the issue. Take a backup before you execute. This happens when you changed the DB collation after running/registering RMS

    DELETE FROM DatabaseMetaData

  • Suggested answer
    Umar Khitab Profile Picture
    Umar Khitab 750 on at

    We apply the fix below what suggested. its work fine for me. But after applying the query 

    DELETE FROM DatabaseMetaData

    This will fix your problem but you need to change the cashier password after that.

    If you didnot reset the cashier password that will not work.

    Thanks

    Umar

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