Al realizar una actualización de evolution a la versión 1.10.1, ahora que ya soporta Report Viewer 2015 para Reporting Server, en un servidor Windows Werver 2008 R2, se presento el siguente eror al generar al visor un reporte elaborado con Reporting Services. System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.Types, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. Aseinfo.Infrastructure.Base.Exceptions.ReportGenerationException: Hubo un error generando un reporte local de Reporting Services. Ver la excepción interna para detalles. ---> Microsoft.Reporting.WebForms.LocalProcessingException: An error occurred during local report processing. ---> Microsoft.Reporting.DefinitionInvalidException: The definition of the report 'C:\inetpub\wwwroot\Evolution\UploadFile\Temp\d3fe0330-4e87-47f2-be78-64bb4531b7cb\rep_asistencia.rdlc' is invalid. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.SqlServer.Types, Version=12.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified. at Microsoft.ReportingServices.ReportIntermediateFormat.Persistence.IntermediateFormatWriter.Write(Object obj, Boolean verify, Boolean assertOnInvalidType) at Microsoft.ReportingServices.ReportPublishing.ReportPublishing.CreateHashForCachedDataSets() at Microsoft.ReportingServices.ReportPublishing.ReportPublishing.InternalCreateIntermediateFormat(Stream definitionStream, String& description, String& language, ParameterInfoCollection& parameters, DataSourceInfoCollection& dataSources, DataSetInfoCollection& sharedDataSetReferences, UserLocationFlags& userReferenceLocation, ArrayList& dataSetsName, Boolean& hasExternalImages, Boolean& hasHyperlinks, Byte[]& dataSetsHash) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CompileOdpReport(PublishingContext reportPublishingContext, IDataProtection dataProtection, PublishingErrorContext errorContext, String& reportDescription, String& reportLanguage, ParameterInfoCollection& parameters, DataSourceInfoCollection& dataSources, DataSetInfoCollection& sharedDataSetReferences, UserLocationFlags& userReferenceLocation, ArrayList& dataSetsName, Boolean& hasExternalImages, Boolean& hasHyperlinks, Byte[]& dataSetsHash) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CreateIntermediateFormat(PublishingContext reportPublishingContext, IDataProtection dataProtection) --- End of inner exception stack trace --- at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CreateIntermediateFormat(PublishingContext reportPublishingContext, IDataProtection dataProtection) at Microsoft.Reporting.ReportCompiler.CompileReport(ICatalogItemContext context, Byte[] reportDefinition, Boolean generateExpressionHostWithRefusedPermissions, ControlSnapshot& snapshot) --- End of inner exception stack trace --- at Microsoft.Reporting.ReportCompiler.CompileReport(ICatalogItemContext context, Byte[] reportDefinition, Boolean generateExpressionHostWithRefusedPermissions, ControlSnapshot& snapshot) at Microsoft.Reporting.LocalService.GetCompiledReport(PreviewItemContext itemContext, Boolean rebuild, ControlSnapshot& snapshot) at Microsoft.Reporting.LocalService.CompileReport() at Microsoft.Reporting.WebForms.LocalReport.EnsureExecutionSession() --- End of inner exception stack trace --- at Microsoft.Reporting.WebForms.LocalReport.EnsureExecutionSession() at Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, PageCountMode pageCountMode, CreateAndRegisterStream createStreamCallback, Warning[]& warnings) at Microsoft.Reporting.WebForms.LocalReport.InternalRender(String format, Boolean allowInternalRenderers, String deviceInfo, PageCountMode pageCountMode, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings) at Microsoft.Reporting.WebForms.LocalReport.Render(String format, String deviceInfo, PageCountMode pageCountMode, String& mimeType, String& encoding, String& fileNameExtension, String[]& streams, Warning[]& warnings) at Aseinfo.Infrastructure.Services.LocalReportingServices2005Generator.Generate(Reporte reporte, DataSet ds) in C:\work\a3e0cbded2a6d4b3\Infrastructure\Services\Reportes\LocalReportingServices2005Generator.cs:line 144 --- End of inner exception stack trace --- at Aseinfo.Infrastructure.Services.LocalReportingServices2005Generator.Generate(Reporte reporte, DataSet ds) in C:\work\a3e0cbded2a6d4b3\Infrastructure\Services\Reportes\LocalReportingServices2005Generator.cs:line 171 at Aseinfo.Infrastructure.Services.CrystalReportsGenerator.Generate(Reporte reporte, DataSet ds) in C:\work\a3e0cbded2a6d4b3\Infrastructure\Services\Reportes\CrystalReportsGenerator.cs:line 152 at Aseinfo.Infrastructure.Services.ReporteService.GenerateReport(Reporte reporte, IEnvironmentVariables variables, IDictionary`2 valoresParametros, String rutaTemporal) in C:\work\a3e0cbded2a6d4b3\Infrastructure\Services\Reportes\ReporteService.cs:line 134 at Aseinfo.Infrastructure.Controllers.ReportesController.GenerarReporte(String codigoReporte, Dictionary`2 parametros, Boolean mostrandoEnDialogo) in C:\work\a3e0cbded2a6d4b3\Infrastructure\Controllers\ReportesController.cs:line 413 asked 08 Feb '17, 17:45 Sandy Fernando Paz ♦♦ |
El problema se debe a que la actualización se realizo en Windows 2008 R2, el cual no trae el componente de Microsoft.SqlServer.Types, Version=12.0.0.0 el cual debe de instalarse del siguiente link: Microsoft® SQL Server® 2014 Feature Pack Específicamente el instalador: SQLSysClrTypes.msi en versión de 32 y 64 bits. Una explicación más detallada puede obtener de un error similar, pero para la versión anterior de Reporting Services, a que la que utiliza Evolution. Install SQLCLR Types for Report Viewer 2012 on Windows 2008 Server En algunos casos es necesario reiniciar el IIS answered 08 Feb '17, 18:03 Sandy A un cliente con versión 1.11.0.2 le da este problema, pero no puede instalar el software requerido porque ya tiene una versión superior. Se tendría que desintalar la versión y colocar la que sugiere el link?
(31 Aug '17, 17:01)
Juan Carlos Soria
|