Bamboo startup or backup fails when the skipped test count has a null value
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
- Shutdown Bamboo,
- Backup the Bamboo database
- 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
Powered by Confluence and Scroll Viewport.