Re: [Dhis2-users] Getting exception when opening Tracker Capture

postgres=# \c dhis2 You are now connected to database dhis2 as user postgres. dhis2=# select * from version; versionid |versionkey| versionvalue ---+--+-- 69 | organisationUnit |

Re: [Dhis2-users] Getting exception when opening Tracker Capture

Thanks Lars, I did remove both, truncate table, and created a root Oorganization Unit, also fixed the problem. Once this is to create a docker image that users can use for demo/testing I will update the image with the new build. Regards, /Paulo On 26 April 2015 at 21:36, Lars Helge Øverland

Re: [Dhis2-users] Getting exception when opening Tracker Capture

Thanks Paulo, that sounds cool. Lars On Sun, Apr 26, 2015 at 11:04 PM, Paulo Grácio paulogra...@gmail.com wrote: Thanks Lars, I did remove both, truncate table, and created a root Oorganization Unit, also fixed the problem. Once this is to create a docker image that users can use for

Re: [Dhis2-users] Getting exception when opening Tracker Capture

Hi Paulo, I suggest that you first clean it so that you have only unique versionkey values, then run these SQL statement to ensure that this problem does not come back: ALTER TABLE version ALTER COLUMN versionkey SET NOT NULL; ALTER TABLE version ADD CONSTRAINT version_versionkey_key