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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Issue with upgrade to ...
Finance | Project Operations, Human Resources, ...
Answered

Issue with upgrade to 10.0.37 from 10.0.33

(0) ShareShare
ReportReport
Posted on by bankk 6,609
Hello:
We've hit an issue with our upgrade to 10.0.37 which I've never encountered prior. The last bit of the log is below. Wondering if anyone has seen something similar and can offer advice. Also, could it be 10.0.36 is a major release, therefore we need to step to 10.0.36, then upgrade to 10.0.37?
We have a ticket opened with MS and our VAR. Just throwing this out there as it's somewhat urgent for us. 
Any help would be appreciated. 
 
InvalidOperationException:Cannot get a field handle by the given extended field id 65536. Table name: DimensionAttributeValueCombination; Table id: 18621; Field id: 0. Parent table name: Common; Parent table id: 65535.
  at Microsoft.Dynamics.Ax.Xpp.Metadata.CommonHandle.GetFieldHandleById(Int32 extId, Boolean includeDerivedTables, Boolean includeBaseTable) in D://dbs//sh//l23t//1003_210418//cmd//q//Source//Kernel//Data//Data.Impl//Data.Impl//Metadata//TableHandle.cs:line 295
  at Microsoft.Dynamics.Ax.Xpp.Common.GetFieldHandle(Int32 fieldId) in D://dbs//sh//l23t//1003_210418//cmd//r//Source//Kernel//xppil//XppSupport//ManagedCommon.cs:line 426
  at Dynamics.AX.Application.ManagedQueryBuildFieldListImplementation.DoAddQueryFieldToSelectQuerySelection(Common record, ManagedQueryBuildDataSourceImplementation dataSource, QueryField field, ISet`1 addedList) in D://dbs//sh//l23t//1003_210418//cmd//r//Source//Kernel//xppil//XppSupport//XppKernelClasses//Query//Managed//ManagedQueryBuildFieldListImplementation.cs:line 343
  at Dynamics.AX.Application.ManagedQueryBuildFieldListImplementation.GenerateSelection(Common record, ManagedQueryBuildDataSourceImplementation dataSource) in D://dbs//sh//l23t//1003_210418//cmd//r//Source//Kernel//xppil//XppSupport//XppKernelClasses//Query//Managed//ManagedQueryBuildFieldListImplementation.cs:line 256
  at Dynamics.AX.Application.ManagedQueryBuildDataSourceImplementation.GenerateCursorInternal() in D://dbs//sh//l23t//1003_210418//cmd//r//Source//Kernel//xppil//XppSupport//XppKernelClasses//Query//Managed//ManagedQueryBuildDataSourceImplementation.cs:line 1416
  at Dynamics.AX.Application.EmbeddedQueryBuildDataSourceImplementation.GenerateCursorInternal() in D://dbs//sh//l23t//1003_210418//cmd//r//Source//Kernel//xppil//XppSupport//XppKernelClasses//Query//Managed//ManagedQueryBuildDataSourceImplementation.cs:line 4439
  at Dynamics.AX.Application.ManagedQueryBuildDataSourceImplementation.GenerateCursor() in D://dbs//sh//l23t//1003_210418//cmd//r//Source//Kernel//xppil//XppSupport//XppKernelClasses//Query//Managed//ManagedQueryBuildDataSourceImplementation.cs:line 736
  at Dynamics.AX.Application.ManagedQueryBuildDataSourceImplementation.GenerateCursor() in D://dbs//sh//l23t//1003_210418//cmd//r//Source//Kernel//xppil//XppSupport//XppKernelClasses//Query//Managed//ManagedQueryBuildDataSourceImplementation.cs:line 737
  at Dynamics.AX.Application.RootQueryBuildDataSourceImplementation.GenerateCursor() in D://dbs//sh//l23t//1003_210418//cmd//r//Source//Kernel//xppil//XppSupport//XppKernelClasses//Query//Managed//ManagedQueryBuildDataSourceImplementation.cs:line 3778
  at Dynamics.AX.Application.ManagedQueryImplementation.generateCursors() in D://dbs//sh//l23t//1003_210418//cmd//r//Source//Kernel//xppil//XppSupport//XppKernelClasses//Query//Managed//ManagedQueryImplementation.cs:line 1655
  at Dynamics.AX.Application.ManagedQueryRunImplementation.GenerateCursors(ManagedQueryImplementation query) in D://dbs//sh//l23t//1003_210418//cmd//r//Source//Kernel//xppil//XppSupport//XppKernelClasses//Query//Managed//ManagedQueryRunImplementation.cs:line 199
  at Dynamics.AX.Application.ManagedQueryRunImplementation.InitializeForNext() in D://dbs//sh//l23t//1003_210418//cmd//r//Source//Kernel//xppil//XppSupport//XppKernelClasses//Query//Managed//ManagedQueryRunImplementation.cs:line 283
  at Dynamics.AX.Application.ManagedQueryRunImplementation.nextInternal() in D://dbs//sh//l23t//1003_210418//cmd//r//Source//Kernel//xppil//XppSupport//XppKernelClasses//Query//Managed//ManagedQueryRunImplementation.cs:line 983
  at Dynamics.AX.Application.ManagedQueryRunImplementation.next() in D://dbs//sh//l23t//1003_210418//cmd//r//Source//Kernel//xppil//XppSupport//XppKernelClasses//Query//Managed//ManagedQueryRunImplementation.cs:line 953
  at Dynamics.AX.Application.ManagedQueryRunImplementation.GenerateOnlyRunToNext(ManagedQueryImplementation query) in D://dbs//sh//l23t//1003_210418//cmd//r//Source//Kernel//xppil//XppSupport//XppKernelClasses//Query//Managed//ManagedQueryRunImplementation.cs:line 813
  at Dynamics.AX.Application.ManagedQueryRunImplementation.GetSQLSelectQuery(ManagedQueryImplementation query) in D://dbs//sh//l23t//1003_210418//cmd//r//Source//Kernel//xppil//XppSupport//XppKernelClasses//Query//Managed//ManagedQueryRunImplementation.cs:line 790
  at Microsoft.Dynamics.AX.Data.Management.ManagedSyncDDLBuilder`1.GenerateSelectQueryFromQuery(Query xppQuery)
  at Microsoft.Dynamics.AX.Data.Management.ManagedSyncViewDDLBuilder.GenerateSelectQueryFromSyncObject(AxView view)
  at Microsoft.Dynamics.AX.Data.Management.ManagedSyncDDLBuilder`1.GenerateStatement(T syncObject, Func`2 selectQueryGenerator)
  at Microsoft.Dynamics.AX.Data.Management.DataEntity.ManagedSyncDataEntityWorker.SyncAllAction[T](ViewSyncGraphNode viewToSync, Dictionary`2 oldViewDefinitions, StringCollection dataEntityViewList, StringCollection compositeEntityViewList, IProducerConsumerCollection`1 modifiedViewDependencies)
  at Microsoft.Dynamics.AX.Data.Management.DataEntity.ManagedSyncDataEntityWorker.DoSyncAll[T](IEnumerable`1 sortedViewList, Dictionary`2 oldViewDefinitions, IProducerConsumerCollection`1 modifiedViewDependencies).
  at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.<>c.<RunFullTableSync>b__22_1(Tuple`2 result)
  at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.ExecuteWithinAOS(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider, Func`1 func, Action`1 errorHandler)
  at Microsoft.Dynamics.AX.Framework.Database.Tools.LegacyCodepath.RunFullTableSync(SyncOptions syncOptions, String sqlConnectionString, IMetadataProvider metadataProvider)
  at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.FullTableViewSync()
  at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.FullSync()
  at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.RunSync()
  at Microsoft.Dynamics.AX.Framework.Database.Tools.SyncEngine.Run(String metadataDirectory, String sqlConnectionString, SyncOptions options)
10/25/2023 05:52:14: The operation failed.
I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at
    Hi KBanh,
     
    You should be able to directly update to 10.0.37. This one is cumulative. As this is a database sync issue, have you downloaded the deployment log files and checked if there is a detailed log for the DBSync steps or was this already taken from the DBSync log? Is this only an update of the standard application objects or does it include customizations?
  • Suggested answer
    Judy Profile Picture
    Judy Microsoft Employee on at
    Hi KBanh,
     
    Thank you for your sharing.
    As mentioned, May I know if the issue happened with the standard application or if there is any extension that caused such issue.
  • Verified answer
    bankk Profile Picture
    bankk 6,609 on at
    Apologies for the extremely late follow up. We eventually found the issue was a customization. We no longer need the customization, so we deleted it, and the upgrade went through without issue. 

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 660 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 549 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 307 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans