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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics 365 | Integration, Dataverse... / DB Import Issue in the...
Microsoft Dynamics 365 | Integration, Dataverse...
Suggested Answer

DB Import Issue in the D365 development machine

(0) ShareShare
ReportReport
Posted on by B K Sharma 737

Hi experts,

we are facing issue in the live server DB bakpac file Import at our development server, its giving error of the custom entity field 'DefaultDimension_RU' and I am able to understand that this field is now obsolete and I have removed this field from this entity and staging table but still same problem, here are the error message, pls help me to resolve this issue

Error : Invalid column name 'DEFAULTDIMENSION_RU'.

pastedimage1604405155359v1.png

I have the same question (0)
  • Suggested answer
    Ramit Paul Profile Picture
    Ramit Paul 22,803 Most Valuable Professional on at

    Hi,

    Have you used "Modify target mapping - refresh the entity after removing the filed?

  • B K Sharma Profile Picture
    B K Sharma 737 on at

    Hi Ramit,

    YEs I have removed this field from Entity and regenerated mapping again but still same error.

  • Suggested answer
    Asif365 Profile Picture
    Asif365 1,431 on at

    HI Sharma,

    Have you tried with latest NET CORE version of SqlPackage.exe.? I had similar problem last week, and MS support suggested me to download latest NET CORE version of SqlPackage.exe. and after follow below steps my issue was resolved. Please try.

    If you experience error message when trying to import bacpac file into (DEV) environment then use the suggested steps to get over this error and get your database imported

    Based on this docs link https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/import-database, download the .NET CORE version of SqlPackage.exe.

    pastedimage1604480054684v1.jpeg

    This is the .zip file that can be extracted to C:\Temp\Sqlpackage-dotnetcore

    From there, instead of using the Sqlpackage.exe under C:\Program Files (x86), use the Sqlpackage.exe in C:\Temp\Sqlpackage-dotnetcore.

    Command :

    C:\Temp\Sqlpackage-dotnetcore>SqlPackage.exe /a:import /sf:G:\Bacpac\Tier2.bacpac /tsn:localhost /tdn:<target database name> /p:CommandTimeout=1200

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Pallavi Phade Profile Picture

Pallavi Phade 102 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 71

#3
Abhilash Warrier Profile Picture

Abhilash Warrier 55 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Welcome to the Microsoft Dynamics 365 forum!
Identifying an Org as CDS or Dynamics
Get batch job history log from D365 FO to Power Automate
Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans