Message in event viewer on AOS server:
Object Server XX: 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 (11/10). Use a newer Microsoft Dynamics AX kernel."
Object Server XX: 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 (11/10). Use a newer Microsoft Dynamics AX kernel."
select * from SQLSystemVariables
WHERE PARM = 'SYSTIMEZONESVERSION'
Execute query above and check value in field "VALUE", it should look like image below. Please note that message in event viewer is helpful to update this value.
Event viewer message shows kernel (11/10) means current value is 11 and supported is 10, so here we need to update value to 10 using query below. - in your environment it can be 8/7 instead of 11/10 or it can be anything. I don't come across any MS documentation for the same. Please share your experience for the same error, does it works for you or have you solved by any other way.
update SQLSystemVariables set VALUE = 10
WHERE PARM = 'SYSTIMEZONESVERSION'
You need to update the AOS service to the correct kernel version by installing a cumulative update. This SQL update approach may casuse problems
ReplyDelete