You’re offline. This is a read only version of the page.
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
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
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
issue is resolved ?
if yes kindly share the detail as we are facing same issue
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?
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.
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-)
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,219
Super User 2024 Season 2
#2
Martin Dráb
230,056
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (