Monday, April 18, 2011

VS 2010 - Create Load Test Repository

One day I found that my Load Test Reporsitory is missing and hence I was not able to run the load tests.
The load tests were failing with the error:
---------------------------
Microsoft Visual Studio
---------------------------
Error occurred running test. The load test results database could not be opened.  Check that the load test results database specified by the connect string for your test controller (or local machine) specifies a database that contains the load test schema and that is currently available.  For more information, see the Visual Studio help topic 'About the Load Test Results Store'.   The connection error was: An error occurred while attempting to create the load test results repository schema: Cannot find the object 'LoadTestTestCaseSummary', because it does not exist or you do not have permission.
---------------------------
OK  
---------------------------

To resolve this issue, I followed the below steps:
1) Open VS command prompt in elevated mode (Run As Administrator)
2) Run the command "cd C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE"
3) Run the command "SQLCMD /S localhost\sqlexpress /i loadtestresultsrepository.sql "

4 comments:

  1. Sqlcmd: 'loadtestresultsrepository.sql': Invalid filename.

    ReplyDelete
  2. See if you have any spaces in the path or the file actually exists http://stackoverflow.com/questions/4726394/sqlcmd-script-with-spaces-in-filename

    ReplyDelete
  3. Thanks for the instructions. However this does not work if you don't have a loadtestresultsrepository.sql file present. What are the steps for creating that?

    ReplyDelete
  4. The sql file should come with visual studio installation which has support for load tests

    ReplyDelete