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) / How to fix error 0 on ...
Microsoft Dynamics RMS (Archived)

How to fix error 0 on export store database from RMS Headquarters

(0) ShareShare
ReportReport
Posted on by Community Member

We have exported new store databases from Headquarters on many occasions and it has always worked.  This is the first time we are exporting a new store from HQ after upgrading to 2.0.0128 (SP3).  We get this error on the table DatabaseMetadata.  We have upgraded the template database to the correct database version, so the template database version and the RMS HQ database version matches. 

What do we need to do to fix this problem?  The new store opens on May 1, and we need to begin creating Purchase Orders and poll them from HQ to the new Store databse next week.

Export Database Wizard
An error was encountered while exporting data.  Your Store Operations database is not complete and may not work correctly.
[ OK ]

Exporting table DatabaseMetadata.

 

 

*This post is locked for comments

I have the same question (0)
  • Ryan Sakry Profile Picture
    Ryan Sakry 3,425 on at

    Hank,

    I believe the error for this issue is to drop the DatabaseMetadata table from the template.

    DROP TABLE DatabaseMetadata

    Make sure you do a backup first.

  • Suggested answer
    Eric Johnson Profile Picture
    Eric Johnson 35 on at

    Actually, you need to drop it from >HQ<.  I opened a case on this years ago and run into it whenever I open a new store.

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