Dynamics 365 CommunityForums Microsoft Dynamics RMS (Archived) How to fix error 0 on ...

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

(0) Share

Report

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

All responses (2)

Answers (0)

Suggested answer

Eric Johnson 35 on at

Like (0)

Report

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

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.
Ryan Sakry 3,425 on at

Like (0)

Report

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

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.