Problema Report Service, Ayuda

23/03/2010 - 22:46 por Jorge Vega | Informe spam
Al tratar de mostrar un reporte en Reporting Service 2005, se presenta el
siguiente error

Esto sucede cuando la aplicación web trata de mostrar el reporte que se
encuentra en el servidor de datos, pues si lo hacemos desde el ambiente de
trabajo (vb.net) funciona perfectamente.

Estamos usando Sql server 2005 y VB.net 2005.El sistema operativo es Windows
Server 2003 Enterprise y el IIS 6.0


A connection attempt failed because the connected party did not properly
respond after a period of time, or established connection failed because
connected host has failed to respond XX.X.XX.XXX:80

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Net.Sockets.SocketException: A connection attempt
failed because the connected party did not properly respond after a period of
time, or established connection failed because connected host has failed to
respond

Source Error:
Line 205: Me.rsv_reporte.ShowToolBar = True
Line 206: ' Se envian los parametros al reporte en caso de que no sea
necesario. Las siguientes son excepciones
Line 207: Me.rsv_reporte.ServerReport.SetParameters(parametros)
Line 208: ' Hace visible el control Viewer reporte
Line 209: Me.rsv_reporte.Visible = True

Source File: C:\Inetpub\wwwroot\sistema\SFM\SFM0062WF.aspx.vb Line: 207

Stack Trace:
[SocketException (0x274c): A connection attempt failed because the connected
party did not properly respond after a period of time, or established
connection failed because connected host has failed to respond]
System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot,
SocketAddress socketAddress) +239
System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP) +35
System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure,
Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState
state, IAsyncResult asyncResult, Int32 timeout, Exception& exception) +224

[WebException: Unable to connect to the remote server]

Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +204

Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname) +47

Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +112
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +125
Microsoft.Reporting.WebForms.ServerReport.SetParameters(IEnumerable`1
parameters) +67
SFM_SFM0062WF.Imprime_Reporte_Service(String str_reporte, String
str_rango) in C:\Inetpub\wwwroot\sistema\SFM\SFM0062WF.aspx.vb:207
SFM_SFM0062WF.Page_Init(Object sender, EventArgs e) in
C:\Inetpub\wwwroot\sistema\SFM\SFM0062WF.aspx.vb:297
System.Web.UI.Control.OnInit(EventArgs e) +99
System.Web.UI.Page.OnInit(EventArgs e) +12
System.Web.UI.Control.InitRecursive(Control namingContainer) +333
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +378
 

Leer las respuestas

#1 Ricardo Junquera
24/03/2010 - 09:16 | Informe spam
Hola Jorge

Puede ser un problema del origen de datos o de como haces la llamada al
informe.
¿En el proyecto de Reporting Services tienes la Propiedad
OverWriteDataSource a True?
¿Si llamas al informe http://xx..xx.xx.xx/ReportS ves los informes'

Un saludo

Ricardo Junquera
Consultor Business Intelligence
Microsoft Active profesional España 2010
BG&S a delaware company


"Jorge Vega" wrote:

Al tratar de mostrar un reporte en Reporting Service 2005, se presenta el
siguiente error

Esto sucede cuando la aplicación web trata de mostrar el reporte que se
encuentra en el servidor de datos, pues si lo hacemos desde el ambiente de
trabajo (vb.net) funciona perfectamente.

Estamos usando Sql server 2005 y VB.net 2005.El sistema operativo es Windows
Server 2003 Enterprise y el IIS 6.0


A connection attempt failed because the connected party did not properly
respond after a period of time, or established connection failed because
connected host has failed to respond XX.X.XX.XXX:80

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.

Exception Details: System.Net.Sockets.SocketException: A connection attempt
failed because the connected party did not properly respond after a period of
time, or established connection failed because connected host has failed to
respond

Source Error:
Line 205: Me.rsv_reporte.ShowToolBar = True
Line 206: ' Se envian los parametros al reporte en caso de que no sea
necesario. Las siguientes son excepciones
Line 207: Me.rsv_reporte.ServerReport.SetParameters(parametros)
Line 208: ' Hace visible el control Viewer reporte
Line 209: Me.rsv_reporte.Visible = True

Source File: C:\Inetpub\wwwroot\sistema\SFM\SFM0062WF.aspx.vb Line: 207

Stack Trace:
[SocketException (0x274c): A connection attempt failed because the connected
party did not properly respond after a period of time, or established
connection failed because connected host has failed to respond]
System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot,
SocketAddress socketAddress) +239
System.Net.Sockets.Socket.InternalConnect(EndPoint remoteEP) +35
System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure,
Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState
state, IAsyncResult asyncResult, Int32 timeout, Exception& exception) +224

[WebException: Unable to connect to the remote server]

Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +204

Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname) +47

Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID) +112
Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo() +125
Microsoft.Reporting.WebForms.ServerReport.SetParameters(IEnumerable`1
parameters) +67
SFM_SFM0062WF.Imprime_Reporte_Service(String str_reporte, String
str_rango) in C:\Inetpub\wwwroot\sistema\SFM\SFM0062WF.aspx.vb:207
SFM_SFM0062WF.Page_Init(Object sender, EventArgs e) in
C:\Inetpub\wwwroot\sistema\SFM\SFM0062WF.aspx.vb:297
System.Web.UI.Control.OnInit(EventArgs e) +99
System.Web.UI.Page.OnInit(EventArgs e) +12
System.Web.UI.Control.InitRecursive(Control namingContainer) +333
System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +378


Preguntas similares