Skip to main content

Notifications

Announcements

No record found.

Finance | Project Operations, Human Resources, ...
Unanswered

Retrieve classes, tables and forms code from Ax 2012 model DB

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi everyone,

We are facing a serious issue and would really appreciate any kind of help in this regard.

Couple of days ago, our Ax 2012 R3 application crashed while development on the DEV server and we did not have any back up of our latest changes. All we want is to somehow get the forms, tables and classes code from the Model DB.

Is there any way we can achieve this?

Please help us.....

Regards,

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Retrieve classes, tables and forms code from Ax 2012 model DB

    Hi Ahsan,

    When you say you want to retrieve the code from the application, what do you want to do with this code? Do you want to deploy the code to another environment for review or do you want to look at any specific code?

    As for the error, it looks like you have added the field MTQDepartmentHierarchy twice in DIRPARTYTABLE. I suspect you added it to DirPartyTable and to one of the tables extended from DirPartyTable. You could try cleaning out SQLDictionary and see if you can open the AX application and then remove these conflicting fields from the tables. Try running the following command on your  Dev environment AX database and check if that lets you start the application

    DELETE FROM dbo.SQLDICTIONARY
    WHERE TABLEID = 2303 -- DirPartTable
      AND FIELDID = 86131

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Retrieve classes, tables and forms code from Ax 2012 model DB

    Our Ax is not starting and its showing this error

    Please have a look

    unrecoverable_2D00_error.png

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Retrieve classes, tables and forms code from Ax 2012 model DB

    Thanks a lot for the help Gunjan

    Can you tell me the process of retrieving the actual code from our customizations?

    Will we do it through some cmd commands or there are some folders where the code is saved?

  • Gunjan Bhattachayya Profile Picture
    Gunjan Bhattachayya 35,421 on at
    RE: Retrieve classes, tables and forms code from Ax 2012 model DB

    Hi Ahsan,

    You can setup a new server, install AX 2012 R3 with the same CU (as the Dev server that crashed) and restore the model DB on this new server and retrieve the code changes. All the code changes are in the model DB, so recovering them shouldn't be an issue.

    But, before you go ahead and spend time setting up the new server, did you look for logs to check why the application crashed?

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans