Learning curve

Leh Trip 2016 : details

2016-07-12T22:23:00.000+05:30

Follow the below links to the pages explaining the topics.

Thought Process

Day 1

Day 2

Agile is Fun

2011-04-26T10:21:00.002+05:30

Whenever I ask any person in an interview or in normal discussion, “What is Agile and what are your thoughts on it?” The Answer I always get is, “There is no Documentation in Agile and we have a morning meet every day.” Is that Agile all about?

What I feel, Agile is about “Inspect and Adapt”, “Continuous Feedback”, “Collaboration” etc.

My first “Sprint Planning”. Before we began the actual Sprint planning, we declared the available number of days of each of us and that gave the Scrum master the estimate amount of Man hours he has for the present Sprint. We used to consider 6.5hr productive for a resource in a day and estimations were done considering the same hours. The participants in the planning were, Solution Architect, Senior members, BA team, UI team, Scrum master, Development, and QA. Sometimes the Product Owner also joined use in the planning. Each one of us was given cards bearing numbers 1 to 10 and a question card. Decided list of PBI’s are shown to the team and the BA explains all the items to the team so that all have the insight and scope of each PBI. On declaring a PBI by the scrum master, all the Dev raised a card declaring that if he has to do the task he will take this many hours, if the task is of Dev. Two members, having the highest number of hours and the lowest number of hours then justify why they think it will take their selected amount of time. It’s quite possible both of them overlooked few things or underestimated/overestimated the task. After the discussion, the cards are raised again by whole team and a mutual agreed estimate is noted down by repeating the above exercise. It takes almost a day for Sprint Planning but it’s worth it considering the whole sprint.

In Normal circumstances when a person says I am “Done” with a particular task, what does he mean by the term done? E.g. he was given a task to write a test case for a particular module, and he is “done”. This means he has written the test case? He got it reviewed by someone? He got the coverage calculated?. What do you mean by “DONE”? Here comes the other best thing we used to do is “Definition of DONE”. When a developer says I am done with this task and he moves the card from Dev to Dev-Review what are the things he should have done to call it DONE or move the card?

E.g.

1. Written the code to meet the requirements

2. Written the Unit testing for all procedures and functions

3. Written proper comments

4. Verified the UI matches the standards etc.

Once he does all the things, he will call it “Done”. The most important thing is, in the “Sprint Planning” the estimate was done based on the steps you define in the “Definition of Done”.

Why should we have “SCRUM”?. We say the following things in the morning scrum.

1. I was doing this yesterday: This ‘in a way’ was my commitment to my team for yesterday. Did I do it? Yes-Great. No-why?

2. I will be doing this today: This is my commitment. I will do it. I like when someone says, “Hey don’t do it, I did some portion of it yesterday in my part of work, and you can reuse that bit”

3. Impediments: I am facing this issue. Anyone knows the solution? Mr. X, I need you to finish that code today as I am waiting for it to do my job (and it was planned and estimated so). OR I am waiting for the feedback on this PBI from BA/Scrum Master. Once I get it I will start working on it.

It is required that the team understands the reason why this is important. The idea is not to monitor any person and grill him, but being positive and trying to find out what the problem is and take care that those things are considered too in the next Sprint Planning meeting. This way we get good collection of points which needs to be addressed in the Sprint Retrospective meetings too. Believe me SCRUM helps and being positive in SCRUM helps more.

The best practice we followed after SCRUM was to update the “Task board”. This gives the whole team what is going good/bad/worst just by a glimpse of the board. Even people know what task is coming up next. The members come to know the Review’s coming up for the day and discuss who will pick up review of what. It’s easy. (The Code review roaster also helped a lot in this case)

We also used to update the “Burndown Chart” on day to day basis. It was not decided in the Sprint planning that who is going to work on a particular task until the new task is completely dependent on the previous one. Updating the Burndown chart also allowed the team members to pick a new task by themselves, without anyone telling him. This is flexibility and collaboration helps at this stage. Burndown chart allows the Scrum master and the Team also, to monitor them against the Planned Tasks VS Time for that particular Sprint. This raises early flags or alarms if you will, in the team to take precautionary measures (If possible) to move the team back on track. This helps to find out the Team velocity, which leads to accurate Sprint planning’s at the later stage.

One of the activities done at the end of the sprint is “Spring Review”. This activity was interesting as the person who developed/tested a particular bit of functionality, proudly demonstrated that to the client and receive instant feedback. The whole team used to sit in a room with the client may be physically present in the room, or over live meetings and do the presentation. Normally Sprint review and Sprint retrospective are done on the same day.

“Sprint Retrospectives” was held at the end of each sprint. The motto is to discuss among the team members what went right, wrong, worst in the sprint. I still remember the host of the Sprint Retrospective asking a person who didn’t look happy for the sprint, “Mr. X what do you have to say about this sprint?” The reply was “This sprint sucks”. On asking “Why?” he had a legitimate list of points. The points were discussed and Action points were noted which were followed by all team members. The next sprint Mr. X was certainly happier. Again, the aim of the retrospective is to discuss such points in more matured and professional manner. This is “Inspect and Adapt”

According to me, these terms and methodologies we followed were very adequate and at the end of the day everyone used to be satisfied. There is a thinking that, just do your work with any kind of process you need, and as far as it works for us, the terms or the rules doesn’t matter. This is like “Customizing the Customizations”. Would you allow yourself being called by other name? Stick to things which have been proven and studied upon.

For Indian friends like me, the only thing I want to point out is, it’s in our blood that we cannot listen to criticism, feedback in a positive manner. It’s not always true that when someone tells you to improve in a particular area means he is pointing at you, but take it positively and try to improve on it. Learn from the criticism and take it in a constructive manner. Try to work with more collaboration and ownership. Communicate more with people and share the knowledge. I am also learning.

Disclaimer: May be I am not good at writing the things, but just sharing my thoughts from the learning in my past experience.

Cannot find object xxx or you dont have permissions - SP in SQL 2005

2010-12-31T16:31:00.001+05:30

One of my colleague wrote a stored procedure in which he was just truncating a table. On calling that SP from a BO developed in .Net 4.0 we got a message as below

"Cannot find object \"xxx\" or you dont have permissions"

The fun part was when we started the SQL Profiler it showed us that it has ran the SP without any errors. There was no error in EVENTVWR too.

On trying multiple options, I ended up giving OWNER rights to NETWORKSERVICE (the login which our service was hosted with) and it worked properly.

TestPartner 6.0 (23 July 2007)

2010-09-24T17:01:00.008+05:30

(I wrote this blog when I was with Conchango and I was assigned to evaluate various automation tools and prepare a comparison report. I wrote this blog at that time and thought to add it out in this blog too.)

TestPartner 6.0

TestPartner 6.0 is a regression testing tool. It is a product of Compuware Corporation.

In my course of evaluation of regression testing tools I evaluated Rational Robot 2007 and TestPartner. As I have worked earlier on Rational Robot 2003 in one of my projects in my previous company, I was pretty much confident on it, so I evaluated it and prepared few nice scripts which helped in smoke testing of a project. Then I switched over to TestPartner.

The best thing I found was it was self explanatory. First thing I came across was Visual Test. In the first 2 hours of evaluation I was able to parametize and add verification points without any hassles which is rare in any tool without any help from any document. If you click on any of the steps it highlights the control on which the particular action is taken. All the logic that helps us to enter various business rules to make automated testing easy and actually functional were just a wizard away. Select the steps you need to repeat, open the wizard, mention the condition of stopping the repetition and that’s it.

All the things can be done through Visual Tests but there can be cases where we require test scripting. The scripting is done in VBA. As a result unlike Rational Robot, (SQA Basic Scripting) TestPartner has IntelliSense. (Feels like a boon ) Now we are just a dot (.) away from what we require. This I reckon is the biggest advantage against Rational according to me.

Sometimes it is really necessary to make functions, procedures etc. All can be made in a Test Script and can be called from a Visual test as and when required. (And that is just a right click away)

Then I got a chance to attend a 2 day workshop on TestPartner in Bangalore arranged by Compuware. It was a great opportunity to uncover and discover all the hidden functionalities which TestPartner has.

In the workshop I met existing users of TestPartner 5.6. (This doesn’t have Visual Test) I got a chance to talk to them regarding the ease and use of TestPartner in actual projects. (So that we don’t feel like guinea pigs) And expectedly they were in favor of TestPartner. They were quite enthusiastic in telling me how TestPartner has made their life easy. They also were quite happy with the kind of support they receive in case they are stuck at some point in time. I am seriously concerned about the support part of any tool. As this is the major thing which is required once we buy the product. I was thinking hopefully they are speaking the truth. Ironically after coming back to Vadodara I was stuck at some place and I mailed Compuware guys to help me out with the problem. Believe me within 10 minutes I am receiving a call from Bangalore to troubleshoot my problem, which was helpful.

The tool has inbuilt version management system which reduces our cost of buying an external tool to manage and maintain test scripts.

I automated many of the functionalities of the project I was working on which reduced the smoke testing time almost by half. Initially we required 6 man days. After implementing the scripts it took only 2½ man days.

To conclude, the tool is very intuitive. Visual test is a major advantage of using this tool. Support is also very good. It is really easy to implement it in any project. So, looking forward to use TestPartner in future projects.

Click here for original blog

The setup failed to read IIsMimeMap table. The error code is -2147023550.

2010-01-05T14:54:00.002+05:30

I've been facing issues with installation of Reporting service 2005 and making it run but for the first time I faced an issue while uninstalling it. On trying to uninstall I got the following error
"The setup failed to read IIsMimeMap table. The error code is -2147023550"
Solution:
1. Stop IIS Admin service
2. Stop IIS
3. Uninstall Reporting service.
Result:
Successfully uninstalled Reporting service 2005

ASP .Net Service account appears blank

2010-01-05T14:39:00.002+05:30

Its been time I got a chance to trouble shoot a Reporting Service Problem, and this time it was on Windows 7. Actually I faced this issue once before and I managed to skip trouble shooting that.
Reading the initial "Program incompatible message" on running the setup of SQL 2005 I came to know that its necessary to install SP3 for SQL 2005 to run on Windows 7. I downloaded it and installed successfully.
On opening (my favorite) Reporting service Configuration tool, I observed that the "ASP .Net Service Account" appeared blank and because of that I was not able to change the Application pool to ReportServer (which is created by default)
Reading few blogs I changed the Application Pool to Reportserver (from DefaultAppPool) using IIS-> Advanced Settings
But still the problem of the ASP .Net service account was lingering.
I ran the following command to get the service account appear in the configuration tool.
aspnet_regiis -ga "NT Authority\NetworkService"

Change in PC name, stops Reporting Service 2005

2009-08-12T12:04:00.004+05:30

I deployed few reports on my Test Machine with TestMachine. As we wanted to implement a format of PC names, we happened to change the name of the Machine to e.g CompanyTestMachine
Before the rename happened, our system as well as the reports were working properly. Once the name was changed, we started getting error Report Server database not found.
Then I thought to redo the settings of Reporting service so as to change the required settings. On following the steps, I came across a error
User CompanyTestMachine\ASPNet not found
I then tried repairing the Microsoft Framework which didnt help. I ran the aspnet_regiis.exe /i command which also didn't help. I read many blogs but couldn't find a way out so I ended up renaming the machine to its original name.
I am still searching for a solution to this problem, if someone reading this has one I would appreciate if you could share it with me.

Unit Tests : Not Runnable - VSTS 2008 SP1

2009-07-22T18:13:00.007+05:30

I am sure most of us are facing this issue. After adding ordered unit tests to our project and creating a test list for these whenever we open the project the Tests are indicated as Not-Runnable.

This can be sorted by pressing the Refresh button in the Test View as below

Read this for more details

http://social.msdn.microsoft.com/forums/en-US/vststest/thread/2f907f7b-c689-439e-9dfb-731b5b7795f4/

Delete a Team Project

2009-05-27T15:06:00.002+05:30

One of the new team members accidently created a team project (Remiss of the administrator for giving him full control).
Found out a way to delete the team project
Open a command line on your team foundation server and cd to
drive:/%program files%\Microsoft Visual Studio 9.0\Common7\IDE (For VSTS 2008)

tfsdeleteproject /q /force /server:<tfs server> "<project name>"

Restoring TFS 2008

2009-05-25T19:14:00.002+05:30

I am sure everyone will be taking backup of their TFS on regular basis. Being new to TFS I thought to try and restore the TFS on a new machine, to avoid the risk of not taking backup of anything.

I had a spare PC in which I installed the trial of TFS. the environment of the new machine was now exactly the same as that of the old (or existing)machine.
The link which helped me for this was
http://msdn.microsoft.com/en-us/library/ms404869.aspx

Error 28002 : Unknown Error

2009-05-22T17:27:00.005+05:30

This was the forth time I was installing TFS 2008 and I got this error for the first time. It has to do with the DNS. TFS is not able to resolve the Domain Name as a result of which it gives TFS3010 (if you see the Event log).
Resolution:
1. Open the web.config from the path below (TFS Root)
%systemdrive%/Program Files\Microsoft Visual Studio 2008 Team Foundation Server/Web Services/Web.config

Add the below key
<add key="<DomainFullyQualifiedPath>" value="dcHostName" />

And hit Retry on the Error message.

Error (rsAccessDenied) - 'NT AUTHORITY\NETWORK SERVICE' are insufficient

2009-05-20T12:25:00.002+05:30

I did all the necessary settings to the reporting service so that my domain users can access the reporting service, but still I was getting rsAccessDenied error.

Then I read once solution in one of the forums in which there were few steps mentioned which solved my problem
1. Open http://localhost/reports
2. Go to Home Properties
3. Add a BUILTIN\Users and gave it Browser permissions and the problem was solved.

TF30042: The database is full. Contact your Team Foundation Server administrator.

2009-05-20T09:34:00.009+05:30

Since many days we were facing problems with Low disk space on our TFS machine. I noticed that the LoadTest database Log was around 19Gigs. Till then I was not aware that there is a setting for restricting growth of the Log file. I then moved my mdf and ldf files to a drive with ample space and then restricted the growth of Log not more than 20Gigs.

And subsequently I changed the settings of all the TFS database not to grow exponentially. But the next day I came and tried to start my VSTS, it started givine me the same error

TF30042: The database is full. Contact your Team Foundation Server administrator.

Reading few blogs, I decided to change the Recovery Model of all the database from full to simple. And I was able to use my TFS without any issues after that. Below are the steps

1. Go to properties of the database

2. In Options tab, change Recovery model from Full to Simple.

I read in couple of blogs that it is not advisable to use Full Recovery model for the database which is used for version control.

Zoom and Draw during presentation

2009-05-14T12:47:00.001+05:30

Seeing many presentations I was wondering how was it possible for a person to zoom at a particular area in the screen and draw while in that mode. Did a search and found a pretty slick tool. Have a look
http://technet.microsoft.com/en-au/sysinternals/bb897434.aspx

SharePoint Access rights management

2009-05-06T14:21:00.009+05:30

For managing the sharepoint access rights for users of TFS follow the following steps.

1. In Team Explorer right click on the Team Project for which you want to give access rights and select Securiy menu item.

2. In the screen displayed click on the Windows Sharepoint Services Site Administration link.

Note: The credentials of the user doing this changes should have the administrator privilages for sharepoint.

3. Internet explorer will be displayed in which you will be able manage rights for groups and individuals. You also will be add/remove users from a group.

How to remove a Service

2009-05-05T18:52:00.003+05:30

We are developing a application which is based on SOA. We are maintaing PowerShell scripts and batch files to Install/Uninstall and Start/Stop the services.
But in certain cases (especially when the Powershell script is updated and user doesn't run the previous script to uninstall service) the services still remains and doesn't get uninstalled.

For this there is a simple command.
1. Run Visual Studio Command Prompt (Run as administrator)
2. write the following code
sc delete <servicename>

Note : You can get the name of the service from the properties of the service

Installation VSTS 2008, Team Explorer, SQL 2005

2009-04-23T18:10:00.003+05:30

Installations required to be followed in sequence.
1. Install IIS.
2. Visual Studio Team System 2008
3. VSTS 2008 Team Explorer
4. VSTS 2008 SP1
5. SQL Server 2005 (or 2008) (Also if you are working with Service Packs of SQL you can subsequently install that too)
6. VSTS Power Tools (If required)

If you installed Team Explorer into Visual Studio after you applied Visual Studio 2008 Service Pack 1, you’ll need to re-apply the service pack. If you don’t, then you’ll be running an unsupported “mixed mode” installation, meaning the core Visual Studio components will be at the SP1 servicing level and TE will be at the RTM servicing level.

Struggling with LoadTest Reports

2009-04-23T16:27:00.006+05:30

Been two days I was struggling with troubleshooting Loadtest reports. Still I am not able to access the inbuilt LoadTest report which comes with VSTS 2008.

Thanks to Shai, for giving me this wonderful link which solved my purpose of reports.

Use DataSource in Unit Test

2009-04-21T14:38:00.014+05:30

I had a unit test in C#, written to test one of the functions of my service. Considering best practices of testing like Boundary Value testing, there were number of data input which I had to consider to completely test the function. For doing that one of the ways is, instead of writing different tests with different type of inputs, we can classify the test with respect to passing tests and failing tests.

I created a test for passing input values and another test in which the Test had an Expected Exception. In both the cases I had wide range of data input. For this I used a CSV file for getting the input data. So for in a particular test, all the data combinations mentioned in the CSV will be executed.
For using a Data Source in a test we will have to perform the following steps.

1. Go to the Properties of the Test (Press F4 after selecting the Test in TestView)

2. Select the Data Connection String button
3. Then select the type of input file suitable to you (CSV or XML) In my case I used CSV

4. First Row of the CSV is automatically considered as header. (This needs to be taken care of while preparing the CSV)

5. Select Yes/No in the next dialog box if you wish to select this CSV to be added in deployment item and also get added to the solution. If you select Yes, the CSV will be added to the current project and also it will be added in the list of Deployment files in the LocaltestConfig.TestConfig file.

6. The Test will now look like

[DataSource("Microsoft.VisualStudio.TestTools.DataSource.CSV", "DataDirectory\\CSV.csv", "CSV#csv", DataAccessMethod.Sequential), DeploymentItem("Test\\QA\\UnitTestProjectName\\CSV.csv"), TestMethod]
public void TestUsingDataSource()
{
}

7. For using the data in the test you will have to write TestContext.DataRow["Name"]

Note: The name you mention here should be exact to the header name given in the CSV.
The retrieved data from CSV can be converted to string by Convert.ToString(TestContext.DataRow["Name"]).Trim();

That’s it. The test will be using the CSV whenever it runs now. The important thing to remember is whenever you run the test once from the test view, it will have individual runs inside it which will depend on the number of rows of the CSV.

Add Check-in Policy

2009-04-20T12:13:00.010+05:30

The Check-in policy can be added at Team Project level. Below are the steps.
1. Open the Team Explorer
2. Select the Team Project
3. Right Click -> Source Control

4. Click on Check-in Policy Tab

5. Click on Add button.

You will get the options as above if you have installed PowerTools, otherwise 4 options will be displayed

1. Builds

2. Code Analysis

3. Testing Policy

4. Work Items

Paired Testing - successful implementation of a complex functionality

2009-04-15T19:15:00.003+05:30

Pair-Testing is the exercise where a pair of testers (or any other pair of people) perform tests together (using only one interface with the AUT), with the objective of complementing each other with their backgrounds, points-of-view, experience, knowledge, or even luck.

The logic behind doing this is an additional person that looks at what you are doing and thinks about additional or different operations. This is really very helpful when testers/devs are working on a very complex bit of functionality.

One of the developers in my team was working on a functionality few days back which was really complex. He finished the first chunk of delivery. I paired up with him (Paired testing – 1 dev & 1 tester) and we started implementing the functionality. There were few unique scenario’s which we both came up individually. Been developing/testing that functionality, the dev or the tester would have forgotten implementing/testing that.

The functionality took good shape. It took more time than it was estimated at that point in time. (Naturally we were two resources working on the same bit). The code was tested by another tester and to our surprise the most complex functionality had only one new bug in it. Then we could make out that development didn’t take more time than expected as we had only one bug to fix and retest.

According to me pairing two testers and two developers always works, but we should try and experiment mixing them both in each other’s work. I am sure it will be worth for sure.

Load Testing of SOA - Services

2009-03-25T09:22:00.000+05:30

I've been searching for a method by which I can perform Load testing of the services of my application (SOA Based). I wrote few Unit tests which I used to run from the inbuilt Load Agent with VSTS 2008 and get the results.

I was searching for another way by which I can get the counters from the services itself. I figured out how that can be done.

In the app.config of the service we want to host, we can write the following


<configuration>
        <system.serviceModel>
    <diagnostics performanceCounters="All" />
        </system.serviceModel>
<\configuration>

This exposes all the performance counters from the service. There is a good article of this in MSDN

http://msdn.microsoft.com/en-us/library/ms735098.aspx

The counters can be viewed in the performance monitor of the machine hosting the service.
For opening this write perfmon.exe in Run

Create a new Log Setting for the required counters. And start the log setting before you perform the Load Test. You have to give a path to the output of the log as per requirement. I did with .blg file and it gives a pretty slick graphical representation of the data for all the counters selected in the profile.

Add/Modify Area & Iteration

2009-03-17T15:00:00.000+05:30

Atlast I found it!!

I was searching for a option to add Area or Iteration to my Project. I had one option in my WebAccess portal of my Team Project but that didnt reflect in my Creat New work item Classification block.

Searched many things but didnt get any help. (the option is obvious but didnt get any help)

It can be done as below.

Auto-Generated Unit Tests for WCF services

2009-03-10T11:52:00.000+05:30

A really cool tool that was released by Microsoft enables you to take a WCF trace file and a WCF client proxy, or a WCF interface contract, and generates a unit test that replays the same sequence of calls found in the trace file. The code generated is easily modifiable so that data variation can be introduced for the purpose of doing performance testing. The tool generates code for both Visual Studio 2005 and Visual Studio 2008.

Click here to download the tool

VSTS 2008 : Unit Testing - Keyboard Shortcuts

2009-03-04T14:41:00.000+05:30

Normally I try to use keyboard shortcuts as much as possible. I believe that it saves time.
Here are some handy unit testing keybaord shortcuts with Visual Studio:
Run Mode
1. Ctrl + R, A – Run all tests
2. Ctrl + R, T – Run tests in context (based on if cursor is in function, class, or namespace)
3. Ctrl + R, F – Runs all tests that are checked in Test Results
Debug Mode:
1. Ctrl + R, Ctrl + A – Run all tests in debug mode
2. Ctrl + R, Ctrl + T – Run all tests in context in debug mode
3. Ctrl + R, Ctrl + F – Run all checked tests in debug mode

Enjoy Testing