← Back to team overview

dhis2-devs team mailing list archive

Re: Unable to create new users as secret and twofa columns are null

 

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 <drdavidankrah@xxxxxxxxx>
wrote:

> Version: 2.29Build revision: 88696a1
> thanks Viet
> On Mon, Oct 15, 2018 at 6:58 AM Viet Nguyen <viet@xxxxxxxxx> wrote:
>
>> Hi, which version are you on ?
>>
>> On Mon, Oct 15, 2018 at 4:02 AM DHIS2 Support <drdavidankrah@xxxxxxxxx>
>> 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@xxxxxxxxxxxxxxxxxxx
>>> 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

References