问题描述
VS 2012
具有负载测试结果的Excel 2013，加载项设置为始终加载
Excel 2013 with the Load Test Results, the Add-in set to always loaded
SQL Server数据库结果存储库
SQL Server Database Results Repository
所有系统通讯正常，否则不会出错
All systems in communication without error otherwise
DBA检查了流量，找不到任何权限问题阻止了对proc的访问
DBA checked the traffic and can't find any permissions issue blocking the access to the proc
该过程存在于我们的数据库中
The proc exists in our database
1.我在Visual Studio上打开了一组负载测试结果.
1. I open a set of Load Test Results on Visual Studio.
2.我单击两个X图标的左侧以生成负载测试报告.见下文.
2. I click the left of two X icons for generating a load test report. See below.
3.我收到以下错误.见下文
3. I get the following error. See below
4.当我直接从Excel执行此操作时，我会看到对话框，并可以生成报告
4. When I do this directly from Excel I get the dialog and I can generate the report
Botendaddy
Botendaddy
推荐答案
根据错误消息，我认为问题的原因可能是卸载的插件.我建议您可以手动删除加载项中的加载报告加载项"，然后通过Excel重新添加 检查结果.
Based on the error message, I feel that the cause of the issue may be the unloaded addin. I suggest that you can delete the "Load Report Addin" in Add-Ins manually then adding again through Excel to check the result.
基于错误消息:找不到存储过程'prc_QueryLoadTestReports'，我不确定 存储过程'prc_QueryLoadTestReports'是否为在负载测试结果数据库中，但是您可以检查它.
Based on the error message:could not find stored procedure ‘prc_QueryLoadTestReports’,i am not sure whether the stored procedure ‘prc_QueryLoadTestReports’ is in load test result database, but you can check it.
此外，我认为您遇到了这个问题，可能是因为Excel2013版本与VS2012不兼容.我建议您可以尝试使用VS2013重新创建负载测试Excel报表 如果您有一台装有VS2013的计算机.而且，如果您有一台装有VS2012的计算机，还可以进行负载测试，然后从该计算机生成报告，以检查VS2012是否存在任何问题.
In addition, I assume that you got this issue maybe because the Excel2013 version is not compatible with VS2012. I suggest that you can try to use the VS2013 to recreate Load Test Excel Report if you have another machine with VS2013. And if you have another machine with VS2012, you also can do load test and then generate report from that machine to check whether there is anything wrong with your VS2012.
最好的问候
这篇关于无法从Visual Studio生成Excel负载测试报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！