Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Unexpected failure occurred: Data plan execution failed with message One or more errors occurred

(0) ShareShare
ReportReport
Posted on by

Hi All,

Getting the below error while importing the .bacpac file into DEV (version : 10.0.30)  which is exported from UAT ( version : 10.0.33) 

"*** An unexpected failure occurred: Data plan execution failed with message One or more errors occurred.."

Do we need to apply first version update in DEV similar to UAT to resolve the error.

Please advice.

Regards,

Akbar

  • Suggested answer
    Abhilasha Singh Profile Picture
    Abhilasha Singh 2 on at
    Unexpected failure occurred: Data plan execution failed with message One or more errors occurred

     Was getting the exact same issue when trying to restore Production environment database( .bacpac) to a tier 1 dev environment.

    *** 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. (Violation of PRIMARY KEY constraint 'PK__CLASSIDT__D9C1FA0184F73476'.
    Cannot insert duplicate key in object 'dbo.CLASSIDTABLE'. The duplicate key value is (WMHEConstants). The statement has been terminated.))).
     
    What I have done to resolve it?
     
    I got it fixed and it worked.

     a. Retried the process, with downloading the .bacpac file directly from LCS and unblocked the file.
     b. Then, 
    created a new database with name different from AxDB.

         And Imported the bacpac successfully then renamed it to AxDB.

     All was fine.



     
  • G-Faulk Profile Picture
    G-Faulk 15 on at
    Unexpected failure occurred: Data plan execution failed with message One or more errors occurred
    Umapathi -- I am getting the exact same error today when restoring our pre-production database bacpac to a tier 1 dev box.
     
    *** 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. (Violation of PRIMARY KEY constraint 'I_65459CACHESCOPEIDX'. Cannot insert duplicate key in object 'dbo.SYSCACHEFLUSH'. The duplicate key value is (EntireTableCache).
    The statement has been terminated.))).
     
    Did you ever find a resolution to your issue? Nobody replied to your comment. Do we need to post this separately?
  • Unexpected failure occurred: Data plan execution failed with message One or more errors occurred
    i am facing below error UAT to dev db refresh 
     
    *** 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. (Violation of PRIMARY KEY constraint 'I_65459CACHESCOPEIDX'. Cannot insert duplicate key in object 'dbo.SYSCACHEFLUSH'. The duplicate key value is (EntireTableCache).
    The statement has been terminated.))).
     
    can you please help the issue .
     
    regards,
    Umapathi
  • Anton Venter Profile Picture
    Anton Venter 19,493 Super User 2025 Season 1 on at
    RE: Unexpected failure occurred: Data plan execution failed with message One or more errors occurred

    Hi Akbar,

    You are welcome. Glad it worked!

  • Akbarpasha Profile Picture
    Akbarpasha on at
    RE: Unexpected failure occurred: Data plan execution failed with message One or more errors occurred

    Thank you very much Anton, I am to import the .bacpac file successfully after Unblocking  the downloaded file as you suggested.

    Thanks again.

    Regards,

    Akbar

  • Verified answer
    Anton Venter Profile Picture
    Anton Venter 19,493 Super User 2025 Season 1 on at
    RE: Unexpected failure occurred: Data plan execution failed with message One or more errors occurred

    Okay, but by default all downloaded files are blocked by Windows. Did you unblock the file that you downloaded? If not, it will give an error message.

    2023_2D00_05_2D00_29-10_5F00_32_5F00_36_2D00_windows-download-unblock-file-_2D00_-Google-Search-_1420_-Mozilla-Firefox-Private-Browsing.png

  • Akbarpasha Profile Picture
    Akbarpasha on at
    RE: Unexpected failure occurred: Data plan execution failed with message One or more errors occurred

    Hi Anton,

    when i downloaded the file it is not zipped, it is UATbackup.bacpac file, i used this file and DB got created in SQL, but while processing tables it got failed.

  • Anton Venter Profile Picture
    Anton Venter 19,493 Super User 2025 Season 1 on at
    RE: Unexpected failure occurred: Data plan execution failed with message One or more errors occurred

    When you downloaded the file, did you unblock it before unzipping it?

  • Akbarpasha Profile Picture
    Akbarpasha on at
    RE: *** An unexpected failure occurred: Data plan execution failed with message One or more errors occurred.. - D365FO

    Yes Anton, ran the command prompt as Admin, and i directly downloaded the .bacpac file from LCS.

    Import started and processed for some time, but suddenly it thrown that errro.

  • Anton Venter Profile Picture
    Anton Venter 19,493 Super User 2025 Season 1 on at
    RE: *** An unexpected failure occurred: Data plan execution failed with message One or more errors occurred.. - D365FO

    Just a few guesses. Are running the command as Administrator? When you downloaded the file, did you unblock it before unzipping it?

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans