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

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Error on database sync...
Finance | Project Operations, Human Resources, ...
Answered

Error on database synchronization after Data upgrade of AX 2012 R3 to D365FO

(1) ShareShare
ReportReport
Posted on by Sami Ullah Khalid 11
Hi All,

I have completed the Code Upgrade and the application has complied successfully. I am working on Data Upgrade from AX 2012 R3 to D365FO.

I have completed Upgrade from AX 2012 - Data upgrade in development environments.

D365FO DEV CHE Details:
Installed product version : 10.0.35 (10.0.1627.38)
Installed platform version : Update59 (7.0.6972.45)
SQL Server Version: 15.0.4326.1

Using AX2012DataUpgrade-10.0.35 deployable package from LCS. The process was a success, although the error log had an error.
The following error was logged in the error log of the upgrade script:

Log level - Error | Infolog diagnostic message: 'Specified field IsWarehouseWHSEnabled of datasource EcoResStorageDimensionGroup does not exist in the database or the configuration key on the field or on Extended Data Type used by the field is off. The view EntAssetReleasedProductStorageDimensionDefaultsEntity can not be created in the database.' on category 'Error'.

Right now the application is up and running and the data has been migrated.

Now, on to the issue, I recently attempted Synchronize database from visual studio and it failed with the following error.

Log level - Error | Infolog diagnostic message: 'Specified field IsWarehouseWHSEnabled of datasource EcoResStorageDimensionGroup does not exist in the database or the configuration key on the field or on Extended Data Type used by the field is off. The view EntAssetReleasedProductStorageDimensionDefaultsEntity can not be created in the database.' on category 'Error'.
Log level - Warning | Unexpected error occurred while execute computed column method: productDefaultWarehouseLocation on view/ data entity EntAssetReleasedProductStorageDimensionDefaultsEntity Microsoft.Dynamics.Ax.Xpp.ErrorException: Specified field IsWarehouseWHSEnabled of datasource EcoResStorageDimensionGroup does not exist in the database or the configuration key on the field or on Extended Data Type used by the field is off. The view EntAssetReleasedProductStorageDimensionDefaultsEntity can not be created in the database.
   at Microsoft.Dynamics.Ax.MSIL.Interop.throwException(Int32 ExceptionValue, interpret* ip)
   at Microsoft.Dynamics.Ax.MSIL.cqlClassIL.Call(IntPtr c, String methodName, Object[] parameters, Type[] types, Object[] varargs, Type[] varargsTypes)
   at Microsoft.Dynamics.Ax.Xpp.XppObjectBase.Call(String methodName, Object[] parameters, Type[] types, Object[] varargs)
   at Dynamics.AX.Application.DictView.computedColumnString(String text1, String text2, FieldNameGenerationMode mode1)
   at Dynamics.AX.Application.SysComputedColumnBase.`comparisonField(String _viewName, String _dataSourceName, String _fieldName)
   at Dynamics.AX.Application.SysComputedColumnBase.comparisonField(String _viewName, String _dataSourceName, String _fieldName)
   at Dynamics.AX.Application.SysComputedColumn.`comparisonField(String _viewName, String _dataSourceName, String _fieldName)
   at Dynamics.AX.Application.SysComputedColumn.comparisonField(String _viewName, String _dataSourceName, String _fieldName)
   at Dynamics.AX.Application.EntAssetReleasedProductStorageDimensionDefaultsEntity.productDefaultWarehouseLocation()
   at EntAssetReleasedProductStorageDimensionDefaultsEntity::productDefaultWarehouseLocation(Object[] , Boolean& )
   at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)
   at Microsoft.Dynamics.AX.DataAccess.StatementGenerator.UnboundField.get_ComputedValue()
Database synchronization completed (337535 ms). Errors found.
 
Any help on how to resolve this would be appreciated.
I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 302,698 Super User 2026 Season 1 on at
    Hi Sami,
     
    The error message is stating that a field might not exist, or a configuration key is not enabled. Have you checked that already?
  • Sami Ullah Khalid Profile Picture
    Sami Ullah Khalid 11 on at
    Hi Andre,
     
    Yes, it is a standard field. IsWarehouseWHSEnabled exists on the standard table EcoResStorageDimensionGroup and the configuration key is assigned on the standard EDT WHSDimGroupUsesWHS.
    Configuration key: WHSandTMS.
     
    The license(s) associated to Warehouse Management are enabled.
     
    D365FO Navigation:
    System administration > Setup > License configuration
     
    Configuration keys:
    Warehouse management I
    Warehouse management II upgrade
  • Spencer Wallman Profile Picture
    Spencer Wallman 4 on at
    I've got the exact same error in a Dev environment after refreshing it from an AX2012->D365 data upgrade (that was done in a Sandbox tier 2 environment though).
     
    Just wondering if you've been able to find a solution?
  • Verified answer
    Sami Ullah Khalid Profile Picture
    Sami Ullah Khalid 11 on at
    Hello,
     
    This error is resolved by enabling the Warehouse and Transportation management configuration key.
    Navigation:
    System administration > Setup >  License configuration
     
    FYR
     
     
     
     
     
     
     
     
     
     
     
     
    In order to modify configuration key(s), the environment must be put into Maintenance mode.
     
    Lastly, before using the data migration toolkit for cut-over/GoLive, I advise to enable this configuration key on the AX environment.
     
    Best of luck with your upgrades!

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

Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

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

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. André Arnaud de Cal... 662 Super User 2026 Season 1

#2
Abhilash Warrier Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Abhilash Warrier 280 Super User 2026 Season 1

#3
Martin Dráb Profile Picture

Liquid error: Object of type 'Adxstudio.Xrm.Web.Mvc.Liquid.EntityReferenceDrop' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Liquid error: Object of type 'System.Boolean' cannot be converted to type 'System.String'. Martin Dráb 201 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans