cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gringo89 Frequent Visitor
Frequent Visitor

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
Highlighted
gringo89 Frequent Visitor
Frequent Visitor

Re: ReportServer: error execution reports

Hi,

 

Any solutions for this trouble?

gringo89 Frequent Visitor
Frequent Visitor

Re: ReportServer: error execution reports

the trouble can it come from the antivirus?

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)