LoadTestTestDetail is empty in any way

Question

I run LoadTest and get all correct results except of the empty table LoadTestTestDetail. I have checked the AllIndividualDetails property etc. without results. My load test now is anly about 5 minuts. All dates are small enought.

Help please, Any ideas!

Answer 1

Hi DimonSmart,

Thank you for posting in the MSDN forum.

Would you mind letting us know more information about this issue? Which result in the load test you are checking? Could you share us a screen shot about it?

Do you mean that Test Details is empty in the Table drop-down list box, select “Test Details” in the load test result?

If so, whether other load tests have the same issue, for example, create a simple new web test, then add it to the load test, run and check it.

In addition, we would make sure the load test result is “Completed” in Test Results window.

Best Regards,

---

Jack Zhai [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Hi. I'm about SQL database and table LoadTestTestDetail. All other tables are filled ok but this is empty. I'm trying to discovery this and found a problem here:

(QTAgent32.exe, PID 5992, Thread 27) Unexpected exception in internal method 'SendItemResults':
Exception: File 'C:\Tests\LoadTestItemResults.dat' not found.

Actually this file created successfully, but it placed in different location:
"C:\Documents and Settings\SVC_TestAgent\Local Settings\VSEQT\QTAgent\6f65125c-a82d-4197-b47e-6a3b2c60df3a\DOROGOY-TEST\Deployment\"

As far as I understand the problem is about this file location.

More details about my test. My test contain lot's of small tests (actually unit tests) placed in loadtest file with sequental order execution. I want to extract performance counters for each line (each unit test) accordingly. The only way i found for doing this - is the sql table LoadTestTestDetail. This table give me possibility to correspond unit test to my performance counter.

Also. If I put the file LoadTestItemResults.dat during the test to c:\tests\ folder manually the data transferred to sql table correctly.

Answer 3

Hi DimonSmart,

Glad to receive your reply.

Do you mean that the table LoadTestTestDetail in your SQL database LoadTest2010 is empty?

Also. If I put the file LoadTestItemResults.dat during the test to c:\tests\ folder manually the data transferred to sql table correctly.

Just to make this issue clearly, if you put the file to the correct file location, whether the table isn’t empty? If it works well, I will make your reply as the answer.

If not, it seems that you using the deployment item in your unit test, if you create a simple unit test like this, add it to the load test, whether the table LoadTestTestDetail is empty? We would check that whether the load test result is “Completed” in Test Result window, Test->Manage Test Controller, select the correct load test result store.

Best Regards,

---

Jack Zhai [MSFT]
MSDN Community Support | Feedback to us

Answer 4

Let's make this issue clear. The problem look like this.

1. I start runing load test throught MTM.

2. It created loadTestItemResults.dat into default folder under C:\Documents and Settings\ .... bla bla

3. In test settings I set the TestDirectory to local folder c:\test (Settings in xaml template parameters for Microsoft.TeamFoundation.Lab.WorkFlow.Activities.ExecuteRemoteTestRun)

4. Test run completed

5. Test run engine trying to find file loadTestItemResults.dat in TestDirectory (but previously create it in different directory)

6. FAIL Exception: File 'C:\Tests\LoadTestItemResults.dat' not found

RESUME. Test engine have to load and create file in the same place. But create in one place and load from another.

Answer 5

Hi DimonSmart,

I start runing load test throught MTM.

Do you mean that you are using the Microsoft Test Manager tool like this forum?

If so, I’m not the MTM expert, but it seems that when we run the Automated Tests with MTM, we would select the Test Controller in the Environment set of the Lab Center, when we configure the Test Controller, we would create load test result database in the specific SQL Server instance, I doubt that you check the local database, it is not the database in the Test Controller.

Since I’m not the MTM expert, I’m afraid that I couldn’t repro this issue, my suggestion it that you could run your load test in the VS (Test->Test View), as my previous reply, you need to check the Manage Test Controller, select the correct load test result store and Test Controller like the following screen shot. If you just want to check your local database, you could select the Controller “<Local-No controller>”.  

Best Regards,

---

Jack Zhai [MSFT]
MSDN Community Support | Feedback to us

Answer 6

Hi DimonSmart,

I mark the answer, please check it. If you need further assistance, please feel free to let us know.

Best Regards,

---

Jack Zhai [MSFT]
MSDN Community Support | Feedback to us

Answer 7

Hi. The problem reproduced when I run LoadTests through the "queue hew build" with the custom template. The problem with wrong file location exists, as I described (Test engine starts writing file to one location but then trying to read from another). So could You redirect this problem to appropriate location.

p.s. I can give more details and assist with problem investigation and solving.

Answer 8

Hi DimonSmart,

Sorry for my reply no help.

As my suggestion, if possible, you could try to create a load test in the VS without the MTM and check it.

About this issue, since you are using the MTM tool, I’m afraid that I don’t have any good idea. To help you resolve this issue, if possible, you could post this issue in Testing with Visual Studio Test Manager (MTM) forum for dedicated support. If so, in your new thread, I suggest you post the detailed step about how you create and run the load test in the MTM. I think it will be useful for the MTM expert to resolve this issue quickly. Thanks for your understanding.

In addition, if you could post it in the MTM forum, would you mind changing this issue to “General Discussion”? Maybe other community members have some solutions when they see this thread. Thanks for your understanding again.J

Sincerely,

---

Jack Zhai [MSFT]
MSDN Community Support | Feedback to us