web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Facing error while Imp...
Supply chain | Supply Chain Management, Commerce
Suggested answer

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

(1) ShareShare
ReportReport
Posted on by CU16041605-0 6
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
Screenshot 2025-0...
I have the same question (0)
  • Suggested answer
    Holly Huffman Profile Picture
    Holly Huffman 6,522 Super User 2025 Season 2 on at
    Facing error while Importing DB from UAT to a tier 1 Dev Virtual Machine.
    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:
     
    1. 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.
    2. Check SQLPackage Version:
      • Make sure you’re using the latest version of SqlPackage.exe. You can download it from here.
    3. 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.
    4. Review Model File (modelCopy.xml):
      • If you’re using a model file, ensure its correctly formatted and compatible with the database schema.
    5. 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.
    6. Run as Administrator:
      • Ensure you’re running the command prompt with administrative privileges.
     
    Hope this is helpful :)
  • Jonas "Jones" Melgaard Profile Picture
    Jonas "Jones" Melgaard 4,894 Super User 2025 Season 2 on at
    Facing error while Importing DB from UAT to a tier 1 Dev Virtual Machine.
     
    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

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

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 914

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 256 Super User 2025 Season 2

#3
Sagar Suman Profile Picture

Sagar Suman 182 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans