Error con reporte de Reporting Services Remoto

Question

Estoy configurando un reporte en Evolution como Reporting Services Remoto. En el parámetro "Ubicación" he especificado la ruta proporcionada del server remoto, y se ha modificado el Web.config:

<add key="ReportingServicesServer" value="http://applications/ReportServer/Evolution" />

...

        <endpoint address="http://applications/ReportServer/Evolution/ReportExecution2005.asmx"
            behaviorConfiguration="EndpointBehavior" binding="basicHttpBinding"
            bindingConfiguration="ReportExecutionServiceSoap" contract="RemoteSSRS2005Execution.ReportExecutionServiceSoap"
            name="ReportExecutionServiceSoap" />

        <endpoint address="http://applications/ReportServer/Evolution/ReportService2005.asmx"
            behaviorConfiguration="EndpointBehavior" binding="basicHttpBinding"
            bindingConfiguration="ReportingService2005Soap" contract="RemoteSSRS2005.ReportingService2005Soap"
            name="ReportingService2005Soap" />

alt text

Y al intentar generar el reporte se produce la siguiente exception:

Aseinfo.Infrastructure.Base.Exceptions.ReportGenerationException: Hubo un error generando un reporte Remoto de Reporting Services. Ver la excepción interna para detalles. ---> System.ServiceModel.Security.MessageSecurityException: The HTTP request is unauthorized with client authentication scheme 'Negotiate'. The authentication header received from the server was 'NTLM'. ---> System.Net.WebException: The remote server returned an error: (401) Unauthorized. at System.Net.HttpWebRequest.GetResponse() at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout) --- End of inner exception stack trace --- Server stack trace: at System.ServiceModel.Channels.HttpChannelUtilities.ValidateAuthentication(HttpWebRequest request, HttpWebResponse response, WebException responseException, HttpChannelFactory`1 factory) at System.ServiceModel.Channels.HttpChannelUtilities.ValidateRequestReplyResponse(HttpWebRequest request, HttpWebResponse response, HttpChannelFactory`1 factory, WebException responseException, ChannelBinding channelBinding) at System.ServiceModel.Channels.HttpChannelFactory`1.HttpRequestChannel.HttpChannelRequest.WaitForReply(TimeSpan timeout) at System.ServiceModel.Channels.RequestChannel.Request(Message message, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation) at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg) at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type) at Aseinfo.Infrastructure.Services.RemoteSSRS2005.ReportingService2005Soap.GetReportParameters(GetReportParametersRequest request) at Aseinfo.Infrastructure.Services.RemoteReportingServices2005Generator.Generate(Reporte reporte, DataSet ds) in c:\BuildAgent\work\89066541112bb801\Infrastructure\Services\Reportes\RemoteReportingServices2005Generator.cs:line 94 --- End of inner exception stack trace --- at Aseinfo.Infrastructure.Services.RemoteReportingServices2005Generator.Generate(Reporte reporte, DataSet ds) in c:\BuildAgent\work\89066541112bb801\Infrastructure\Services\Reportes\RemoteReportingServices2005Generator.cs:line 169 at Aseinfo.Infrastructure.Services.LocalReportingServices2005Generator.Generate(Reporte reporte, DataSet ds) in c:\BuildAgent\work\89066541112bb801\Infrastructure\Services\Reportes\LocalReportingServices2005Generator.cs:line 125 at Aseinfo.Infrastructure.Services.CrystalReportsGenerator.Generate(Reporte reporte, DataSet ds) in c:\BuildAgent\work\89066541112bb801\Infrastructure\Services\Reportes\CrystalReportsGenerator.cs:line 146 at Aseinfo.Infrastructure.Services.ReporteService.GenerateReport(Reporte reporte, IEnvironmentVariables variables, IDictionary`2 valoresParametros) in c:\BuildAgent\work\89066541112bb801\Infrastructure\Services\Reportes\ReporteService.cs:line 153 at Aseinfo.Infrastructure.Controllers.ReportesController.GenerarReporte(String codigoReporte, Dictionary`2 parametros, Boolean mostrandoEnDialogo) in c:\BuildAgent\work\89066541112bb801\Infrastructure\Controllers\ReportesController.cs:line 276

Answer 1

0

Pareciera ser que el server no acepta comunicaciones que no vengan autorizadas con NTLM. ¿Podrías confirmar con la gente que tipo de autenticación requiere el server?

¿Que ves en la pantalla cuando accedes a los URL que configuraste para los 2 endpoints (*.asmx)?

link

answered 05 Jun '15, 17:01

sabanito ♦♦
(suspended)
accept rate: 54%

Ya a esta hora ya se retiraron, no creo que me respondan. En cuanto a los endpoints,probe pero no carga nada.

(05 Jun '15, 18:06) Valentino Lopez

Answer 2

0	Con que usuario de base de datos Evolution intenta generar los reportes? Esto para poder configurar los permisos para este usuario del lado del servidor de reportes del cliente. link answered 09 Jun '15, 10:02 Valentino Lopez (suspended) accept rate: 42%

Answer 3

Se asigno permisos a los usuarios de base de datos que utiliza Evolution, y para el usuario que se tiene configurado en el DataSet del reporte. Pero igual da una excepción, aunque esta es diferente a la anterior.

System.Data.Entity.Core.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: String or binary data would be truncated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteNonQuery() in c:\TeamCity\buildAgent\work\1de24adb938b932d\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 264 at System.Data.Entity.Infrastructure.Interception.InternalDispatcher1.DispatchTTarget,TInterceptionContext,TResult at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction) at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func1 operation) at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions options, Boolean executeInExistingTransaction) at Aseinfo.Infrastructure.Data.ConfigDataContext.SaveChanges(SaveOptions options) in c:\BuildAgent\work\89066541112bb801\Infrastructure\DataAccess\EF\SqlServer\Model\ConfigDataContext.cs:line 82 at Aseinfo.Infrastructure.Base.Entity.EntityServiceBase2.SaveChanges() in c:BuildAgentwork89066541112bb801InfrastructureBaseEntityEntityServiceBase.cs:line 528 at Aseinfo.Infrastructure.Controllers.ReportesController.AgregarEjecucionEnBitacora(Reporte reporte, Dictionary2 parametros, String errorMessage, String stackTrace, ResultadoEjecucionReporte resultadoEjecucion) in c:\BuildAgent\work\89066541112bb801\Infrastructure\Controllers\ReportesController.cs:line 695 at Aseinfo.Infrastructure.Controllers.ReportesController.GenerarReporte(String codigoReporte, Dictionary2 parametros, Boolean mostrandoEnDialogo) in c:BuildAgentwork89066541112bb801InfrastructureControllersReportesController.cs:line 299 at lambda_method(Closure , ControllerBase , Object[] ) at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary2 parameters) at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary2 parameters) at System.Web.Mvc.Async.AsyncControllerActionInvoker.<begininvokesynchronousactionmethod>b39(IAsyncResult asyncResult, ActionInvocation innerInvokeState) at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`2.CallEndDelegate(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<invokeactionmethodfilterasynchronouslyrecursive>b3d() at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>cDisplayClass46.<invokeactionmethodfilterasynchronouslyrecursive>b3f() at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>cDisplayClass46.<invokeactionmethodfilterasynchronouslyrecursive>b3f() at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>cDisplayClass46.<invokeactionmethodfilterasynchronouslyrecursive>b3f() at System.Web.Mvc.Async.AsyncControllerActionInvoker.AsyncInvocationWithFilters.<>cDisplayClass46.<invokeactionmethodfilterasynchronouslyrecursive>b3f() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass33.<begininvokeactionmethodwithfilters>b32(IAsyncResult asyncResult) at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass21.<>cDisplayClass2b.<begininvokeaction>b1c() at System.Web.Mvc.Async.AsyncControllerActionInvoker.<>cDisplayClass21.<begininvokeaction>b__1e(IAsyncResult asyncResult)

Error con reporte de Reporting Services Remoto

Follow this question

Evolution en BitBucket

Evolution en JIRA

Related questions