Dynamics Community Forum Thread Details

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

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.

Quick Links

Leaderboard