emeadaxsupport: Event 117 Changed language setting to us_english

[Blog bot]

Источник: http://blogs.msdn.com/emeadaxsupport...s-english.aspx
==============

I came across another instance of a reasonably common issue today, which is that many instances of these errors appear in the event log, but apparently nothing is wrong with the system (i.e. no other symptoms/problems are apparent):



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.



I found that these messages are nothing to worry about - the detailed explanation on what is going on here is below:



An update conflict occurs when updating a table with a blob type field, like SysLastValue table. The kernel uses ODBC function SQLParamData to put data into a blob field, in case of an update conflict the code continues to try to update the blob field and SQLParamData returns SQL_NO_DATA (because the recVersion in the where predicate has changed due to the update conflict).



The AX kernel misinterprets this return value, thinking that SQL server has raised an error, and so raises the two messages in the event log - message 110 indicates the update failed, message 117 is the last message raised from SQL server, which is actually just a standard information message that is normally not shown, as there is no actually no error from SQL, it is only a difference in interpretation from the AX kernel.







Источник: http://blogs.msdn.com/emeadaxsupport...s-english.aspx