Communication link failure

(0) Share

Report

Posted on by GuravaReddy

Hi All

Past few weeks AOS server Event log has been capturing communication link failed error message.

We have 4 AOS Boxes and these error are from AOS1, AX Client session is closed any time due the below errors. Can anyone guide me how to start analyse the below issues.

AX build number: 6.2.1000.4051

Error mgs :

Object Server 01: The database reported (session 1 (-AOS-)): [Microsoft][SQL Server Native Client 10.0]Communication link failure. The SQL statement was: "SELECT T1.SCOPE,T1.FLUSHVERSION,T1.MODIFIEDDATETIME,T1.RECVERSION,T1.RECID,T1.CLEARDATA,T1.FLUSHDATA FROM SYSCACHEFLUSH T1 WHERE (SCOPE=?)"

Object Server 01: The database reported (session 84 (firstcl)): [Microsoft][SQL Server Native Client 10.0]Communication link failure. The SQL statement was: "{ CALL [MicrosoftDynamicsAX_model].[dbo].[XU_BuildHandleOrderList](?, ?, ?, ?, ?) }"

Regards,

Reddy

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Hi Reddy,

You could have a look at the event viewer on the AOS server and also on the SQL server. Also check the internal SQL server log. It might be the case that a certain process (like backup) is requiring exclusive access or maybe there was a failover if you have high availability.

Was this reply helpful? Yes No
Suggested answer

Vilmos Kintera 46,149 on at

Like (0)

Report
I have seen communication link failures when SQL Server was not responding due to TempDB going full.

As suggested by Andre, take a look at the SQL Server log. You should monitor how the usage of TempDB changes over time, maybe you have undersized it, or some process is writing it full.

The following T-SQL statement can query TempDB file size.

use tempdb; go select name, cast((size/128.0) as int) as TotalSpaceInMB, cast((cast(fileproperty(name, 'SpaceUsed') as int)/128.0) as int) as UsedSpaceInMB, cast((size/128.0 - cast(fileproperty(name, 'SpaceUsed') AS int)/128.0) as int) as FreeSpaceInMB from sys.database_files order by name

Also check your network connectivity, and latency. The network hardware and paths should not have anything else between the AX AOS instances and SQL Server. Also if you use a SAN, SQL must be the only one using those network controllers and switch equipment as a dedicated connection.

Was this reply helpful? Yes No
Suggested answer

Denis Macchinetti 16,444 on at

Like (0)

Report

Hi Greddi

In addition, check if the Host network adapters have the last drivers installed.

In one my experience, I solved just updating the network adapters.

Finally, install also the Last AX Kernel update.

Was this reply helpful? Yes No
Mazherullah 345 on at

Like (0)

Report

Hi Greddi,

I am getting similar errors as given below.

Our environment is, our serves are in NUtanix VM.

Recently I did windows updated on both db and application servers.

Just to confirm, I made ping dbserver >> c:\testout.txt -t.

Noticed some occassions it shows Request timed out. I think this is the time that event viewer errors get generated.

Can u pls. share your view/solution.

~~~~~~~

The description for Event ID 117 from source Dynamics Server 01 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

Object Server 01:

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

SELECT T1.SCOPE,T1.FLUSHVERSION,T1.MODIFIEDDATETIME,T1.RECVERSION,T1.RECID,T1.CLEARDATA,T1.FLUSHDATA FROM SYSCACHEFLUSH T1 WHERE (SCOPE=?)

session 1 (-AOS-)

The description for Event ID 117 from source Dynamics Server 01 cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

Object Server 01:

[Microsoft][SQL Server Native Client 11.0][SQL Server]Warning: Null value is eliminated by an aggregate or other SET operation.

session 1 (-AOS-)

The description for Event ID 0 from source Management Reporter 2012 Services cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

An error occurred while connecting to the database.

Was this reply helpful? Yes No
Mazherullah 345 on at

Like (0)

Report

Hi All,

As per Mr. Denis, our Network team updated/changed the network adapter.

Since then the frequency of error in event viewer is less. But its not totally fixed.

I checked Sql Server logs in database server. No error reported there.

Is there any other place in Application/AOS server to know what causing the error.. Other than event viewer error logs.

regards

Was this reply helpful? Yes No
Mazherullah 345 on at

Like (0)

Report

Hi,

still I am getting same errors in Event Viewer of my Application/AOS server

JFI, i am using AX 2012 r3 with CU10

SQL Server 2014 Standard Edition.

As Mr. Vimos said, I check the temp db size. Below is the query result.

tempdev :

Total space in MB = 30

Used space in MB = 14

Free Space in MB = 16

templog:

Total space in MB = 42

Used space in MB = 20

Free Space in MB = 22

Note: I left ping dbserver with timestamp. I found that during the time of error comes in Event Viewer ..at same time or near that the REQUEST TIMED OUT happens to the ping command.

Not sure its because of the application or the error comes because of ping request time out.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,020 Super User 2025 Season 2 on at

Like (0)

Report

Hi Mazherullah,

When the Ping command also gives time-out errors, it could be related to the network. Please verify if somecan can investigate what is going on. E.g. are there two machines with the same (fixed) IP address?

Was this reply helpful? Yes No
Mazherullah 345 on at

Like (0)

Report

Hi Andrew,

I have already addressed the issue with network team.

Meantime I just want to make sure the problem is not from AX and Database. So, I am trying my best to figure out any possible errors from my/our application end.

Thanks.

Regards

Was this reply helpful? Yes No
Mazherullah 345 on at

Like (0)

Report

Hi Andrew,

I check the table dbo.syscacheflush in the database...It has 57 records ..

Can we delete these records and check whether still it give the error.

Also Reg. SysLastValue table, will there be any impact if we delete records from this table.

regards

Was this reply helpful? Yes No
Haris Hussain on at

Like (0)

Report

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

Was this reply helpful? Yes No