AX 2012 Service stops suddenly

Finance and Operations/AX Technical Forum
1

I have an issues wtih my AOS.

It stops frequently and when i checked the Event Viewer, it says as follows:

Object Server 01: Microsoft.Dynamics.Ax.Xpp.ErrorException: Exception of type ‘Microsoft.Dynamics.Ax.Xpp.ErrorException’ was thrown.

at Microsoft.Dynamics.Ax.MSIL.Interop.throwException(Int32 ExceptionValue)

at Microsoft.Dynamics.Ax.MSIL.cqlCursorIL.UpdateAll(IntPtr table)

at Dynamics.Ax.Application.BatchRun.serverReturnTask(Int64 batchId) in BatchRun.serverReturnTask.xpp:line 7

at BatchRun::serverReturnTask(Object[] )

at Microsoft.Dynamics.Ax.Xpp.ReflectionCallHelper.MakeStaticCall(Type type, String MethodName, Object[] parameters)

at BatchIL.startTask()

Thanks and regards
Thomas Philipose

2

Hello,

This could be due to a recent change in the Application Database. Have you, by any chance changed or moved the AX application DB? may be a migration? From the error log, it seems like the AOS is mapped to a previous Batch Server Configuration. Or an old DB that doesn’t exist or have probably been moved or even renamed.

If that is the case, then try Executing these commands on the DB Level:

Select * from dbo.BATCHSERVERGROUP
–Update BATCHSERVERGROUP set SERVERID = ‘01@NewAOS’ where SERVERID =‘02@OldAOS’

Select * from BATCHSERVERCONFIG
–Update BATCHSERVERCONFIG set SERVERID = ‘01@NewAOS’ where SERVERID =‘02@OldAOS’

Select * from SYSCLUSTERCONFIG
–Update SYSSERVERCONFIG set SERVERID = ‘01@NewAOS’ where SERVERID =‘02@OldAOS’

Select * from SYSSERVERSESSIONS
–Delete dbo.SYSSERVERSESSIONS
Select * from BATCH
–Update BATCH set SERVERID = ‘01@NewAOS’ where SERVERID = ‘02@OldAOS’

Select * from SYSCLIENTSESSIONS
–delete SYSCLIENTSESSIONS

Note: Change AOS names accordingly.

Hope this helps.

Thanks

3

Thanks

4

Hi,

Can you please tell me what is reason for deleting all the records from these 2 tables?

SYSSERVERSESSIONS

SYSCLIENTSESSIONS

In my case, the SYSSERVERSESSIONS table had 2 records, i deleted the wrong one and right now i have only one record, which represents the right AOS. Should i delete it? If so, kindly tell me why?

Regards

Thomas Philipose