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

I have the same question (0)

All responses (5)

Answers (1)

André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Verified answer

Virtual 25 on at

Like (0)

Report

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

Was this reply helpful? Yes No
André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

Like (0)

Report

Hi Shahzad,

Thanks for your feedback.

Was this reply helpful? Yes No