735
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'.
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.
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
Hi Ramit,
YEs I have removed this field from Entity and regenerated mapping again but still same error.
Hi,
Have you used "Modify target mapping - refresh the entity after removing the filed?
#1
André Arnaud de Cal...
291,684
Super User 2024 Season 2
#2
Martin Dráb
230,414
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
