Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX (Archived)

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

(0) ShareShare
ReportReport
Posted on by 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

  • 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

  • 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 Profile Picture
    Bashir Ahmad 5,248 on at
    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 Profile Picture
    Francesco 520 on at
    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 Calavon Profile Picture
    André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at
    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    rmcgregor 130 on at
    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 Profile Picture
    Francesco 520 on at
    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 Profile Picture
    rmcgregor 130 on at
    RE: AX 2012 - Event ID 117 how do you trouble shoot this

    No I have not solved this yet.

  • SomuAx2012 Profile Picture
    SomuAx2012 1,235 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans