← Back to team overview

dhis2-devs team mailing list archive

Re: 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> 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 <992%2039%20817>
>
> Skype: nrc_troyel
> www.nrc.no
>
> [image: nrclogo] <http://www.nrc.no/>
>
>
>
>
>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : 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
http://www.dhis2.org <https://www.dhis2.org/>

JPEG image


Follow ups

References