← Back to team overview

dhis2-devs team mailing list archive

Re: 500 error on api/users

 

Hi Lars,
Thanks a lot for the quick feedback and fix!

Best,
Trøyel

From: Lars Helge Øverland [mailto:lars@xxxxxxxxx]
Sent: torsdag 4. mai 2017 18.07
To: Trøyel Nerbø <troyel.nerbo@xxxxxx>
Cc: DHIS 2 Developers List <dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Subject: Re: [Dhis2-devs] 500 error on api/users


Hi Trøyel,

not sure exactly what happened but seems like a problem with the db upgrade. Try to run this SQL for a immediate fix:

update users set externalauth = false where externalauth is null;

regards,

Lars
​

On Thu, May 4, 2017 at 10:04 AM, Trøyel Nerbø <troyel.nerbo@xxxxxx<mailto:troyel.nerbo@xxxxxx>> wrote:
Dear all,

Today when I try to open /api/users.json?paging=false I get a 500 error of the type:
TTP Status 500 - Request processing failed; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of org.hisp.dhis.user.UserCredentials.externalAuth
________________________________
type Exception report
message Request processing failed; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of org.hisp.dhis.user.UserCredentials.externalAuth
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.hibernate.PropertyAccessException: Null value was assigned to a property of primitive type setter of org.hisp.dhis.user.UserCredentials.externalAuth


Any ideas what this can be caused by? Running 2.23.

Thanks!


Best Regards
Halvar Trøyel Nerbø
Reporting Advisor
+47 992 39 817<tel:992%2039%20817>
Skype: nrc_troyel
www.nrc.no<http://www.nrc.no/>
[nrclogo]<http://www.nrc.no/>




_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx<mailto:dhis2-devs@xxxxxxxxxxxxxxxxxxx>
Unsubscribe : https://launchpad.net/~dhis2-devs
More help   : https://help.launchpad.net/ListHelp



--
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
lars@xxxxxxxxx<mailto:lars@xxxxxxxxx>
http://www.dhis2.org<https://www.dhis2.org/>

JPEG image


References