Question Status

Unanswered
rmcgregor asked a question on 5 Jun 2013 7:58 AM

Looking at the application event log on the AOS server I am see a lot of  event 117 error messages with the following text:

Object Server 01:  The database reported (session 1 (-AOS-)): [Microsoft][SQL Server Native Client 10.0][SQL Server]Warning: Null value is eliminated by an

aggregate or other SET operation.. The SQL statement was: "UPDATE SYSCACHEFLUSH SET CLEARDATA=?,RECVERSION=?,MODIFIEDDATETIME=? WHERE ((RECID=?) AND (RECVERSION=?))"

How do I troubleshoot this?  I've tried looking on the SQL server but don't see any errors.

Reply
SomuAx2012 responded on 10 Jun 2013 7:31 AM

Did  you get answer for your problem? I have the same issue. One of the AOS stopped and even after restarting it is not taking any clients.

Thanks

Reply
rmcgregor responded on 10 Jun 2013 8:33 AM

No I have not solved this yet.

Reply
Francesco responded on 4 Sep 2013 3:05 AM

Do you have any web services active, a webshop/storefront maybe? How many AOS's do you run?

Reply
rmcgregor responded on 4 Sep 2013 3:33 PM

We have 4 AOS servers running.  We have some AIF services running.

Reply
Martien Janssen responded on 5 Sep 2013 7:32 AM

We run 10 AOS instances on 10 Servers.

In the evenlog on some of the servers do we encounter the same error under EventID 117. A restart of the affected AOS seems to help for a period of time untill it appears again.

In the eventlog we do encounter another error under the same EventID 117, this is a nasty one since the application gives an error that it cannot connect tot the SQL database, this is not tackled untill so far.

Object Server 01:  

  [Microsoft][SQL Server Native Client 10.0]Communication link failure

  session 2 (-AOS-)

Reply
André Arnaud de Calavon responded on 6 Sep 2013 12:30 AM

Hi all,

Take a look at the next link: blogs.msdn.com/.../event-117-changed-language-setting-to-us-english.aspx

It gives an explanation of the cause. A solution was provided for AX2009 but I wonder if this was only focussed on the SysLastValue problems as referred in the article.

kind regards,

André Arnaud de Calavon  |  Microsoft Dynamics AX Solution architect  |  My blog  |  My company

This post is my own opinion and does not necessarily reflect the opinion or view of my company, Microsoft, both its employees, or other MVPs.

Reply
Francesco responded on 6 Sep 2013 1:13 AM

André, event 117 on its own can have any of a million reasons.

I'm investigating a similar issue here and it appears to be originating from the SysCacheFlush table. That is my main reason for leaning towards AOS synchronization issues. This would also explain why restarting the AOS solves the issue (temporarily)

The reason I asked about AIF is that in my situation the first error always seems to come from a webshop user. Can't say if this is the cause or just the first effect though.

Are we all running multiple AOS's on VM's? And if so, has anyone compared the cluster/resource pool logs of their VM server against the times that these 117 events pop up?

Reply