AX 2012 - Event ID 117 how do you trouble shoot this

(0) Share

Report

Posted on by rmcgregor

130

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.

*This post is locked for comments

All responses (10)

Answers (0)

Haris Hussain on at

Like (0)

Report

RE: AX 2012 - Event ID 117 how do you trouble shoot this

I am also getting this error on multiple tables when running queries are terminating with the above error communication link failure,

I have checked ax side configurations as well as also checked the network ping and installed new AOS instance on separate VM but still getting this nasty error. Also Performed DBCC check on transactional db as well as model db but that was fine also. performed system restarts etc but no luck

Please help in this regard,

Haris
Haris Hussain on at

Like (0)

Report

RE: AX 2012 - Event ID 117 how do you trouble shoot this

Please provide resolution of the issue, i am also facing the below error on multiple tables.

Object Server 01: The database reported (session 109 (kashif.k)): [Microsoft][SQL Server Native Client 11.0]Communication link failure. The SQL statement was: "SELECT T1.ORGANIZATIONTYPE,T1.OMOPERATINGUNITTYPE,T1.HCMWORKER,T1.OMOPERATINGUNITNUMBER,T1.PHONETICNAME,T1.DUNSNUMBERRECID,T1.NAME,T1.LANGUAGEID,T1.NAMEALIAS,T1.PARTYNUMBER,T1.INSTANCERELATIONTYPE,T1.KNOWNAS,T1.PRIMARYADDRESSLOCATION,T1.PRIMARYCONTACTEMAIL,T1.PRIMARYCONTACTFAX,T1.PRIMARYCONTACTPHONE...

Regards,

Haris
Bashir Ahmad 5,248 on at

Like (0)

Report

RE: AX 2012 - Event ID 117 how do you trouble shoot this

issue is resolved ?

if yes kindly share the detail as we are facing same issue
Francesco 520 on at

Like (0)

Report

RE: AX 2012 - Event ID 117 how do you trouble shoot this

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?
André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

RE: AX 2012 - Event ID 117 how do you trouble shoot this

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.
Community Member Microsoft Employee on at

Like (0)

Report

RE: AX 2012 - Event ID 117 how do you trouble shoot this

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-)
rmcgregor 130 on at

Like (0)

Report

RE: AX 2012 - Event ID 117 how do you trouble shoot this

We have 4 AOS servers running. We have some AIF services running.
Francesco 520 on at

Like (0)

Report

RE: AX 2012 - Event ID 117 how do you trouble shoot this

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

Like (0)

Report

RE: AX 2012 - Event ID 117 how do you trouble shoot this

No I have not solved this yet.
SomuAx2012 1,235 on at

Like (0)

Report

RE: AX 2012 - Event ID 117 how do you trouble shoot this

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