Database Synchronization error after full build

(0) Share

Report

Posted on by Community Member

View/Data Entity View sort completed. Time elapsed: 00:02:260.
Infolog diagnostic message: 'Specified datasource LeanProductionFlowCosting3_BalanceDetail of View LeanProductionFlowCosting4_Balance is a temp table.' on category 'Error'.
Unexpected error occurred while execute computed column method: PostingType on view/ data entity LeanProductionFlowCosting4_Balance Microsoft.Dynamics.Ax.Xpp.ErrorException: Specified datasource LeanProductionFlowCosting3_BalanceDetail of View LeanProductionFlowCosting4_Balance is a temp table.
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.SysComputedColumn.comparisonField(String _viewName, String _dataSourceName, String _fieldName) in xppSource://Source/ApplicationFoundation\AxClass_SysComputedColumn.xpp:line 238
at Dynamics.AX.Application.LeanProductionFlowCosting4_Balance.addToComparisonMap(Map _comparisonExpressionMap, CostClassification _costClassification, LedgerPostingType _postingType) in xppSource://Source/Foundation\AxView_LeanProductionFlowCosting4_Balance.xpp:line 30
at Dynamics.AX.Application.LeanProductionFlowCosting4_Balance.postingType() in xppSource://Source/Foundation\AxView_LeanProductionFlowCosting4_Balance.xpp:line 47
at LeanProductionFlowCosting4_Balance::PostingType(Object[] , Boolean& )
at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)
at Microsoft.Dynamics.AX.DataAccess.StatementGenerator.UnboundField.get_ComputedValue()

Infolog diagnostic message: 'Specified datasource RetailTransactionsView of View RetailTransPriceOverridesView is a temp table.' on category 'Error'.
Unexpected error occurred while execute computed column method: OverridesAmount on view/ data entity RetailTransPriceOverridesView Microsoft.Dynamics.Ax.Xpp.ErrorException: Specified datasource RetailTransactionsView of View RetailTransPriceOverridesView is a temp table.
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.SysComputedColumn.returnField(String _viewName, String _dataSourceName, String _fieldName) in xppSource://Source/ApplicationFoundation\AxClass_SysComputedColumn.xpp:line 834
at Dynamics.AX.Application.RetailTransPriceOverridesView.OverridesAmount() in xppSource://Source/Foundation\AxView_RetailTransPriceOverridesView.xpp:line 11
at RetailTransPriceOverridesView::OverridesAmount(Object[] , Boolean& )
at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)
at Microsoft.Dynamics.AX.DataAccess.StatementGenerator.UnboundField.get_ComputedValue()

*This post is locked for comments

All responses (5)

Answers (1)

André Arnaud de Cal... 295,974 Super User 2025 Season 1 on at

Like (0)

Report

RE: Database Synchronization error after full build

Hi Shahzad,

Thanks for your feedback.
Verified answer

Virtual 25 on at

Like (0)

Report

RE: Database Synchronization error after full build

Hi Andre & Vilmos

Thanks for your feedback. I managed to resolve this issue. It is standard Microsoft issue within Update 5 & Update 6 where Retail license key need to be enabled to get rid of those views error.

Kind regards,

Shahzad
Suggested answer

Vilmos Kintera 46,149 on at

Like (1)

Report

RE: Database Synchronization error after full build

Additionally you might also have ID conflicts in your database, I just published an article for resolving such problems, have a look at it here:

www.daxrunbase.com/.../fix-table-and-field-id-synchronization-conflicts-in-ax
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

RE: Database Synchronization error after full build

You have tried to use temporary tables in a View, which is forbidden.

Have a look at the documentation:

[View:https://msdn.microsoft.com/en-us/library/gg845661.aspx:750:50]

No view support.

No view in the AOT can reference a TempDB table. When a view is created under AOT > Data Dictionary > Views and is saved, the view is synchronized to the underlying database system. At that moment the view must be created by the database system. But each TempDB table is rarely present in the database, because the TempDB table exists only during the scope of the method that instantiates the table. Therefore, the TempDB table is usually not available in the database for any database view to reference the TempDB table.

You should fix your views/queries/datasources, re-release the code to your environment after the changes are checked in, and synchronize dictionary again.
André Arnaud de Cal... 295,974 Super User 2025 Season 1 on at

Like (0)

Report

RE: D365O - Database Synchronization error after full build

Hi Smaqsood,

I assume you want to have some answers how to solve this. To be able to tell something meaningful, I would like to ask you, to provide some details. Just copying an error message without providing what you did is not descriptive.

What exact type of deployment is this? What steps did you do? Is it a vanilla environment or is there any ISV/partner solution or customizations involved?