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
Hi Akbar,
Do you have the specific error message? This will give you a clue to what's going on. You don't have to update Dynamics 365 Finance because this error is SQL related.
Hi Anton,
Thanks for the quick response.
Import started but in between i got the below error :
no more other details.
Nothing in the event viewer? Can you describe exactly how you are doing importing the .bacpac? Perhaps with the command etc.
Yes, using command prompt:
SqlPackage.exe /a:import /sf:K:\DB\uatbackup.bacpac /tdn:UATDBbackup_292023 /tsn:************ /p:CommandTimeout=3600
Event log errors:
An error occurred while writing a trace event to the file, \\?\C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Log\FlightRecorderCurrent.trc.
An error occurred while closing the trace output file, \\?\C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\Log\FlightRecorderCurrent.trc.
Just a few guesses. Are running the command as Administrator? When you downloaded the file, did you unblock it before unzipping it?
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.
When you downloaded the file, did you unblock it before unzipping it?
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.
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.
Thank you very much Anton, I am to import the .bacpac file successfully after Unblocking the downloaded file as you suggested.
Thanks again.
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.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,188
André Arnaud de Cal... 868 Super User 2025 Season 2
Sohaib Cheema 593 User Group Leader
