Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
the trouble can it come from the antivirus?
Hi,
Any solutions for this trouble?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
13 | |
10 | |
5 | |
4 | |
3 |