Supply chain | Supply Chain Management, Commerce

Facing error while Importing DB from UAT to a tier 1 Dev Virtual Machine.

(1) Share

Report

Posted on by CU16041605-0

Hi Anton, Prajwal here. I am facing an error saying *** An unexpected failure occurred: Data plan execution failed with message One or more errors occurred. (One or more errors occurred. (One or more errors occurred. (Invalid value.))). While importing a UAT BACPAC. I have used the following command for the importing of DB SqlPackage.exe /a:import /sf:"C:\Users\Adminb42d35766f\Downloads\M1UATbackup.bacpac" /tsn:zwmdfodv05-1 /tdn:AXDB_NewT /p:CommandTimeout=1200 /TargetTrustServerCertificate:True /mfp:"modelCopy.xml" . It would be really helpful if you helping me in guiding to resolve this error.

Thank You!!

Categories:

Dynamics 365 Commerce

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Suggested answer

Holly Huffman 6,554 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Good morning, afternoon, or evening depending on your location!

The error you’re encountering during the database import process suggests there might be an issue with the BACPAC file or the parameters used in the command. Let’s troubleshoot this step by step:

Verify the BACPAC File:

Ensure the BACPAC file isn’t corrupted. You can try re-exporting it from the UAT environment and confirm its integrity.

Check SQLPackage Version:

Make sure you’re using the latest version of SqlPackage.exe. You can download it from here.

Validate Command Parameters:

Double-check the command syntax and ensure the target database name (/tdn) doesn’t already exist on the server. If it does, delete or rename it before retrying.

Review Model File (modelCopy.xml):

If you’re using a model file, ensure its correctly formatted and compatible with the database schema.

Increase Command Timeout:

If the database is large, the default timeout might not be sufficient. You can increase the timeout value further, e.g., /p:CommandTimeout=3600.

Run as Administrator:

Ensure you’re running the command prompt with administrative privileges.

Hope this is helpful :)

Was this reply helpful? Yes No
Jonas "Jones&q... 5,016 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @CU16041605-0,

I have removed your email address for your own privacy sake, as bots crawl the forum and will send spam messages. I hope you don't mind.

It's a fairly non-descriptive error message, so I'd start by raising the verbosity level of the import. You can read more about the different arguments here. https://learn.microsoft.com/en-us/sql/tools/sqlpackage/sqlpackage-import

Was this reply helpful? Yes No

Join the conversation

Community site session details

Facing error while Importing DB from UAT to a tier 1 Dev Virtual Machine.

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the April Top 10 Community Leaders

Leaderboard > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates

Community site session details

Facing error while Importing DB from UAT to a tier 1 Dev Virtual Machine.

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Launch!

Women in Power Builds Momentum

Congratulations to the April Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Supply chain | Supply Chain Management, Commerce

Featured topics

Product updates