dhis2-devs team mailing list archive

Thread
Date

Create New User error: An exception occurred

To: dhis2-devs@xxxxxxxxxxxxxxxxxxx
From: DHIS2 Support <drdavidankrah@xxxxxxxxx>
Date: Thu, 11 Oct 2018 00:36:09 +0100
In-reply-to: <CAMNfhdVXL7K4z-sfgxj2zZGRykLY4m-RDz_B=R5VSbpqd6-pfA@mail.gmail.com>

Dear all,

When I attempt to create a new user, I receive the error:

An exception occurred
Sorry! The system failed to execute the operation. Usually, no data is lost
and you can continue working by going back to the previous page.

The log contains this:

p.org.springframework.dao.DataIntegrityViolationException: could not
execute statement; SQL [n/a]; constraint [secret]; nested exception is
org.hibernate.exception.ConstraintViolationException: could not execute
statement
        at
org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:241)

Caused by: org.hibernate.exception.ConstraintViolationException: could not
execute statement
        at
org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112)
        at
org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)


Caused by: org.postgresql.util.PSQLException: ERROR: null value in column
"secret" violates not-null constraint
  Detail: Failing row contains (614731, ZszWxT3M8UX, null, 2018-10-10
19:17:47.078, 2018-10-10 19:17:47.487, 50, 50, xdfdgrtrthff001,
$2a$10$Ynj1r3231cJFy6QeNSUpNu8u0CiCFLFc6W3cIl3Qw8Qr6/FZrl8wa, f, null,
null, 2018-10-10 19:17:47.078, null, null, null, null, f, f, f, null, null).

Kindly assist with a solution, thanks.

Dr David