Not able to download files from IIS site or application folders which are set to directory browsing.

by Xavier Dilip Kumar 31. October 2014 06:33

Exceptions:

  • The resource you are looking for might have been removed, had its name changed, or is temporarily unavailable
  • Unable to download file from server
  • unable to open this internet site. The requested site is either unavailable or cannot be found. Please try again later

Explanation:

By default, IIS blocks some file extentions. You can see the blocked file extensions in "Request Filtering" --> "File Name Extensions" tab.  

Solution:

  • Open IIS manager (cmd --> inetmgr)
  • Click on the folder or application site
  • Double click on "Request Filtering"

  • Select "File Name Extensions" tab
  • Select the file extension and click on remove.

If you still have the issue with some other extensions, then add the file extensions to "MIME Type" as below.

  

 

 

Tags:

General

Unable to process the request. wait a few minutes and try performing this operation again

by Xavier Dilip Kumar 30. October 2014 09:03

Explanation:

Encountering the issue of an error message when we double click on a file in SharePoint to open just for viewing.

Solution:

To fix the issue, enable the following setting in the sharepoint library settings.

Tags:

SharePoint

The load test results repository was created with a previous version and it is not compatible

by Xavier Dilip Kumar 20. October 2014 18:12

Exception:

Explanation:

Create load test result repository by execution the loadtestresultsrepository.sql script at <VS ultimate Install Dir>\Common7\IDE

or 

1) Open a cmd prompt

2) Change into the following directory: <VS ultimate Install Dir>\Common7\IDE

3) Run the following command: sqlcmd -S <DB Server Name> -i loadtestresultsrepository.sql

 

Tags:

Web Performance & Load Tests

TF221122: Error While Processing TFS OLAP Cube

by Xavier Dilip Kumar 1. October 2014 11:44

Exception:

After upgrading to TFS 2013, the TFS OLAP Cube fails processing with one of the following messages:

Invalid column name ‘System_AssignedTo__Name’.; 42S22;

Invalid column name ‘System_AssignedTo__SID’.; 42S22

Query execution failed for dataset ‘ds[Whatever]‘

Solution:

  • In TFS Admin Console, look up the account under “Account for accessing data sources” under the “Analysis Services” tab (Reporting » Edit).
  • In SQL Server, add that account to the Tfs_Warehouse database, to the TFSEXECROLE role.

Tags:

SQL Analysis Services | TFS 2013

Bulk editing option in MTM 2013

by Xavier Dilip Kumar 30. September 2014 12:59

Solution:

1. Open the team project web portal
2. Goto Test tab --> select a test suite --> click on “View List” --> click on “Grid” to view the testcases for bulk edit.

 imageimage

Tags:

MTM

Cleaning up and reduce the size of the TFS database using TFS stored procedures

by Xavier Dilip Kumar 7. September 2014 18:57

Explanation:

  • If your Files table is large:

EXEC prc_DeleteUnusedFiles 1, 0, 100

@partitionId = 1, @chunkSize=100

The nature of prc_deleteunusedfiles is that once it deletes a bunch of files, that causes more files to be able to be deleted due to our delta chains. This procedure is run on a weekly schedule so it will clean up the next set of files the next time the job runs.  This procudure can executed  repeatedly until FWFilesToDelete stops decreasing.This procedure may run for a long time, that’s why it has the third parameter which defines the batch size.

  • If your Content table is large:

EXEC prc_DeleteUnusedContent 1

@partitionId = 1

  • Queries to monitor the DB size

SELECT COUNT(*) FROM tbl_File f WHERE f.PartitionId = 1 AND f.OwnerId = 1 AND f.DeletedOn IS NULL AND f.CreationDate < DATEADD(DAY, -1, GETUTCDATE()) 

AND f.FileId NOT IN (SELECT FileId FROM tbl_Version WHERE PartitionId = 1 AND FileId IS NOT NULL)

 

SELECT COUNT(*) from tbl_File f WHERE f.DeletedOn IS NOT NULL

Tags:

Is it possible to restore a deleted files in TFS?

by Xavier Dilip Kumar 30. June 2014 12:47

Solution:

  1. Open Visual Studio IDE  
  2. Go to Tools --> Options in Visual Studio menu and open the options. Select Source Control --> Visual Studio Team Foundation Server and tick the option "Show deleted items in Source Control Explorer" and click OK.
  3. Now you can see the deleted files appear in Source Control Explorer. Right click on the Folder/File you want to restore and click "Undelete" to get it restored.
 
 

Tags: ,

Visual Studio 2010 | Visual Studio 2012 | Visual Studio 2013

The number of items on your backlog exceeds the configured limit of 500

by Xavier Dilip Kumar 29. April 2014 19:29

Explanation:

The default display limit for the task board is 500 tasks.For performance reasons, the task board is restricted to display a maximum of 500 work items. When you open the task board, all work items are loaded into cache. so changing the limit increases the memory demand on your clients and might cause issues. Limiting the number of work items may yield quicker load times

Work Around:

You can modify the process template to increase the limit.

For TFS 2012, edit Agileprocessconfig.xml

For TFS 2013, edit ProcessConfiguration.xml

Step 1: Export Agileprocessconfig.xml from the team project

witadmin exportagileprocessconfig /collection:"http://tfs:8080/tfs/DefaultCollection"

 /p:DefaultProject /f:"c:\Agileprocessconfig.xml"

Step 2: Add a attribute "workItemCountLimit" to the <IterationBacklog> element as below

<?xml version="1.0" encoding="utf-8"?>
<AgileProjectConfiguration>
  <IterationBacklog workItemCountLimit="1000">
    <Columns>
      <Column width="50" refname="Microsoft.VSTS.Scheduling.Effort" />
      <Column width="400" refname="System.Title" />
      <Column width="100" refname="System.State" />
      <Column width="100" refname="System.AssignedTo" />
      <Column width="50" refname="Microsoft.VSTS.Scheduling.RemainingWork" />
    </Columns>
  </IterationBacklog>
  <ProductBacklog>
    <AddPanel>
      <Fields>
        <Field refname="System.Title" />
      </Fields>
    </AddPanel>
    <Columns>
      <Column width="400" refname="System.Title" />
      <Column width="100" refname="System.State" />
      <Column width="50" refname="Microsoft.VSTS.Scheduling.Effort" />
      <Column width="200" refname="System.IterationPath" />
      <Column width="200" refname="System.Tags" />
    </Columns>
  </ProductBacklog>
</AgileProjectConfiguration>

Step 3 : validate your Agileprocessconfig.xml

witadmin importagileprocessconfig /collection:"http://tfs:8080/tfs/DefaultCollection"

 /p:DefaultProject /f:"c:\Agileprocessconfig.xml" /v


Step 4: Import Agileprocessconfig.xml to the team project

witadmin importagileprocessconfig /collection:"http://tfs:8080/tfs/DefaultCollection"

 /p:DefaultProject /f:"c:\Agileprocessconfig.xml"

Tags: ,

TFS | TFS 2012 | TFS 2013

How to activate Shared Parameters feature on a team project upgraded from TFS 2013 to TFS 2013.2 update

by Xavier Dilip Kumar 24. April 2014 20:01

Explanation:

After updating TFS 2013 server with update TFS 2013.2, Shared Parameters feature need to be activated manually for each team project. This feature provides to testers and test leads the ability to manage test parameter data at one place by using Shared Parameters. Any subsequent changes to parameter data can be updated at one place and all the test cases referencing the Shared Parameter are automatically updated

Solution:

  • Open team project web access.
  • Click on "Test" tab --> "parameters" option

          

  • Click on "Configure feature" option.

          

  • Click on "Verify" & "Apply" button

Tags: ,

Difference between Visual Studio Scrum 2013 and Visual Studio Scrum 2013.2 Process Template

by Xavier Dilip Kumar 24. April 2014 19:46

Explanation:

  • Visual Studio Scrum 2013.2 Process Template has support for Shared Parameters which will enable testers the ability to manage test parameter data centrally. New Shared Parameter work item type, category, and link type are updated to the process template.
  • The ProductBacklog.wiq and SprintBacklog.wiq queries have been removed

Tags:

TFS 2013

About the author

My name is Xavier Dilip Kumar Jayaraj and I am a Software Configuration Management Engineer with a background in application development, Build & packaging using Install Shield.

Profile in LinkedIn

  

Quotes I Like

"Failure will never overtake me if my determination to succeed is strong enough."  - Dr. APJ. Abdul Kalam

"Always be yourself, express yourself, have faith in yourself, do not go out and look for a successful personality and duplicate it." - Bruce Lee

"Technology is just a tool. In terms of getting the kids working together and motivating them, the teacher is the most important." - Bill Gates

"Innovation distinguishes between a leader and a follower." - Steve Jobs

Disclaimer

The information provided here is based on my expreriences, troubleshooting and online/offline findings. It can be used as is on your own risk without any warranties and I impose no rights.

Month List