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

Notifications

Announcements

Season of Giving Solutions is Here!
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,799 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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

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

#1
iampranjal Profile Picture

iampranjal 76

#2
André Arnaud de Calavon Profile Picture

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

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 40 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

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