sábado, 9 de agosto de 2014

Problemas con los content types de Reporting Services en Sharepoint 2013

Después de haber instalado reporting services en modo integrado como explica el siguiente procedimiento de technet: http://msdn.microsoft.com/en-us/library/jj219068.aspx, los content types de Reporting Services no me aparecían (había activado Report Server Integration Feature en el site collection)

image

  • Trate de desactivar y activar vía powershell la feature de Report Server Integration Feature, y seguía sin aparecer los content types (Enable-SPFeature -Identity E8389EC7-70FD-4179-A1C4-6FCB4342D7A0 -Url http://sharepoint/ -Force). También me lanzaba el error en algunos sitescollection:The content type with Id 0x010100C3676CDFA2F24E1D949A8BF2B06F6B8B defined in feature {e8389ec7-70fd-4179-a1c4-6fcb4342d7a0} was found in the current site collection or in a subsite.
  • Entonces lo que hice fue desinstalar desde “Programs and feature” el add-In de SSRS. Lo hice en cada servidor de mi granja (1 WFE y 1 App Server)

image

  • Reinicie los servidores.

Primero les detallo la topología de la granja:

  • 1 WFE
  • 1 Application Server
  • 1 Database Server

A continuación extraje el archivo rsSharePoint.msi de la ISO  SQL Server 2012 Service Pack 1 x64 y la copie a D:\Temp

Después ingresé via línea de comandos (recuerda ejecutarla como Run as administrator) , y ejecuté lo siguiente:

Msiexec.exe /i rsSharePoint.msi SKIPCA=1

Este paso lo hice tanto en el WFE como en el Application Server.

El siguiente paso SOLO lo hice en el servidor de Application Server.

Ingrese a %temp% del servidor, es decir al folder Temp del usuario actual: \Users\<your name>\AppData\Local\Temp

En ese directorio debería estar el .exe, rsCustomAction.exe

A continuación ejecute en el directorio de temp: .\rsCustomAction.exe /i

Después de 10 minutos, finalizó el proceso. Recuerda sólo ejecutar este comando en un servidor.

2014-08-09 12:17:11: User: XXXXXXXXX
2014-08-09 12:17:11: Installing Report Server feature.
2014-08-09 12:17:14: Beginning uninstall of cab files.
2014-08-09 12:17:14: Cab files uninstalled successfully.
2014-08-09 12:17:14: Calling copyappbincontents command.
2014-08-09 12:18:45: SharePoint Products Configuration Wizard version 15.0.4569.1503. Copyright (C) Microsoft Corporation 2012. All rights reserved.

Performing configuration task 1 of 3
Initializing SharePoint Products configuration...

Successfully initialized the SharePoint Products configuration.

Performing configuration task 2 of 3
Installing the application content files...

The SharePoint Central Administration Web Application content files will not be installed because a Central Administration Web Application is either off-line or does not exist on th
is server.

Installing the SharePoint Web Application content files...

Successfully installed the application content files.

Performing configuration task 3 of 3
Finalizing the SharePoint Products configuration...

Successfully completed the SharePoint Products configuration.

Total number of configuration settings run: 3
Total number of successful configuration settings: 3
Total number of unsuccessful configuration settings: 0
Successfully stopped the configuration of SharePoint Products.
Configuration of the SharePoint Products has succeeded.

2014-08-09 12:18:45:
2014-08-09 12:18:45: copyappbincontents command completed successfully.
2014-08-09 12:19:05: Adding ReportServer feature to farm.
2014-08-09 12:19:06: Installed ReportServer feature.
2014-08-09 12:19:26: Adding ReportServer feature to farm.
2014-08-09 12:19:26: Installed ReportServer feature.
2014-08-09 12:19:46: Adding ReportServerStapling feature to farm.
2014-08-09 12:19:46: Installed ReportServerStapling feature.
2014-08-09 12:20:06: Adding ReportServerStapling feature to farm.
2014-08-09 12:20:06: Installed ReportServerStapling feature.
2014-08-09 12:20:26: Adding ReportServerItemSync feature to farm.
2014-08-09 12:20:26: Installed ReportServerItemSync feature.
2014-08-09 12:20:46: Adding ReportServerItemSync feature to farm.
2014-08-09 12:20:46: Installed ReportServerItemSync feature.
2014-08-09 12:21:06: Adding ReportServerCentralAdmin feature to farm.
2014-08-09 12:21:08: Installed ReportServerCentralAdmin feature.
2014-08-09 12:21:28: Adding ReportServerCentralAdmin feature to farm.
2014-08-09 12:21:28: Installed ReportServerCentralAdmin feature.
2014-08-09 12:21:48: Adding PowerView feature to farm.
2014-08-09 12:21:48: Installed PowerView feature.
2014-08-09 12:22:08: Adding PowerView feature to farm.
2014-08-09 12:22:09: Installed PowerView feature.
2014-08-09 12:22:29: Adding PowerViewStapling feature to farm.
2014-08-09 12:22:29: Installed PowerViewStapling feature.
2014-08-09 12:22:49: Adding PowerViewStapling feature to farm.
2014-08-09 12:22:49: Installed PowerViewStapling feature.
2014-08-09 12:22:49: Activating Report Server feature to root level site collections.

2014-08-09 12:22:57: Updating DocIcon.xml file
2014-08-09 12:22:57: DocIcon.xml file updated.
2014-08-09 12:22:57: Stopping W3SVC service.
2014-08-09 12:22:59: Starting W3SVC service.
2014-08-09 12:22:59: Copying the client.config file from an embeded resource.
2014-08-09 12:22:59: Copied the client.config file to: 'C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\15\WebClients\Reporting\Client.config'
The command completed successfully

Después reinicio los dos servidores de nuevo. Una vez reiniciado, verifico los servicios de SSRS.

image

Creo el service Application

image

image

image

Verifico que esté en el WFE la carpeta:

C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\WebClients\Reporting\Client.config. Puede tardar un tiempo en aparecer.

Después ingreso a un site collection y verifico que estén los content types

image

image

La prueba la hice sobre un site collection pre-existente. Pero que pasa si creo un nuevo site collection? También aparece por default activado.

También aparecen los content types cuando se los quiero agregar a una librería.

image

Espero que le haya sido de ayuda.

No hay comentarios:

Publicar un comentario