Friday, September 29, 2017

Object Server 01: Fatal SQL condition during login. Error message: "The internal time zone version number stored in the database is higher than the version supported by the kernel (10/9). Use a newer Microsoft Dynamics AX kernel.

one of my AOS coudl not start i gor below error while stating and event viwer error.

AOS start error
Windows could not start the Microsoft Dynamics AX Object Server 6.3$01-MicrosoftDynamicsAX on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 100.

Event Viewer Error

Object Server 01:  Fatal SQL condition during login. Error message: "The internal time zone version number stored in the database is higher than the version supported by the kernel (10/9). Use a newer Microsoft Dynamics AX kernel.

Solution

open SSMS, and run below command in MicrosoftDynamicsAX DB

select * from SQLSystemVariables
WHERE PARM = 'SYSTIMEZONESVERSION' // here the value should be 10

UPDATE SQLSystemVariables
SET VALUE = 9
WHERE PARM = 'SYSTIMEZONESVERSION'

hope this helps. :)

Regards,
Sudhanshu

1 comment: