Those columns were added from 2.30 only. Did you upgrade your DB to 2.30 before ?
On Mon, Oct 15, 2018 at 1:02 PM DHIS2 Support <drdavidank...@gmail.com> wrote: > Version: 2.29Build revision: 88696a1 > thanks Viet > On Mon, Oct 15, 2018 at 6:58 AM Viet Nguyen <v...@dhis2.org> wrote: > >> Hi, which version are you on ? >> >> On Mon, Oct 15, 2018 at 4:02 AM DHIS2 Support <drdavidank...@gmail.com> >> wrote: >> >>> Dear all, >>> >>> I am unable to create new users. My troubleshooting shows that when I >>> submit a new user request on the web page, a database >>> ConstraintViolationException is generated as secret is null. secret and >>> twofa columns are expected to be non-null. Please see an error extract >>> below and a table showing two attempts. >>> >>> What could be causing secret and twofa to be null? I have over 100 users >>> successfully created before the issue started. thanks. >>> >>> Error: >>> * ERROR 2018-10-14 21:55:17,350 ERROR: null value in column "secret" >>> violates not-null constraint >>> [org.hibernate.exception.ConstraintViolationException: could not execute >>> statement] (ExceptionMapperStandardImpl.java >>> [http-bio-127.0.0.1-8080-exec-90]) >>> statement; SQL [n/a]; constraint [secret]; nested exception is >>> org.hibernate.exception.ConstrintViolationException: could not execute >>> statement >>> >>> _______________________________________________ >>> Mailing list: https://launchpad.net/~dhis2-devs >>> Post to : dhis2-devs@lists.launchpad.net >>> Unsubscribe : https://launchpad.net/~dhis2-devs >>> More help : https://help.launchpad.net/ListHelp >>> >> >> >> -- >> >> Viet Nguyen >> Software Developer, DHIS 2 >> University of Oslo >> http://www.dhis2.org >> >> >> -- Viet Nguyen Software Developer, DHIS 2 University of Oslo http://www.dhis2.org
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp