SharePoint 2013. The site feature being activate has a dependency on hidden Site Collection scope Feature November 22, 2012
Posted by juanpablo1manrique in Install, SharePoint.Tags: install, SharePoint
add a comment
Y aqui empezamos con SharePoint 2013,
Al intentar activar el feature de Performance Point de SharePoint 2013 me aparecio este error, muy poco diciente,
SharePoint 2013. The site feature being activate has a dependency on hidden Site Collection scope Feature ‘FeatureDefinition/15/05891451-f0c4-4d4e-81b1-0dabd840bad4’ (ID:’05891451-f0c4-4d4e-81b1-0dabd840bad4). Hidden features cannot beauto-activated across scopes. There may be one or more visible site Collection scoped features that auto-activate the dependent hidden feature.
Me puse en la tarea de ver que feature era el que estaba haciendo falta, y encontre BICenter Data Connections Feature,
lo active y al intentar activar nuevamente el Feature de Performance Point este funciono correctamente,
Bueno eso fue todo,
saludos
Archivos ashx y asmx en Empty SharePoint Project November 22, 2012
Posted by juanpablo1manrique in SharePoint.Tags: Developer, SharePoint
add a comment
Me he encontrado con este problema al intentar agregar a un proyecto un archivo ashx y asmx en un Empty SharePoint Project, de sharepoint para que se despliegue en un archivo .wsp
- 1. Debe estar ubicado en Layouts, para lo cual debemos mapear la carpeta en el proyecto,
- 2. Una estrategia es tener un sitio web normal crear el archivo asmx o ashx y luego copiarlo y pegarlo al proyecto de sharepoint esto debido a que la opción de agregar un item no nos da la posibilidad de agregar este tipo de items
- 3. Se comnpila el proyecto y se le da deploy, al hacer esto nos encontramos con el siguiente error Could not create type ‘MyProject.Handler1’.
- 4. Para encontrar la solucion de este problema di bastantes vueltas pero lo encontre de la siguiente manera.
- a. Dentro del proyecto de Sharepoint cree un Visual Web Part el cual en la cabecera tiene una línea <%@ Assembly Name=”$SharePoint.Project.AssemblyFullName$” %>
- b.Esta línea permite que luego de hacer deploy, los archivos que quedan en 14 (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\CONTROLTEMPLATES) esta linea se convierte en <%@ Assembly Name=”MyProject, Version=1.0.0.0, Culture=neutral, PublicKeyToken=7bf1drt64fd3c7da7″ %>
- c. Pero con los archivos asmx y ashx no sucede lo mismo, para este caso fue necesario tomar esta línea y agregarla directamente al archivo, al hacer esto se logro el objetivo luego de hacer deploy de la solucion la misma ya funcionaba correctamente. y es posible utilizar los servicios
Happy SharePoint Coding!!
Language of database does not match language of site October 6, 2012
Posted by juanpablo1manrique in SharePoint.5 comments
Al intentar crear el PWA desde el central administrator
Application Management -> Manage Service Application -> [project application] -> Create Project Web App Site
Aparece un error Failed – see the Application event Log
Al revisar en los archivos de Logs se detecta ek siguiente error
Microsoft.Office.Project.Server.Administration.ProvisionException: Language of database does not match language of site
Solucion
Para resolver este problema, ejecute estos scripts en las bases de datos que estoy migrando
USE ProjectServer_Published
SELECT WADMIN_DEFAULT_LANGUAGE from dbo.MSP_WEB_ADMIN
USE ProjectServer_Draft
SELECT WADMIN_DEFAULT_LANGUAGE FROM dbo.MSP_WEB_ADMIN
USE ProjectServer_Archive
SELECT WADMIN_DEFAULT_LANGUAGE from dbo.MSP_WEB_ADMIN
El resultado fue 3082 o sorpresa estamos en Español asi que fue al central administrator a intentar provisionar de nuevo y seleccione español Ahi se demoro un poco y finalmente funciono
Microsoft.Office.Project.Server.Administration.ProvisionException: Mismatched databases October 6, 2012
Posted by juanpablo1manrique in SharePoint.3 comments
Al intentar crear el PWA desde el central administrator
Application Management -> Manage Service Application -> [project application] -> Create Project Web App Site
Aparece un error Failed – see the Application event Log
Al revisar en los archivos de Logs se detecta ek siguiente error
Microsoft.Office.Project.Server.Administration.ProvisionException: Mismatched databases
Solucion
Aqui fue necesario entrar a las propiedades de la base de datos y verificar en las propiedades extendidas que los GUID coincidieran en las 4 bases de datos, se igualaron todos en nuestras bases de datos ProjectServer_Published, ProjectServer_Draft, ProjectServer_Archive, ProjectServer_Reporting
Luego de corregido este problema se procedio nuevamente a ejecutar el proceso de creación del PWA pero se presento este nuevo inconveniente
New-SPProjectWebInstance : The PWA URL specified is in use in another PWA site or pending provisioning job. October 6, 2012
Posted by juanpablo1manrique in SharePoint.2 comments
En el proceso de migración de la granja al intentar correr el comando
New-SPProjectWebInstance -Url http://project.contoso.com/litware -AdminAccount “CONTOSO\Administrator” -PrimaryDbserver “DEMO2010A” -PublishedDbname “Litware_Published” -ArchiveDbname “Litware_Archive” -DraftDbname “Litware_Draft” -ReportingDbserver “DEMO2010A” -ReportingDbname “Litware_Reporting”
Aparecio este error
New-SPProjectWebInstance : The PWA URL specified is in use in another PWA site or pending provisioning job.
La solución
Este proceso finalmente lo lleve acabo desde el Central administrator. Ingresando por Service application, application project y dando en New Project web site, aqui aparecio en los LOGS el error de ir a revisar el Log en donde encontre
Microsoft.Office.Project.Server.Administration.ProvisionException: Mismatched databases
New-SPProjectWebInstance : Service Application not found. October 6, 2012
Posted by juanpablo1manrique in SharePoint.2 comments
En el proceso de migración de la granja al intentar correr el comando
New-SPProjectWebInstance -Url http://project.contoso.com/litware -AdminAccount “CONTOSO\Administrator” -PrimaryDbserver “DEMO2010A” -PublishedDbname “Litware_Published” -ArchiveDbname “Litware_Archive” -DraftDbname “Litware_Draft” -ReportingDbserver “DEMO2010A” -ReportingDbname “Litware_Reporting”
Aparecio este error
New-SPProjectWebInstance : Service Application not found.
La solución
En este caso faltaba ingresar al central administrator y subir los servicios de Project Server 2010
Services on server y dar start en Project Application Service
Otro paso que faltaba realizar era el de crear el service application
Manage Service applications y crear un service application de project
Migración de Project Server 2007 a Project Server 2010 October 6, 2012
Posted by juanpablo1manrique in SharePoint.1 comment so far
Hola Amigos
He tenido el gusto de realizar una migración de Project Server 2007 a Project Server 2010, y pues aqui les comento mi experiencia con el tema
Antes de empezar, es necesario leer estos excelentes links que encontre
- http://technet.microsoft.com/en-us/library/ee662496
- http://technet.microsoft.com/en-us/library/ee662499(office.14)
- http://technet.microsoft.com/en-us/library/ee662500(office.14)
En este caso propusieron migrar project server en 2 pasos pero el segundo no me funciono y toco hacerlo desde el central administrator igual se los comparto http://blogs.msdn.com/b/chrisfie/archive/2010/05/27/how-to-upgrade-from-project-server-2007-to-project-server-2010-in-10min.aspx
El proceso de migración seleccionado para este caso fue FullDatabase Attach, dentro de esto encontre este link en donde se describen algunos issues bastante comunes
Y pues como siempre me surgieron varios problemas, aqui les comparto la solución
- New-SPProjectWebInstance : Service Application not found.
- New-SPProjectWebInstance : The PWA URL specified is in use in another PWA site or pending provisioning job.
- Microsoft.Office.Project.Server.Administration.ProvisionException: Mismatched databases
- Language of database does not match language of site
Saludos
Share Point 2010 en Windows8 September 2, 2012
Posted by juanpablo1manrique in SharePoint, Windows 8.Tags: SharePoint, Windows8
1 comment so far
Buen día amigos
Les cuento que he iniciado en el proceso de conocer Windows 8, para minimizar la cantidad de cambios que tenía que hacer instale Windows 8 sobre el mismo Windows 7 que ya tenía todas las aplicaciones instaladas y ya tenía SharePoint 2010 Instalado,
Instale Windows 8 con un archivo .ISO por medio de GIZMO para el montaje del ISO y todo funciono perfecto, lo que me evito quemar un CD con los medios,
Al iniciar el proceso la primera tarea fue ingresar al Control Panel y aquí descubrí una de las primeras funcionalidades de Windows 8, se le puede dar la tecla Windows y luego escribir directamente lo que queremos y saldrá la ventana de búsqueda de aplicaciones.
El el IIS aparecen los pool pero esta detinidos,
Al intentar iniciarlo y luego ingresar al sitio aparece este error
Y si se vuelve al IIS el pool se detiene nuevamente,
Al revisar las propiedades del usuario apareció que estaba activada la opción de “User must change password at next logon”
Le elimine la opción y le cambie la contraseña, adicionalmente verifique la opción de “Log on as a batch job” dado que se presentó este error en el eventviewer,
Para cambiar la política es necesario ingresar a la consolo mmc.exe y luego a local computer policy y agregar el usuario de servicio,
Y luego al intentar ingresar al central administrator ya ha vuelto a la vida
Pero nuestro sitio principal continuaba fallando,
Así que vamos y abrimos el web.config, aquí vemos otra de las nuevas ventanas de Windows 8,
Y lo modificamos para que podamos ver los errores para nosotros los desarrolladores, con SharePoint he aprendido a querer las ventanas amarillas,
Al revisar el event viewer se encontró el siguiente error,
The identity of application pool SharePoint Central Administration v4 is invalid. The user name or password that is specified for the identity may be incorrect, or the user may not have batch logon rights. If the identity is not corrected, the application pool will be disabled when the application pool receives its first request. If batch logon rights are causing the problem, the identity in the IIS configuration store must be changed after rights have been granted before Windows Process Activation Service (WAS) can retry the logon. If the identity remains invalid after the first request for the application pool is processed, the application pool will be disabled. The data field contains the error number.
System.ServiceModel.ServiceHostingEnvironment+HostingManager/33711845
Exception: System.ServiceModel.ServiceActivationException: The service ‘/SecurityTokenServiceApplication/securitytoken.svc’ cannot be activated due to an exception during compilation. The exception message is: Exception has been thrown by the target of an invocation.. —> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> System.ArgumentNullException: Value cannot be null.
Parameter name: certificate
Buscando En internet encontre este blog con algunas recomendaciones,
http://www.mysharepointadventures.com/2011/07/security-token-service-application-broken/
Intente correr el configuration wizard pero no funciono, así que reinicie,
Luego de mucho intentar entrar a los sitios y al central administrator logre entrar, mi sharepoint revivió,
Algo que detecte es que la consola de SQL SERVER Configuration Manager había desaparecido así que fui a buscarla en C:\Windows\SysWOW64\SQLServerManager10.msc
Al ejecutarla encontré el siguiente error
The remote procedure call failed. [0x800706be]
Al ver este error encontré que se puede descargar el service pack 2 de SQL SERVER 2008 R2 e instalarlo y esto soluciono el problema.
http://www.microsoft.com/en-us/download/details.aspx?id=30437
Espero que les sea de utilidad
SQL SERVER 2008 Enterprise VS Standard VS WorkGroup VS Web VS Express August 29, 2012
Posted by juanpablo1manrique in SharePoint, SQL SERVER 2008.Tags: SQLSERVER2008
3 comments
Recordando a mi buen amigo SQL SERVER 2008 …
| SQL SERVER 2008 | Enterprise | Standard | Work Group | Web | Express |
| Scalability & Performance | |||||
| Number of CPUs | 8 CPU | 4 CPU | 2 CPU | 4 CPU (Web Workloads Only) | 1 CPU |
| Memory Utilization | 2 TB Ram | 64 GB Ram | 4 GB Ram | OS Maximum | 1 GB Ram |
| Database Size | 524PB | 524PB | 524PB | 524PB | 10GB |
| x32 Hardware Support | Full | Full | Full | Full | Full |
| x64 Hardware Support | Full | Full | Full | Full | Full |
| Data Compression | Full | ||||
| Resource Governor | Full | ||||
| IA64 hardware support | Full | ||||
| Table and Index Partitioning | Full | ||||
| Parallel Index Operations | Full | ||||
| Parallel Consistency Checks (DBCC) | Full | ||||
| Scalable Shared Databases | Full | ||||
| Indexed views | Full | ||||
| Enhanced Read-ahead and Scan | Full | ||||
| High Availability (Always On) | |||||
| Database Mirroring | Yes (full) | Yes (Single Safety Full Only) | Witness only | Witness only | Witness only |
| Online System Changes | Full | Full | Full | Full | Full |
| Log Shipping | Full | Full | Full | Full | |
| Clustering | 16-node failover clustering | 2-node failover clustering | |||
| Automatic Corruption Recovery from Mirror | Full | ||||
| Log Stream Compression | Full | ||||
| Online Indexing | Full | ||||
| Mirrored Backups | Full | ||||
| Resource Governor | Full | ||||
| Backup Compression | Full | ||||
| Hot-add Memory and CPU Support | Full | ||||
| Database Snapshots | Full | ||||
| Fast Recovery | Full | ||||
| Online Page and File Restore | Full | ||||
| Replication | Full | ||||
| Replication | |||||
| SQL Server Change Tracking | Full | Full | Full | Full | Full |
| Merge Replication | Full | Full | Subscriber only ** | Subscriber only | Subscriber only |
| Transactional Replication | Full | Full | Subscriber only ** | Subscriber only | Subscriber only |
| Snapshot Replication | Full | Full | Subscriber only ** | Subscriber only | Subscriber only |
| Heterogeneous Subscribers | Full | Full | |||
| Oracle Publishing | Full | ||||
| Enterprise Security | |||||
| C2 Complaint Tracing | Full | full | Full | Full | Full |
| SQL Audit | Full | ||||
| Transparent Database Encryption | Full | ||||
| Extensible Key Management | Full | ||||
| Enterprise Manageability | |||||
| Hypervisor Support | Full | Full | Full | Full | Full |
| Database Migration Tools | Full | Full | Full | Full | Full |
| Policy-Based Management | Full | Full | Full | Full | Full |
| SQL Server Management Studio Tools | Full | Full | Full | Full | Full |
| * Database Mail | Full | Full | Full | Full | |
| Performance Data Collection | Full | Full | Full | Full | |
| SQL Server Agent | Full | Full | Full | Full | |
| Database Tuning Advisor | Full | Full | Full | Full | |
| Plan Guides | Full | Full | Full | ||
| SQL Profiler | Full | Full | Full | ||
| Standard Performance Reports | Full | Full | |||
| Distributed Partition Views | Full | ||||
| Parallel Index Operations | Full | ||||
| Automatic Query-to-index-View Matching | Full | ||||
| Unlimited Virtualization | Full | ||||
| Data Warehousing | |||||
| Create Cubes Without a Database | Full | Full | |||
| Auto-generate Staging and Datawarehouse Schema | Full | Full | |||
| Attribute Relationship Designer | Full | Full | |||
| Efficient Aggregation Designers | Full | Full | |||
| Scalable read-only AS | Full | ||||
| Partitioned Cubes | Full | ||||
| Distributed Partitioned Cubes | Full | ||||
| Data Compression | Full | ||||
| Star Join Query Optimizations | Full | ||||
| Change Data Capture (CDC) | Full | ||||
| Integration Services | |||||
| SQL Server Import and Export Wizard | Full | Full | Partial | Partial | Partial |
| Log Providers and Logging | Full | Full | |||
| XML Source | Full | Full | |||
| SSIS Run-time | Full | Full | |||
| Basic Data Profiling Tools | Full | Full | |||
| SSIS Package Designer & Service | Full | Full | |||
| Data Mining Query Transformation | Full | ||||
| Data Mining Model Training Destination Adapter | Full | ||||
| Fuzzy Grouping Transformation | Full | ||||
| Fuzzy Lookup Transformation | Full | ||||
| Term Extraction Transformation | Full | ||||
| Dimension Processing Destination Adapter | Full | ||||
| Partition Processing Destination Adapter | Full | ||||
| Reporting Services | |||||
| Reporting Services Memory Limits | OS Max | OS Max | 4GB | 4GB | 4GB |
| Report Designer | Full | Full | Full | Full | Full |
| Report Manager | Full | Full | Full | (report manager) | (report manager) |
| Role-based Security | Full | Full | (fixed roles) | (fixed roles) | (fixed roles) |
| Basic Data Profiling Tools | Full | Full | Full | Full | Full |
| Export to Excel, Word, PDF and Images | Full | Full | Full | Full | Full |
| Report Server Application Embedding | Full | Full | Full | Full | Full |
| Enhanced Gauges and Charting | Full | Full | Full | Full | |
| Custom Authentication | Full | Full | Full | Full | |
| Ad-hoc Reporting (Report Builder) | Full | Full | Full | ||
| SharePoint Integration | Full | Full | |||
| Email and File Share Delivery | Full | Full | |||
| Report History, Scheduling, Subscriptions and Caching | Full | Full | |||
| Data Source, Delivery and Rendering Extensibility | Full | Full | |||
| Scale-out Operational Report Configuration | Full | ||||
| Data-driven Report Subscriptions | Full | ||||
| Report Scale-out Deployment | Full | ||||
| Infinite Click-through in Ad-hoc Reports | Full | ||||
| Analysis Services | |||||
| Analysis Services Backup | Full | Full | |||
| Dimension, Attribute Relationship, Aggregate & Cube Design | Full | Full | |||
| Personalization Extensions | Full | Full | |||
| Analysis Services Scalable Shared Databases | Full | ||||
| Account Intelligence | Full | ||||
| Linked Measures and Dimensions | Full | ||||
| Perspectives | Full | ||||
| Semi-additive Measures | Full | ||||
| Writeback Dimensions | Full | ||||
| Partitioned Cubes and Distributed Partitioned Cubes | Full | ||||
| Custom Rollups | Full | ||||
| Data Mining | |||||
| Excel 2007 and Visio 2007 Add-in Support | Full | Full | |||
| Comprehensive Set of DM Algorithms | Full | Full | |||
| Integrated Data Mining Tools (Wizards, Editors, Model Viewers, Query Builder) | Full | Full | |||
| Parallel Model Processing | Full | ||||
| Cross Validation | Full | ||||
| Support for Plug-in Algorithms | Full | ||||
| Advanced Configuration and Tuning Options for Data Mining Algorithms | Full | ||||
| Support for Pipeline Data Mining and Text Mining with Integration Services | Full | ||||
| Sequence Prediction | Full | ||||
| Programmability | |||||
| MERGE and Upsert Capabilities | Full | Full | Full | Full | Full |
| New Date and Time Data Types | Full | Full | Full | Full | Full |
| Internationalization Support | Full | Full | Full | Full | Full |
| Full Text Search | Full | Full | Full | Full | Full |
| * Common Language Runtime (CLR) Integration | Full | Full | Full | Full | Full |
| Native XML Support | Full | Full | Full | Full | Full |
| XML Indexing | Full | Full | Full | Full | Full |
| FILESTREAM Support | Full | Full | Full | Full | Full |
| Entity Framework Support | Full | Full | Full | Full | Full |
| Spatial Support | Full | Full | Full | Full | Full |
| Development Tools | |||||
| Microsoft Visual Studio Integration | Full | Full | Full | Full | Full |
| Intellisense (Transact-SQL-and MDX) | Full | Full | Full | Full | Full |
| MDX Edit, Debug and Design Tools | Full | Full | Full | Full | Full |
| Spatial and Location Services | |||||
| Spatial And Location Indexes | |||||
| Spatial Indexes | Full | Full | Full | Full | Full |
| Geodetic Data Type | Full | Full | Full | Full | Full |
| Advanced Spatial Libraries | Full | Full | Full | Full | Full |
| Standards-based Spatial Support | Full | Full | Full | Full | Full |
* Available in SQL Server 2008 Express with Advanced Services Download vs. SQL Server 2008 Express Download.
** If an instance of Workgroup is used as a Publisher, it supports a maximum of 25 publications to all merge subscriptions. It supports an unlimited number of subscriptions to snapshot publications.
Reporting Services – Sharepoint Integrated Mode vs Native August 29, 2012
Posted by juanpablo1manrique in Developer, SharePoint, SQL SERVER 2008, SSRS, VS.Tags: SharePoint, SSRS
add a comment
En esta ocasión se intento hacer una diferenciación entre los dos modos de instalación de Reporting Services cuando se integra con SharePoint 2010, fue algo complejo espero que les guste
| SharePoint Integrated Mode | SharePoint Integrated Mode Whit SQL 2008 R2 | Native 2008 | |
| SharePoint collaboration Features, alerts and version control | x | x | |
| Tener un sitio unificado para accesar y manejar tanto .rdl como otros documentos | x | x | |
| SharePoint Permissions and authentication providers | x | x | |
| Use SharePoint large deployment to internet or intranet | x | x | |
| Manage custom application page and custom masterpage to improved desing | x | x | |
| Posibility to develop custom features for custom requirements, for exmaple manage report history | x | x | |
| Report Center | x | x | |
| Publish reports and datasources directly to sharePoint library or use direct upload action | x | x | |
| SharePoint collaboration Features, deliver reports thorugh e-mail, shared folder, data-driven subscriptions using data queried at run time | Según SharePoint | Según SharePoint | Según SSRS |
| Report viewer web Part whit page navigation, search, print and export features. | x | x | |
|
Program against a new SOAP endpoint to create custom applications that integrate with a SharePoint site
|
x | x | |
|
URL addressing is different in SharePoint integrated mode
|
x | x | |
| Atom Renderer specific icon in the ReportViewer web part toolbar. | x | x | |
| Improved Report Preview experience with Report Builder 3.0 and edit sessions. | x | x | |
| 2010 End Point Proxy. | x | x | |
| Support for SharePoint ULS Logging. | x | x | |
| Local Mode for viewing reports with SharePoint List data extension. | x | x | |
| Access Reporting in local mode when Access Services is enabled. | x | x | |
| 37 languages supported including bi-directional languages (Hebrew and Arabic) and complex script languages Reporting Services web pages. | x | x | |
| Reporting Services custom security extensions | x | ||
| Report Manager | x | ||
| Linked reports | x | ||
| My Reports | x | ||
| My Subscriptions | x | ||
| Batching methods | x | ||
| Support for Multiple SharePoint Zones. | x | ||
| Rs.exe utility supports scripting with servers in SharePoint Integrated mode. | x | ||
| Support using Trusted Account authentication for SharePoint web applications using login. | x | ||
| Report Parts. | x | ||
| 2010 management endpoint. | x | ||
| Microsoft Access reporting in connected mode when Access Services is enabled. | x | ||
| Relational, multidimensional, XML, and custom data sources | x | x | x |
| Tabular, matrix, chart, and free-form report layouts | x | x | x |
| Ad hoc reports | x | x | x |
| Drillthrough reports and interactivity | x | x | x |
| Presentation formats | x | x | x |
| Custom controls and report items | x | x | x |
| bookmarks and document maps | x | x | x |
| aggregate and summarize | x | x | x |
| Graphical elements | x | x | x |
| Command-line utilities for administration | x | x | x |
| Role-based security Report Manager | Según SharePoint | Según SharePoint | Según SSRS |
| On-demand access over Web connections | x | x | x |
| Subscriptions for E-mail or File share Delivery | Según SharePoint | Según SharePoint | Según SSRS |
| Data-driven subscriptions de Reporting Services | Según SharePoint | Según SharePoint | Según SSRS |
| Report Definition Language (RDL) | x | x | x |
| URL access parameterized URL strings | x | ||
| WMI provider Report Server Windows service | x | x | x |
Se esperaria que todas las funcionalidades de una librería esten disponibles en una librería de reportes, pero estas 2 no lo estan.
- SharePoint OutLook Calendar
- Report server integration Anonymous Access
Tomado de
http://msdn.microsoft.com/en-us/library/ms159273(v=sql.105).aspx
http://msdn.microsoft.com/en-us/library/bb326290(v=sql.105).aspx
Saludos
Letras y Números 
