500 error on api/users

Support - Assistance technique
1

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

image

···

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

Skype: nrc_troyel

www.nrc.no

2

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

​

image

···

On Thu, May 4, 2017 at 10:04 AM, Trøyel Nerbø troyel.nerbo@nrc.no 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

Skype: nrc_troyel

www.nrc.no

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

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@dhis2.org

http://www.dhis2.org

3

Hi Lars,

Thanks a lot for the quick feedback and fix!

Best,

Trøyel

image

···

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@nrc.no 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

Skype: nrc_troyel

www.nrc.no

Mailing list: https://launchpad.net/~dhis2-devs

Post to : dhis2-devs@lists.launchpad.net

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@dhis2.org

http://www.dhis2.org