Sunday, 3 August 2014

AX2012: Error when downgrading the AX server kernel 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 (5/2). Use a newer Microsoft Dynamics AX kernel."

Description: It can happen that you need to downgrade the AOS kernel in a system. Depending on the build you are going back to, you might get an error message.
Error message:

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 (4/1). Use a newer
Microsoft Dynamics AX kernel."

Solution:

You need to change the value for the column value SYSTIMEZONESVERSION in the table SQLSystemVariables. If you look in
the event viewer you can see that it finds the value 4, but expected 1 (4/1).
So the solution is to change the value to 1.

3 comments:

  1. Thanks - very helpful. but in AX2012 - there isn't a column as SYSTIMEZONESVERSION but a row with 'parm' value SYSTIMEZONESVERSION

    ReplyDelete
  2. update SQLSystemVariables
    set VALUE=2
    where PARM='SYSTIMEZONESVERSION'

    ReplyDelete