You may sometimes get the following event log entries on the AOS server in pairs:
110 Object Server 01: Dialog issued for client-less session 1: Cannot edit a record
in LastValue
(SysLastValue). User ID: , AdminUserSetup.
The SQL database has issued an error.
117 Object Server 01: The database reported (session 1 (-AOS-)): [Microsoft][ODBC
SQL Server
Driver][SQL Server]Changed language setting to us_english.. The SQL statement was:
“UPDATE
SYSLASTVALUE SET VALUE=?,RECVERSION=? WHERE (((((((USERID=?) AND (RECORDTYPE=?))
AND (ELEMENTNAME=?)) AND (DESIGNNAME=?)) AND (ISKERNEL=?)) AND (COMPANY=?)) AND
(RECVERSION=?))”
These messages do not appear constantly, but actually sporadically, and always in pairs, of 110 and 117.
Every AOS server will update the SYSLASTVALUE every minute based on the registry key cachesynctime. The column it updates is the value and recversion field. In the value blob field AOS inserts information about the Entiretable cache changes that was made within the last minute, so the other AOS servers can pick up that information.
When the message event 110 & 117 arises is it because two or more AOS servers are trying to update RECVERSION with the same number. The outcome is that one of the AOS server will not be able to update, but it will likely be able to update the next minute.
The only issue that can occur is that tables that are EntireTable Cached will be out of sync for 1 additional minute.
RESOLUTION:
This issue has now been fixed in Microsoft Dynamics AX 2009 SP1 Kernel build 5.0.1500.6450 – KB2661128
The cachesynctime
Default value 60
| –author: | Kim Truelsen |
| — last editor: | Anup Shah |
| –last edited: | 28/Feb/2011 |