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

Support - Assistance technique
1

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

image

2

Hi, which version are you on ?

···

Viet Nguyen

Software Developer, DHIS 2

University of Oslo

http://www.dhis2.org

3

Version: 2.29
Build revision: 88696a1

thanks Viet

···

On Mon, Oct 15, 2018 at 6:58 AM Viet Nguyen viet@dhis2.org wrote:

Hi, which version are you on ?

On Mon, Oct 15, 2018 at 4:02 AM DHIS2 Support drdavidankrah@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

4

Those columns were added from 2.30 only. Did you upgrade your DB to 2.30 before ?

···

Viet Nguyen

Software Developer, DHIS 2

University of Oslo

http://www.dhis2.org