Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

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

(0) ShareShare
ReportReport
Posted on by

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

  • 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

  • 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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,575 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans