Bamboo startup or backup fails when the skipped test count has a null value

Still need help?

The Atlassian Community is here for you.

Ask the community

Problem

Bamboo fails to start or backup fails. The following appears in the log files:

Caused by: org.springframework.orm.hibernate3.HibernateSystemException: Null value was assigned to a property of primitive type setter of com.atlassian.bamboo.resultsummary.tests.TestResultsSummaryImpl.skippedTestCaseCount; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of com.atlassian.bamboo.resultsummary.tests.TestResultsSummaryImpl.skippedTestCaseCount

Diagnosis/Cause

The root cause of this issue is that the BUILDRESULTSUMMARY  table has a column skipped_test_count which can only accept an integer value. Now if you have some builds with the result summary saved with a null value for that column, then bamboo complains and fails with the error above. You can check this by running the below command:

select * from BUILDRESULTSUMMARY where skipped_test_count is null;

Resolution

  1. Shutdown Bamboo, 
  2. Backup the Bamboo database
  3. Run the query below and restart Bamboo
update BUILDRESULTSUMMARY set skipped_test_count=0 where skipped_test_count is null;
Last modified on May 9, 2017

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.