AX 2009 cannot work with subcription database

Finance and Operations/AX Technical Forum
1

Hi all,

I replicate my database using Snapshot Replication, after replicate i connect Dynamics with subscription database, but this error, the event view in Application show

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

So can anybody help me to fix this problem??

Thanks so much!!!

2

Hello,

Any advise for this issue, tks,

3

If it is a new database then check the user in security node, there must be some user that is missing from the list.Usually the users that syatem should add are network service & the machine-name$. If the users are not there, add these users in security node and in schema list. While adding user in the user list, In new user window → Securables page add two Stored procedures “CREATESERVERSESSIONS” & “CREATEUSERSESSIONS” that is responsible for Server session and User Session. These can be found using search option and adding the two. Also provide execute permission on them. If this step is not taken then the AOS will not start.

4

This problem may occur because of several different conditions. To determine the specific cause of the error message, we recommend that you look in the Application log to locate a more meaningful error message. To do this, follow these steps: Click Start, point to All Programs, point to Administrative Tools, and then click Event Viewer. Under Event Viewer (Local), click Application. In the right pane, scroll down the list of messages to locate an error message. Double-click the error message to determine whether the message applies to your situation. The error message that you locate may indicate that one or more of the following conditions are true: The Microsoft SQL Server service is not started. The account that is used to start the AOS does not have the correct database roles in SQL Server. The number of AOS licenses is exceeded. The SQL Server database sort order is incorrectly case-sensitive.

5

if that is not working please try this http://dotnetxperience.blogspot.in/2013/12/dynamics-ax-2012-r2-fatal-sql-condition.html

6

Hi Rohit Kumar Singh,

Thanks so much, but my system running on Dynamics AX 2009, and I also did the step in your recommend.

  1. User run service is domain user, and already set permission for two Stored procedures “CREATESERVERSESSIONS” & “CREATEUSERSESSIONS”, and also permission on database role. And, SQL services was stared!

  2. In the window event log>system has a event code 100, is it meaning logging error???

If you have any idea, help me to discuss about this issue! Thanks a lot!