Transaction Log - AX 2012 - Cannot create a record in Audit trail (TransactionLog)

I started getting this error after loading COM data on fresh AX2012 R3 environment. I found following post that pointed to the cause of this issue.  Following query lets you analyse the problem in SQL server management studio. For me reloading the COM data fixed the problem but if nothing works maybe updating SYSTEMSEQUENCES.NEXTVAL manually could solve it too.

Declare @NEXTVAL real

select @NEXTVAL = NEXTVAL from SYSTEMSEQUENCES where id = -2

--Following query will return rows if you are getting 'already exists' error

select * from TRANSACTIONLOG where CREATEDTRANSACTIONID > @NEXTVAL order by CREATEDTRANSACTIONID asc

Go

AX2012 R3 AOS crashes

AX2012 R3 AOS crashes

Out of nowhere my AOS started crashing when i tried to run GL->Periodic->Fiscal year close-> Purchase order year-end process. 

Following two errors were logged in event log:

Error log # 1

-----------------------------------------------------------------------------------------------------

Faulting application name: Ax32Serv.exe, version: 6.3.164.0, time stamp: 0x533f696b

Faulting module name: KERNELBASE.dll, version: 6.1.7601.18409, time stamp: 0x5315a05a

Exception code: 0xe0434352

Fault offset: 0x000000000000940d

Faulting process id: 0x23dc

Faulting application start time: 0x01cf8f30cb73cc09

Faulting application path: C:\Program Files\Microsoft Dynamics AX\60\Server\R3_Mainline\Bin\Ax32Serv.exe

Faulting module path: C:\Windows\system32\KERNELBASE.dll

Report Id: 61ee3732-fb26-11e3-a2c6-0026b97fab47

Error log #2

----------------------------------------------

Fault bucket , type 0

Event Name: CLR20r3

Response: Not available

Cab Id: 0

Problem signature:

P1: ax32serv.exe

P2: 6.3.164.0

P3: 533f696b

P4: Ax32Serv

P5: 6.3.164.0

P6: 533f696b

P7: 894

P8: 16

P9: System.AccessViolationException

P10: 

Attached files:

These files may be available here:

C:\ProgramData\Microsoft\Windows\WER\ReportQueue\AppCrash_ax32serv.exe_b68682a613462e2eeddcf2e2ab1f55846ec56a8a_2c960bb4

Analysis symbol: 

Rechecking for solution: 0

Report Id: 61ee3732-fb26-11e3-a2c6-0026b97fab47

Report Status: 0

Solution

I tried re-installing the AOS but that didn't solve the problem. After some googling i found following post , one the suggestions was to do a compile and synchronize. Doing so solved my problem.

I hope it helps you out too!!!