Issue with NULL twofa column in users table after upgrade to 2.30

Hi folks,

Was just upgrading our test instance from 2.29 to 2.30 and faced an issue when the server was coming up per the following:
org.springframework.beans.factory.BeanCreationException: Error creating bean with name ‘org.hisp.dhis.sms.incoming.SmsConsumerService’: Invocation of init method failed; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of org.hisp.dhis.user.UserCredentials.twoFA

It looks like the twofa column in the users table was all NULL and it had an issue with this, so I set them all to FALSE which seems to be fine now.

Has anyone else faced this problem? Should it perhaps be added to the upgrade SQL script if so?


  • Jasper

You just saved me all the stress. Great Post.

I did the same using this psql command
UPDATE users SET twofa = FALSE;


1 Like