.Net and AX development related blog

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

2014-06-25T12:59:00.001-07:00

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

AX2012 R3 AOS crashes

2014-06-24T16:46:00.005-07:00

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!!!

NTML authentication not supported in Andriod

2011-03-18T06:14:00.000-07:00

Recently i was leading a project where we had to develop a IPhone, Black Berry and Andriod compatible web application which could be configured to use windows authentication. The problem we ran into was that the application won't run on andriod with windows authentication, after searching for solution i found the following link which made it clear that andriod didn't support NTLM authentication at the moment and is working on its solution but there is not time line provided as to when we could expect the solution to be out in the market.

http://code.google.com/p/android/issues/detail?id=4962

Microsoft.Jet.OLEDB.4.0 not supported in 64 bit

2011-03-11T01:28:00.000-08:00

I had a run in with this problem. we were using Jet 4.0 driver to import data from excel files in our application. we decided to make our application 64 bit compatible and after converting it to 64 bit what we find is that our data import functionality stops working and what makes it really irritating is that Microsoft didn't properly communicated that it was going to stop supporting this driver on 64 bit OS.
following are the links that you might find useful:
http://social.msdn.microsoft.com/Forums/en/adodotnetdataproviders/thread/d5b29496-d6a1-4ecf-b1a4-5550d80b84b6