ReportServer: error execution reports

gringo89 — Wed, 04 Dec 2019 12:39:05 GMT

Hi,

We have got the error on ReportServer when I Execute ssrs report:

ReportServer_0-1!1234!12/04/2019-12:37:46:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Impossible de lire la ligne de données suivante du jeu de données « Sales ». ---> Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: The connection either timed out or was lost. ---> System.IO.IOException: Impossible de lire les données de la connexion de transport : Une connexion existante a dû être fermée par l’hôte distant. ---> System.Net.Sockets.SocketException: Une connexion existante a dû être fermée par l’hôte distant à System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) --- Fin de la trace de la pile d'exception interne --- à System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size) à System.IO.BufferedStream.Read(Byte[] array, Int32 offset, Int32 count) à Microsoft.AnalysisServices.AdomdClient.DimeRecord.ReadBody(Byte[] buffer, Int32 offset, Int32 count) à Microsoft.AnalysisServices.AdomdClient.TcpStream.Read(Byte[] buffer, Int32 offset, Int32 size) --- Fin de la trace de la pile d'exception interne --- à Microsoft.AnalysisServices.AdomdClient.XmlaReader.ReadEndElement() à Microsoft.AnalysisServices.AdomdClient.FormattersHelpers.ReadRowsetProperty(XmlReader reader, String elementName, String elementNamespace, Type type, Boolean throwOnInlineError, Boolean isArray, Boolean convertToLocalTime) à Microsoft.AnalysisServices.AdomdClient.XmlaDataReader.ReadColumnValue(Int32 ordinal) à Microsoft.AnalysisServices.AdomdClient.XmlaDataReader.SequentialReadXmlValue(Int32 ordinal) à Microsoft.AnalysisServices.AdomdClient.XmlaDataReader.GetRowXmlValues(Object[] xmlValues) à Microsoft.AnalysisServices.AdomdClient.XmlaDataReader.InternalRead() à Microsoft.ReportingServices.DataExtensions.AdoMdDataReaderBase.Read() à Microsoft.ReportingServices.DataExtensions.MappingDataReader.GetNextRow()

We have 2 servers: On the one part, there is SQL server and ReportingService (4CPU, 64 Go RAM) and the other part SSAS (4 CPU 32 Go RAM).

When I restart the reporting service, the reports work fine : Reporting service uses 20 Go RAM! But after report reexecutions, we have the above error and i can see that reporting service uses 1Go RAM. I need restart reporting service.

I don't understand the trouble. Can you help me please?

Re: ReportServer: error execution reports

gringo89 — Thu, 05 Dec 2019 16:49:13 GMT

Hi,

Any solutions for this trouble?

Re: ReportServer: error execution reports

gringo89 — Thu, 12 Dec 2019 14:38:10 GMT

the trouble can it come from the antivirus?

topic ReportServer: error execution reports in Report Server

ReportServer: error execution reports

Re: ReportServer: error execution reports

Re: ReportServer: error execution reports