Tips/info #6 Team Foundation Server

1-Cambiar la frecuencia del refresco de los reportes deTFS

La base relacional (Tfs_Warehouse) es procesada dentro de los 2 minutos que los cambios son realizados a un store operacional, y el cubo SQL Server Analysis Services (Tfs_Analysis) es procesada dentro de las 2 horas.

Pasos para reducir el refresco de datos de reportes

1. Abrir la página WarehouseControlWebService

http://localhost:8080/tfs/TeamFoundation/Administration/v3.0/WarehouseControlService.asmx

2. Click en ChangeSetting

3. En el campo settingID, escribir IncrementalProcessIntervalSeconds

4. En el campo newValue, agrega 600, y a continuación click en el botón Invoke

Esto seteará el refresco del cubo a 10 minutos

2-Locks huérfanos en TFS 2010

El error dice: The item $/proj/xyz is locked for check-out by (null) in workspace (null).

El siguiente script de sql borra los locks huérfanos.

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
DELETE l
FROM  tbl_Lock l
LEFT JOIN tbl_PendingChange pc
ON l.PendingChangeId = pc.PendingChangeId
WHERE pc.PendingChangeId IS NULL

3-Propiedades de MSBUILD para Sharepoint 2010

Cualquier propiedad de MSBuild se definen en el archivo Microsoft.VisualStudio.SharePoint.targets, archivo de proyecto o un archivo de usuario del proyecto puede ser utilizado en proyectos de Visual Studio SharePoint. Además de las propiedades de MSBuild comunes proporcionados por el proyecto, define las propiedades de SharePoint adicionales que son específicos para los proyectos de SharePoint.

Property Name	Description
SharePointSiteUrl	A string that represents the URL to the SharePoint site.
SandboxedSolution	A Boolean value that indicates whether the solution is a sandboxed solution.
ActiveDeploymentConfiguration	The active deployment configuration.
IncludeAssemblyInPackage	A Boolean value that indicates whether the assembly is included in the package file.
PreDeploymentCommand	A string value that represents the command to execute in the pre-deployment command step.
PostDeploymentCommand	A string value that represents the command to execute in the post-deployment command step.
CustomBeforeSharePointTargets	A string that represents the path of a MSBuild targets file. If the targets file exists and is defined, it is imported before any SharePoint targets data. This property lets you customize the package process by predefining packaging-related properties without modifying the shipped SharePoint targets file, yet the targets file still applies to all SharePoint projects.
CustomAfterSharePointTargets	A string that represents the path of a MSBuild targets file. If the targets file exists and is defined, it is imported after all of the SharePoint targets data. This property lets you customize the package process by overriding packaging-related properties and targets without having to modify the shipped SharePoint targets file, yet the targets file still applies to all SharePoint projects.
LayoutPath	A string that represents the root directory where each of the files to be packaged are temporarily placed before they are added to the .wsp file. This path can be useful to know when you override the BeforeLayout and AfterLayout targets to add, remove, or modify files to be packaged, because you can use it to alter the contents of the .wsp file.
BasePackagePath	A string that represents the folder in which the package is placed. This value uses the output directory of the project, such as Bin\Debug.
PackageExtension	A string that represents the file name extension to append to the package. The default value is wsp.
AssemblyDeploymentTarget	A string that represents the location where the project assembly is deployed on the SharePoint server. Its value is either GlobalAssemblyCache (the default) or WebApplication. This property can also be set in the Properties window.
PackageWithValidation	A Boolean value that specifies whether validation is performed before packaging. This property lets you ignore validation errors while building Packages.
ValidatePackageDependsOn	A string that defines additional targets to execute before the ValidatePackage target.
TokenReplacementFileExensions	A string that defines the files that have their tokens replaced during packaging.

4-“TF50309: The following account does not have sufficient permissions” al tratar de conectar TFS MSSCCI provider con Visual Basic

Al tratar de conectar a TFS con Visual basic, nos lanza este error, para ello se debe ingresar la url de tfs de la siguiente manera: http://tfs _server:puerto/tfs/team_project_collection/