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's gravatar image

Sandy
(suspended)
accept rate: 16%

edited 08 Feb '17, 18:09

Fernando%20Paz's gravatar image

Fernando Paz ♦♦
17.3k81635


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

link

answered 08 Feb '17, 18:03

Sandy's gravatar image

Sandy
(suspended)
accept rate: 16%

edited 31 May '18, 11:12

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 Juan%20Carlos%20Soria's gravatar image
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Evolution en BitBucket

En este sitio puede acceder al código fuente, centro de descargas y reportar bugs, propuestas y mejoras para Evolution.

Evolution en JIRA

En este sitio puedes sugerir nueva funcionalidad para Evolution, o puedes votar por la funcionalidad ya propuesta por otros usuarios.

Tags:

×44

Asked: 08 Feb '17, 17:45

Seen: 3,447 times

Last updated: 31 May '18, 11:12

[Acerca de] [Preguntas Frecuentes] [Privacidad] [Soporte] [Contacto]
Copyright 2013-2018. Asesores en Informática