Error encountered in webreport logs

Usage and Config Platform
1

HI All, From past few days I am encountering the below mentioned error in webreport logs :-1:

Wed, 25 Mar 2020 02:21:28 -0500 – 8884 – Connection error while updating AGGREGATEDBY: Database Error: [Microsoft][SQL Server Native Client 11.0]Communication link failure (08S01: 0)
Wed, 25 Mar 2020 02:21:29 -0500 – 8884 – Background thread threw exception: Database Error: [Microsoft][SQL Server Native Client 11.0]Communication link failure (08S01: 0)
Wed, 25 Mar 2020 02:21:29 -0500 – 8884 – Background thread threw exception: Database Error: [Microsoft][SQL Server Native Client 11.0]Communication link failure (08S01: 0)

We recently installed the webreport component on the remote servers and the database is at root server. Could you please suggest what can be the issue. We did try to enable the logging to ‘all’ for web report in registry but did not find anything eye catching to remediate. We restart webreport service to make it work but I need to understand what connection is attempting to make and landing up at communication link failure so that we can troubleshoot on it. Please suggest.

2

The error is because a temporary communication issue with the database, Web Reports or server side …

If the database have been not manually restarted, it could be because problems over the network and/or with the database configuration itself ( no enough resources, other, … ) … in all these cases the connections to the database are lost and Web Reports is not able to recover.

Unfortunately at now the only way to address the behavior is restart the Web Reports service … to automatize could be supposed to enable the tracing for Web Reports ( to minimize the output, because it is enough check for the activity on the database, could be set “EnabledLogs”=“database” ) and monitor the Web Reports log for the error ‘Communication link failure’.

For this behavior it is in plan a mitigation tracked with DA KB0042310 to recover from temporary database connection glitches similar to those experienced in Your case.

2 Likes