Skip to main content

Notifications

Microsoft Dynamics RMS forum

Problem with Store table in the store databases

Posted on by 500

Our store databases (containing the info for the 5 stores (name, address, etc), are corrupt. One of the five stores is listed in the database twice, and one is missing entirely. The information in the headquarters database is correct. Reindexing and synchronizing does not work, the information remains wrong in the store databases. Anyone know the best way to make the dbo.store tables match up properly between headquarters and store?

Thanks for any help!

*This post is locked for comments

  • Roger Oakes Profile Picture
    Roger Oakes 500 on at
    RE: Problem with Store table in the store databases

    Thank you Todd! I am going to try this today. I'll be sure to do it first in a test environment!

  • Verified answer
    ToddB Profile Picture
    ToddB on at
    RE: Problem with Store table in the store databases

    Hello Roger,

    Thank you for posting your question about missing stores.

    In my testing I made backups of my store and HQ databases.

    I then deleted all of the stores from the store table in one of my store database via SQL; and then ran the below query at HQ to reset the DBTimeStamp on the records:

    update store set name = name

    Running a 401 at the store added back the stores at the store.

    You may want to try this first in a test environment; and make backups.

    Todd

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

News and Announcements

Give Back to the Community this Month

Quick Links

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,807 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans