Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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,603
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.
  • Verified answer
    bankk Profile Picture
    bankk 6,603 on at
    Issue with upgrade to 10.0.37 from 10.0.33
    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. 
  • Suggested answer
    Judy Profile Picture
    Judy Microsoft Employee on at
    Issue with upgrade to 10.0.37 from 10.0.33
    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.
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,253 Super User 2024 Season 2 on at
    Issue with upgrade to 10.0.37 from 10.0.33
    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?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans