{"id":1083,"date":"2014-06-06T11:16:47","date_gmt":"2014-06-06T11:16:47","guid":{"rendered":"https:\/\/blogs.msdn.microsoft.com\/visualstudioalm\/2014\/06\/06\/error-importing-the-result-file-after-a-load-test-run\/"},"modified":"2022-07-15T00:09:17","modified_gmt":"2022-07-15T08:09:17","slug":"error-importing-the-result-file-after-a-load-test-run","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/devops\/error-importing-the-result-file-after-a-load-test-run\/","title":{"rendered":"Error importing the result file after a load test run"},"content":{"rendered":"<p>Been working with the fine folks at the Game Studios labs and they just recently ran to the following error when they finish a load test run:<\/p>\n<blockquote>\n<p><strong><font color=\"#800080\" size=\"4\">\u201cThere was an error importing the result file after a load test run.\u201d<\/font><\/strong><\/p>\n<p>\u00a0<\/p>\n<\/blockquote>\n<p><img decoding=\"async\" title=\"clip_image002\" style=\"border-top: 0px;border-right: 0px;border-bottom: 0px;border-left: 0px\" border=\"0\" alt=\"clip_image002\" src=\"https:\/\/devblogs.microsoft.com\/devops\/wp-content\/uploads\/sites\/6\/2014\/06\/4848.clip_image002_thumb_69355555.jpg\" width=\"646\" height=\"400\" \/><\/p>\n<p>\u00a0<\/p>\n<p>The cause in their case was their Load Test repository had filled up.\u00a0 In Visual Studio 2013 we started automatically creating and connecting to a local SQL Express interest for load run data.<\/p>\n<p>By default this is located at:<\/p>\n<blockquote>\n<p>Data Source=aidemo008sqlexpress;Initial Catalog=LoadTest2010;Integrated Security=True<\/p>\n<p>C:Program FilesMicrosoft SQL ServerMSSQL11.SQLEXPRESSMSSQLDATALoadTest2010.mdf<\/p>\n<\/blockquote>\n<p>\u00a0<\/p>\n<p>Which is GREAT for getting started as it is one less thing to setup BUT since you weren\u2019t told there was a SQL Database created for you, when it fills up it can come as a bit of a surprise.<\/p>\n<p>Depending upon the version of SQL Express, this can be 4gb or 10 gb.<\/p>\n<p><a href=\"http:\/\/blogs.msdn.com\/b\/sqlexpress\/archive\/2010\/04\/21\/database-size-limit-increased-to-10gb-in-sql-server-2008-r2-express.aspx\">http:\/\/blogs.msdn.com\/b\/sqlexpress\/archive\/2010\/04\/21\/database-size-limit-increased-to-10gb-in-sql-server-2008-r2-express.aspx<\/a><\/p>\n<p>Luckily it is easy to fix by simply running the command: <strong>loadtestresultsrepository.sql<\/strong>.<\/p>\n<p>(see <a href=\"http:\/\/blogs.msdn.com\/b\/visualstudioalm\/archive\/2012\/06\/04\/getting-started-with-load-testing-in-visual-studio-2012.aspx\">Getting Started with Load Testing in Visual Studio 2012<\/a> or <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms182600.aspx\">How to: Create a Load Test Results Repository Using SQL<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Been working with the fine folks at the Game Studios labs and they just recently ran to the following error when they finish a load test run: \u201cThere was an error importing the result file after a load test run.\u201d \u00a0 \u00a0 The cause in their case was their Load Test repository had filled up.\u00a0 [&hellip;]<\/p>\n","protected":false},"author":63,"featured_media":45953,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1,252],"tags":[],"class_list":["post-1083","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-devops","category-testing"],"acf":[],"blog_post_summary":"<p>Been working with the fine folks at the Game Studios labs and they just recently ran to the following error when they finish a load test run: \u201cThere was an error importing the result file after a load test run.\u201d \u00a0 \u00a0 The cause in their case was their Load Test repository had filled up.\u00a0 [&hellip;]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/1083","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/users\/63"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/comments?post=1083"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/posts\/1083\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media\/45953"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/media?parent=1083"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/categories?post=1083"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/devops\/wp-json\/wp\/v2\/tags?post=1083"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}