Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Answered

Database Synchronization error after full build

Posted on by Microsoft Employee

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()

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 288,459 Super User on at
    RE: Database Synchronization error after full build

    Hi Shahzad,

    Thanks for your feedback.

  • Verified answer
    Virtual Profile Picture
    Virtual 25 on at
    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 Profile Picture
    Vilmos Kintera 46,147 on at
    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 Profile Picture
    Vilmos Kintera 46,147 on at
    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 Calavon Profile Picture
    André Arnaud de Cal... 288,459 Super User on at
    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?

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,459 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,783 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans