lunes, 4 de noviembre de 2013

User Profile Synchronization Service – Starting

Siempre aparece un nuevo error cuando configuramos el User Profile Syncronization. Cada implementación del user profile syncronization difiere de las anteriores.

image

Las mejores guías para solucionar el inicio del servicio de User Profile Syncronization:

http://www.harbar.net/articles/sp2010ups2.aspx

http://blogs.msdn.com/b/spses/archive/2012/12/17/proxy-configuration-issues-with-upa-in-sharepoint-2010-2013.aspx

http://chrishattonnzlsp.wordpress.com/2010/11/30/hostid-is-not-registered-forefront-identity-manager/

http://blogs.technet.com/b/steve_chen/archive/2010/09/20/user-profile-sync-sharepoint-2010.aspx

http://blogs.technet.com/b/meamcs/archive/2013/02/18/sharepoint-2010-2013-user-profile-synchronization.aspx

En este caso en particular, en el event viewer me aparecía el siguiente error:

.Net SqlClient Data Provider: System.Data.SqlClient.SqlException: HostId is not registered
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
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)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader()
at Microsoft.ResourceManagement.Data.DataAccess.RetrieveWorkflowDataForHostActivator(Int16 hostId, Int16 pingIntervalSecs, Int32 activeHostedWorkflowDefinitionsSequenceNumber, Int16 workflowControlMessagesMaxPerMinute, Int16 requestRecoveryMaxPerMinute, Int16 requestCleanupMaxPerMinute, Boolean runRequestRecoveryScan, Boolean& doPolicyApplicationDispatch, ReadOnlyCollection`1& activeHostedWorkflowDefinitions, ReadOnlyCollection`1& workflowControlMessages, List`1& requestsToRedispatch)
Y en los logs de ULS de Sharepoint:
Medium ILM Configuration: Post setup configuration. 
High ILM Configuration: Post setup configuration failed with error code –532459699
Para solucionarlo tuve que habilitar las opciones de “Auto Create Statistics” y “Auto Update Statistics” en la base de Sync. Después de habilitar estas opciones, reinicie el servicio de windows.
image
image
image
Para finalizar hice un iisreset, y el servicio cambio el estado a Started.
image
 

Error al abrir el central administration en Sharepoint 2013

This operation can be performed only on a computer that is joined to a server farm by users who have permissions in SQL Server to read from the configuration database. To connect this server to the server farm, use the SharePoint Products Configuration Wizard, located on the Start menu in Microsoft SharePoint 2010 Products

image

Para solucionarlo, ingresa al servidor de SQL Server y verifica que la instancia de SQL Server esté iniciada.

image

Una vez iniciado, se soluciona el problema.

image

domingo, 3 de noviembre de 2013

Usage and Health Data Collection Proxy–Stopped

Al crear la granja de Sharepoint 2013, me aparece el Usage and Health Data Collection Proxy en estado “stopped”.

image

Para iniciarlo, hago lo siguiente:

  • Ejecuto: Get-SPServiceApplicationProxy
  • Obtengo el ID del proxy detenido. Ej:

image

  • Y ejecuto el siguiente script

$UsageApp = Get-SPServiceApplicationProxy | Where {$_.ID -eq "f1bb3c19-5b91-4392-b41e-a4956f4a2def"}
$UsageApp.Provision()

image