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, ... / Dynamics AX 2012 R3 cu...
Finance | Project Operations, Human Resources, ...
Suggested answer

Dynamics AX 2012 R3 cu11 window opening blank after replacing database

(0) ShareShare
ReportReport
Posted on by mnaeembaigAX 80

Our transactional database was giving page fault, allocation unit and disk I/O consistency errors. We created a new database generated all its objects including tables views and sps etc through scripts then moved all the data from old database to the new one using mssql studio. Some tables were not readable including inventtrans. We used sql mdf file data recovery tool and get most of the data from these tables of i/o errors and exported it too in the new database. We then detached the old database and attached the new database with same logical and physical names. We run ax but only blank screen without any menus and modules is appearing. Please help out. Thanks.

  • Suggested answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 294,261 Super User 2025 Season 1 on at
    RE: Dynamics AX 2012 R3 cu11 window opening blank after replacing database

    Hi,

    Is this concerning a production database or a test environment? Were the page faults and disk I/O errors caused by the ramsonware or a disk failure? Like mentioned above, a new database will be an option, but you might have lost important data.

    If this is your production environment, potentially, you have to start with an opening balance and catch up with the postings for the current fiscal year.

    Please ensure you will keep your backups on a safe place. A copy on Azure Storage might be a good assurance.

  • Suggested answer
    nmaenpaa Profile Picture
    nmaenpaa 101,158 Moderator on at
    RE: Dynamics AX 2012 R3 cu11 window opening blank after replacing database

    Your situation is quite difficult. I also suggest installing a new AX database, running the initialization checklist and then migrating data manually.

    Since you are already in big trouble and don't have much to lose, you could perhaps try Test Data Transfer Tool which you can download from Lifecycle Services. It's normally used for copying prod data to test. But in your emergency situation you might use it for copying data from your broken database to a new one. No guarantees of course.

  • Leo Chen Profile Picture
    Leo Chen on at
    RE: Dynamics AX 2012 R3 cu11 window opening blank after replacing database

    Not sure how you created the new database and how you generate all its objects. You might want to create an empty AX database by running the AX 2012 installation media, then attach the new database to AX2012 and go through the checklist. Then migrate data from old database to new one.

    Last option would be to re-implement the ERP project.

  • mnaeembaigAX Profile Picture
    mnaeembaigAX 80 on at
    RE: Dynamics AX 2012 R3 cu11 window opening blank after replacing database

    We don't have any working backup as we were attacked by ransom ware and all the backups were encrypted.

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March 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... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,017 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans