# Error viewing unit test results

**URL:** https://www.finalbuilder.com/forums/t/error-viewing-unit-test-results/6071
**Category:** Bugs
**Created:** [December 5, 2016, 5:51am UTC](https://www.finalbuilder.com/forums/t/error-viewing-unit-test-results/6071 "2016-12-05T05:51:43Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![bruce\_at\_ds](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/b/3be4f8/32.png) [@bruce\_at\_ds](https://www.finalbuilder.com/forums/u/bruce_at_ds)
#### Post date: [December 5, 2016, 5:51am UTC](https://www.finalbuilder.com/forums/t/error-viewing-unit-test-results/6071/1 "2016-12-05T05:51:43Z")

</div>

Continua v1.8.1.167, Windows 10  
  
When I click on the “Unit Tests” link to view the test results (see attached screen shot) I get the following error.  
  
An unexpected error occurred: could not execute query  
[select unittestas0\_.BuildId as BuildId80\_, unittestas0\_.AssemblyName as Assembly2\_80\_, unittestas0\_.Errors as Errors80\_, unittestas0\_.NotRun as NotRun80\_, unittestas0\_.Failed as Failed80\_, unittestas0\_.Fixed as Fixed80\_, unittestas0\_.NewFailures as NewFailu7\_80\_, unittestas0\_.Passed as Passed80\_, unittestas0\_.Shelved as Shelved80\_, unittestas0\_.Inconclusive as Inconcl10\_80\_, unittestas0\_.TestTime as TestTime80\_, unittestas0\_.Total as Total80\_ from builds\_unittestassemblysummary\_view unittestas0\_ where unittestas0\_.BuildId=@p0 order by unittestas0\_.TestTime desc, unittestas0\_.TestTime desc]  
Name:p1 - Value:66278  
[SQL: select unittestas0\_.BuildId as BuildId80\_, unittestas0\_.AssemblyName as Assembly2\_80\_, unittestas0\_.Errors as Errors80\_, unittestas0\_.NotRun as NotRun80\_, unittestas0\_.Failed as Failed80\_, unittestas0\_.Fixed as Fixed80\_, unittestas0\_.NewFailures as NewFailu7\_80\_, unittestas0\_.Passed as Passed80\_, unittestas0\_.Shelved as Shelved80\_, unittestas0\_.Inconclusive as Inconcl10\_80\_, unittestas0\_.TestTime as TestTime80\_, unittestas0\_.Total as Total80\_ from builds\_unittestassemblysummary\_view unittestas0\_ where unittestas0\_.BuildId=@p0 order by unittestas0\_.TestTime desc, unittestas0\_.TestTime desc]  
  
This happens across multiple build projects and configurations, for both NUnit and JUnit test result files.  
  
This used to work fine, but some time in the last few weeks it’s stopped working and been giving the above error.

![__38033__ 0__2016-12-05 14_46_33-Log - Continua.png](https://www.finalbuilder.com/forums/uploads/default/original/2X/d/da0608a24dc3a8365961daebd13d89f53ba65b8b.png)

---

<div class="post-metadata">

### Author: ![Sparky](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/sparky/32/10_2.png) [@Sparky](https://www.finalbuilder.com/forums/u/Sparky)
#### Post date: [December 5, 2016, 6:23am UTC](https://www.finalbuilder.com/forums/t/error-viewing-unit-test-results/6071/2 "2016-12-05T06:23:11Z")

</div>

Hi Bruce,  
  
I suspect that your database needs some maintenance. If you are using the bundled PostgreSQL database, you can connect to the database using %Program Files%\VSoft Technologies\ContinuaCI\Server\PostgreSQL\bin\pgAdmin3.exe.  
&nbsp;  
Use the connection details in %Program Files%\VSoft Technologies\ContinuaCI\Server\Continua.Server.Service.exe.config. You can find the connection string under \<hibernate-configuration\>\<session-factory\>\<property name=“connection.connection\_string”\>  
&nbsp;  
Choose a time when the server is not under heavy use, right click on the Continua database and select maintenance. Then select VACUUM and FULL and click OK. Also run a REINDEX using the same maintenance dialog. Let us know if any errors are reported.  
  
Also have a look at the size of the tables in that database. Open the database Schemas node in pgAdmin3.exe and select the Tables node uner the public schema. You can see the table sizes listed on the Statistics tab. The build\_unittest table is often large, but if is gets more than say a gigabyte, it would be worth looking into changing your cleanup policy settings.  
  
Another thing to look at is CPU, Memory and Disk usage on the server. If these are high, then the database may have difficultly responding to queries.

---

<div class="post-metadata">

### Author: ![bruce\_at\_ds](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/b/3be4f8/32.png) [@bruce\_at\_ds](https://www.finalbuilder.com/forums/u/bruce_at_ds)
#### Post date: [December 6, 2016, 10:37am UTC](https://www.finalbuilder.com/forums/t/error-viewing-unit-test-results/6071/3 "2016-12-06T10:37:28Z")

</div>

Hi Dave,  
  
Thanks for your reply.  
  
We are not using the bundled PostgreSQL database. Instead we are using MS SQL Server. We have just recently upgraded this from 2008 to 2016. I’m thinking this may be the issue. What are your thoughts?  
  
Thanks,  
Bruce Palmer

---

<div class="post-metadata">

### Author: ![Sparky](https://www.finalbuilder.com/forums/user_avatar/www.finalbuilder.com/sparky/32/10_2.png) [@Sparky](https://www.finalbuilder.com/forums/u/Sparky)
#### Post date: [December 7, 2016, 8:07am UTC](https://www.finalbuilder.com/forums/t/error-viewing-unit-test-results/6071/4 "2016-12-07T08:07:59Z")

</div>

Hi Bruce,  
  
Thank you for the additional information. We have now reproduced the issue. The next version (which we hope to release in the next couple of days) will include a fix.

---

<div class="post-metadata">

### Author: ![bruce\_at\_ds](https://www.finalbuilder.com/forums/letter_avatar_proxy/v4/letter/b/3be4f8/32.png) [@bruce\_at\_ds](https://www.finalbuilder.com/forums/u/bruce_at_ds)
#### Post date: [December 12, 2016, 5:59am UTC](https://www.finalbuilder.com/forums/t/error-viewing-unit-test-results/6071/5 "2016-12-12T05:59:18Z")

</div>

Hi Dave,   
  
 We installed the update today. Looks to be working fine.   
  
 Thank you.