web
You’re offline. This is a read only version of the page.
close
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 / Microsoft Dynamics AX (Archived) / Unable to restore AX 2...
Microsoft Dynamics AX (Archived)

Unable to restore AX 2012 database / restart AOS service (database log issue)

(0) ShareShare
ReportReport
Posted on by tarun godhwani 205

Hi There,

The following is resolution to an issue we stumbled upon recently. In case anyone were to come across a similar situation, the below could be useful.

Here's what one of our customers came across on AX 2012.

They took a backup of the AX database (AX version 6.0) on the production environment and wanted to restore this file onto the test environment. This should have been a straight forward task but for some strange reason, we were unable to restart the AOS service after restoring the backup.

To begin with, the event logs were not very helpful and intuitive. The only error message we received was a generic one listed below.

Faulting application name: Ax32Serv.exe, version: 6.0.947.280, time stamp: 0x4ec317b2
Faulting module name: Ax32Serv.exe, version: 6.0.947.280, time stamp: 0x4ec317b2
Exception code: 0xc0000005
Fault offset: 0x0000000000488754
Faulting process id: 0x5bc
Faulting application start time: 0x01cd5340c143b395
Faulting application path: C:\Program Files\Microsoft Dynamics AX\60\Server\MSDynamicsAXProd\Bin\Ax32Serv.exe
Faulting module path: C:\Program Files\Microsoft Dynamics AX\60\Server\MSDynamicsAXProd\Bin\Ax32Serv.exe

*This post is locked for comments

I have the same question (0)
  • Verified answer
    tarun godhwani Profile Picture
    tarun godhwani 205 on at

    After some troubleshooting, we were able to find the root cause for the above issue.

    A database log had been set up for the table 'SQL Dictionary' (Table ID 65518).

    It seems that once you set up a log on this particular table and if you stop the AOS service and try to restart it, you will be unable to do so. You need to then delete the record via SSMS in order to get the AOS to restart. Although, technically, I do not know why this happens for the table in question.

    In our case, after deleting the record in the test environment, we were able to restart the AOS service.

    Cheers...

  • ewills Profile Picture
    ewills 5,990 on at

    I am having the same problem. I looked at the SQL Dictionary but I don't see the Field ID or Table ID that matches 65518. When I select top 1000 rows (it had 1000 of rows!) which one to delete? Pls help

  • tarun godhwani Profile Picture
    tarun godhwani 205 on at

    Hi Ewills,

    When you say you are having the same problem, does it mean you are unable to restart the AOS service?

    The steps I followed were:

    Go to SQL management studio, select the record(s) for table ID 65518 in the table 'Databaselog'.

    Delete record(s).

    Restart AOS service.

    Regards

  • AttaUllah Profile Picture
    AttaUllah 38 on at

    I am facing the same issue. I followed the post of Victoria, but system is showing multiple DIC files permission errors  . then i granted the rights to user on GP 2013 folder. its working fine now.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans