Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
gringo89
Helper I
Helper I

ReportServer: error execution reports

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?

2 REPLIES 2
gringo89
Helper I
Helper I

the trouble can it come from the antivirus?

gringo89
Helper I
Helper I

Hi,

 

Any solutions for this trouble?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.