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

Support - Assistance technique
1

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?

Cheers,

  • Jasper
3 Likes
2

You just saved me all the stress. Great Post.

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

Regards

1 Like