# Error when updating from 1.5.1.93 to 1.6.0.42 Beta
**URL:** https://www.finalbuilder.com/forums/t/error-when-updating-from-1-5-1-93-to-1-6-0-42-beta/5312
**Category:** Discussion
**Created:** [February 16, 2015, 9:31am UTC](https://www.finalbuilder.com/forums/t/error-when-updating-from-1-5-1-93-to-1-6-0-42-beta/5312 "2015-02-16T09:31:00Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@chillefeld](https://www.finalbuilder.com/forums/u/chillefeld)
#### Post date: [February 16, 2015, 9:31am UTC](https://www.finalbuilder.com/forums/t/error-when-updating-from-1-5-1-93-to-1-6-0-42-beta/5312/1 "2015-02-16T09:31:00Z")
Hi,
I wanted to test Continua 1.6 beta and updated an existing test system to the latest build. However after updating we get the following error from Continua:
- Ensure that the Continua Server service is running
- Check the Event Log for any application errors for Continua
- 9:13 AM : Starting
- 9:13 AM : Starting
- 9:13 AM : Migrating Database
- 9:13 AM : Could not initialise database: An error occurred executing the following sql: INSERT INTO builds\_repositorybranch (path, displayname, repositoryid, lastcommitdate, lastbuilddate, isdeletedorclosed, isactive) SELECT DISTINCT branch, branchdisplayname, repositoryid, MAX(lastcommitdate), MAX(created), false, true FROM ( SELECT DISTINCT branch, branchdisplayname, repositoryid, MAX(c.created) AS lastcommitdate, b.created FROM builds\_changeset c LEFT JOIN builds\_buildchangeset bc ON c.id = bc.changesetid LEFT JOIN builds\_build b ON b.id = bc.buildid GROUP BY branch, branchdisplayname, repositoryid, b.created ) AS t1 GROUP BY branch, branchdisplayname, repositoryid; The error was FEHLER: 23502: NULL-Wert in Spalte „id“ verletzt Not-Null-Constraint Check the eventlog for more info.
The full Event Log entry for PostgreSQL shows the above error again.
Before the attempted update there were two git repository registered with Continua. Both only contained a small number of test commits.
---
### Author:  [@chillefeld](https://www.finalbuilder.com/forums/u/chillefeld)
#### Post date: [February 16, 2015, 9:33am UTC](https://www.finalbuilder.com/forums/t/error-when-updating-from-1-5-1-93-to-1-6-0-42-beta/5312/2 "2015-02-16T09:33:16Z")
Both repositories also only had one master branch and no others.
---
### Author:  [@Sparky](https://www.finalbuilder.com/forums/u/Sparky)
#### Post date: [February 16, 2015, 1:29am UTC](https://www.finalbuilder.com/forums/t/error-when-updating-from-1-5-1-93-to-1-6-0-42-beta/5312/3 "2015-02-16T01:29:15Z")
Hi,
Thanks for reporting this. I suspect that there is a changeset in your database with a null branch display name. Can you confirm this by running the following query against the ContinuaCI database?
`SELECT` `* ``FROM` `builds_changeset ``WHERE` `branch ``IS` `NULL` `OR` `branchdisplayname ``IS` `NULL` `OR` `repositoryid ``IS` `NULL`
You can access the database using pgAdmin3.exe (in C:\Program Files\VSoft Technologies\ContinuaCI\Server\PostgreSQL\bin). The database connection details are in C:\Program Files\VSoft Technologies\ContinuaCI\Server\Continua.Server.Service.exe.config under hibernate-configuration\session-factory\property name=“connection.connection\_string”.
If you can let me know which field is null, I’ll get a fix out to you first thing.
---
### Author:  [@chillefeld](https://www.finalbuilder.com/forums/u/chillefeld)
#### Post date: [February 16, 2015, 3:37am UTC](https://www.finalbuilder.com/forums/t/error-when-updating-from-1-5-1-93-to-1-6-0-42-beta/5312/4 "2015-02-16T03:37:15Z")
Hi Dave,
I ran the query as requested and it did not return any results.
Running the select portion of the failed insert that Continua reports gives the following results:
“master”;“master”;“bc83157e-34e7-4905-9ad1-23770471c749”;“2015-02-03 07:39:06”;“2015-02-03 12:54:51.64479”;f;t
“master”;“master”;“085d0792-26d8-44d7-9252-381dad38ec15”;“2015-01-28 14:19:17”;“2015-01-30 10:27:31.020337”;f;t
Is there any other information I can give you to help fix this?
---
### Author:  [@lcoursey](https://www.finalbuilder.com/forums/u/lcoursey)
#### Post date: [February 16, 2015, 4:38am UTC](https://www.finalbuilder.com/forums/t/error-when-updating-from-1-5-1-93-to-1-6-0-42-beta/5312/5 "2015-02-16T04:38:32Z")
I’m getting the same error with one TFS 2013 repository with a single master branch.
---
### Author:  [@lcoursey](https://www.finalbuilder.com/forums/u/lcoursey)
#### Post date: [February 16, 2015, 4:45am UTC](https://www.finalbuilder.com/forums/t/error-when-updating-from-1-5-1-93-to-1-6-0-42-beta/5312/6 "2015-02-16T04:45:59Z")
> SELECT \* FROM builds\_changeset
> WHERE branch IS NULL OR branchdisplayname IS NULL OR repositoryid IS NULL
This also returned no results for me
---
### Author:  [@Sparky](https://www.finalbuilder.com/forums/u/Sparky)
#### Post date: [February 17, 2015, 12:54pm UTC](https://www.finalbuilder.com/forums/t/error-when-updating-from-1-5-1-93-to-1-6-0-42-beta/5312/7 "2015-02-17T12:54:28Z")
Hi,
Apologies for this. A late change to the primary key of a database table caused this migraton bug. We have uploaded a new [version v1.6.0.43](https://www.finalbuilder.com/downloads/continuaci/continuaci-version-history-v1.6) with a fix for this issue.
---
### Author:  [@chillefeld](https://www.finalbuilder.com/forums/u/chillefeld)
#### Post date: [February 17, 2015, 7:39am UTC](https://www.finalbuilder.com/forums/t/error-when-updating-from-1-5-1-93-to-1-6-0-42-beta/5312/8 "2015-02-17T07:39:20Z")
With 1.6.0.43 the update worked. Thanks for the quick fix.