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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Upgrade Hotfix Error a...
Microsoft Dynamics AX (Archived)

Upgrade Hotfix Error at compile application state

(0) ShareShare
ReportReport
Posted on by Panuwat Jungjitdamrong 30

Hi, Everyone 

I want to upgrade hotfix "KB3101902"  at my AX2012 R2 RTM instance for solve some problems

Now, Duplicate my instance in another environment and test upgrade/install hotfix, In step install hotfix it success and goto doing checklist after upgrade, but when I recompile application I found an error alert "The field DEFAULTDIMENSION appears twice in AGREEMENTHEADERHISTORY (IDs 85910 and 85951). Rename or remove one of the fields." I click OK and AX back to compile again, after compile finished, I check db I not found duplicate that field , I try re-synchronize DB, but found same error.


How I solve that problem. or I can't install KB3101902 on AX2012 R2 RTM because maybe it want to some other dependencies hotfixs.

Thanks a lot !

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    Check the table SQLDictionary.TabId for the tableid of AgreementHeaderHistory. Then compare the FieldId column against the IDs you can see in the property window of the fields that belong to your table in the AOT. If you find that they do not match, then you need to make your SQLDictionary records identical to the actual fields in the AOT (delete the ones which do not exist, edit the ones that do not match on the name/type or id).

  • Community Member Profile Picture
    Community Member on at

    Thank you Vilmos Kintera

    I was try to use your method but it did not fix  any error.

    4807.Image-1.png

    Have you have other ways to improve this problem ?

    Bast regards.

    Den Chaisan

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

    What do you see for those element IDs in your _model database?

    SELECT * FROM [dbo].[SYSMODELELEMENTDATA]
INNER JOIN [dbo].[SYSMODELELEMENT] ON SYSMODELELEMENTDATA.MODELELEMENT = SYSMODELELEMENT.RECID
WHERE MODELELEMENT = 85910 OR MODELELEMENT = 85972

    Can you also paste what do you see in SQLDictionary by filtering on TabId of your AgreementHeaderHistory's TableId ?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans