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

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Database Synchronizati...
Microsoft Dynamics AX (Archived)

Database Synchronization error after full build

(0) ShareShare
ReportReport
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)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 305,659 Super User 2026 Season 1 on at

    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?

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    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.

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    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

  • Verified answer
    Virtual Profile Picture
    Virtual 25 on at

    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

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 305,659 Super User 2026 Season 1 on at

    Hi Shahzad,

    Thanks for your feedback.

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

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 16

#2
Harisgillani Profile Picture

Harisgillani 4

#2
Nagendra Varma K Profile Picture

Nagendra Varma K 4

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans