[Dhis2-devs] Error while creating a new user.
Hi all,
I am getting an error while creating a new user through web api(using 2.25
Build revision: edc697d)
Following is the error:
*attempted to assign id from null one-to-one property
[org.hisp.dhis.user.UserCredentials.userInfo]"*
Following is the payload i am referring to:
{
"firstName": "John",
"surname": "Doe",
"email": "john...@mail.com",
"userCredentials": {
"username": "johndoe",
"password": "your-password-123",
"userRoles": [ {
"id": "Euq3XfEIEbx"
} ]
},
"organisationUnits": [ {
"id": "ImspTQPwCqd"
} ],
"userGroups": [ {
"id": "vAvEltyXGbD"
} ]
}
Complete Logcat:
*org.hibernate.id.IdentifierGenerationException: attempted to assign id
from null one-to-one property [org.hisp.dhis.user.UserCredentials.userInfo]*
*at
org.hibernate.id.ForeignGenerator.generate(ForeignGenerator.java:83)*
*at
org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:105)*
*at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:192)*
*at
org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:38)*
*at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:177)*
*at
org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:32)*
*at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:73)*
*at
org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:682)*
*at org.hibernate.internal.SessionImpl.save(SessionImpl.java:674)*
*at org.hibernate.internal.SessionImpl.save(SessionImpl.java:669)*
*at
org.hisp.dhis.dxf2.metadata.objectbundle.hooks.UserObjectBundleHook.postCreate(UserObjectBundleHook.java:76)*
*at
org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.lambda$handleCreates$4(DefaultObjectBundleService.java:217)*
*at java.util.ArrayList.forEach(ArrayList.java:1249)*
*at
org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.handleCreates(DefaultObjectBundleService.java:217)*
*at
org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.commit(DefaultObjectBundleService.java:149)*
*at sun.reflect.GeneratedMethodAccessor1007.invoke(Unknown Source)*
*at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)*
*at java.lang.reflect.Method.invoke(Method.java:497)*
*at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)*
*at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)*
*at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)*
*at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)*
*at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)*
*at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)*
*at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)*
*at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)*
*at com.sun.proxy.$Proxy186.commit(Unknown Source)*
*at
org.hisp.dhis.dxf2.metadata.DefaultMetadataImportService.importMetadata(DefaultMetadataImportService.java:116)*
*at sun.reflect.GeneratedMethodAccessor935.invoke(Unknown Source)*
*at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)*
*at java.lang.reflect.Method.invoke(Method.java:497)*
*at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)*
*at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)*
*at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)*
*at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)*
*at
org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)*
*at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)*
*at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)*
*at
org.springframework.aop.fr
Re: [Dhis2-devs] Error while creating a new user.
Hi
Our user model is a bit weird at times (will try to fix for 226). As a
workaround you should be able to get this working if you use /api/system/id
to get a new uid, then add that to the main user model "id": "your-uid",
then inside the userCredentials you would put "userInfo": {"id": "your-id"
}
--
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org
On Thu, Dec 29, 2016 at 9:16 AM, Sourabh Bhardwaj
wrote:
> Hi all,
>
> I am getting an error while creating a new user through web api(using 2.25
> Build revision: edc697d)
>
> Following is the error:
>
> *attempted to assign id from null one-to-one property
> [org.hisp.dhis.user.UserCredentials.userInfo]"*
>
>
> Following is the payload i am referring to:
>
> {
> "firstName": "John",
> "surname": "Doe",
> "email": "john...@mail.com",
> "userCredentials": {
> "username": "johndoe",
> "password": "your-password-123",
> "userRoles": [ {
> "id": "Euq3XfEIEbx"
> } ]
> },
> "organisationUnits": [ {
> "id": "ImspTQPwCqd"
> } ],
> "userGroups": [ {
> "id": "vAvEltyXGbD"
> } ]
> }
>
> Complete Logcat:
>
> *org.hibernate.id .IdentifierGenerationException:
> attempted to assign id from null one-to-one property
> [org.hisp.dhis.user.UserCredentials.userInfo]*
> *at org.hibernate.id
> .ForeignGenerator.generate(ForeignGenerator.java:83)*
> *at
> org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:105)*
> *at
> org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:192)*
> *at
> org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:38)*
> *at
> org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:177)*
> *at
> org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:32)*
> *at
> org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:73)*
> *at
> org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:682)*
> *at org.hibernate.internal.SessionImpl.save(SessionImpl.java:674)*
> *at org.hibernate.internal.SessionImpl.save(SessionImpl.java:669)*
> *at
> org.hisp.dhis.dxf2.metadata.objectbundle.hooks.UserObjectBundleHook.postCreate(UserObjectBundleHook.java:76)*
> *at
> org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.lambda$handleCreates$4(DefaultObjectBundleService.java:217)*
> *at java.util.ArrayList.forEach(ArrayList.java:1249)*
> *at
> org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.handleCreates(DefaultObjectBundleService.java:217)*
> *at
> org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.commit(DefaultObjectBundleService.java:149)*
> *at sun.reflect.GeneratedMethodAccessor1007.invoke(Unknown Source)*
> *at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)*
> *at java.lang.reflect.Method.invoke(Method.java:497)*
> *at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)*
> *at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)*
> *at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)*
> *at
> org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)*
> *at
> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)*
> *at
> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)*
> *at
> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)*
> *at
> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)*
> *at com.sun.proxy.$Proxy186.commit(Unknown Source)*
> *at
> org.hisp.dhis.dxf2.metadata.DefaultMetadataImportService.importMetadata(DefaultMetadataImportService.java:116)*
> *at sun.reflect.GeneratedMethodAccessor935.invoke(Unknown Source)*
> *at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)*
> *at java.lang.reflect.Method.invoke(Method.java:497)*
> *at
> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)*
> *at
> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.
Re: [Dhis2-devs] Error while creating a new user.
Hi Morten,
Thanks for the reply. I have tried as per your suggestion and now getting
following error:
Internal server error: 500
Can not deserialize instance of java.lang.String out of START_ARRAY token↵
at [Source: org.apache.catalina.connector.CoyoteInputStream@3b6c6ca3; line:
1, column: 22] (through reference chain: org.hisp.dhis.user.User["id"])
On Thu, Dec 29, 2016 at 4:59 PM, Morten Olav Hansen
wrote:
> Hi
>
> Our user model is a bit weird at times (will try to fix for 226). As a
> workaround you should be able to get this working if you use /api/system/id
> to get a new uid, then add that to the main user model "id": "your-uid",
> then inside the userCredentials you would put "userInfo": {"id": "your-id"
> }
>
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
> On Thu, Dec 29, 2016 at 9:16 AM, Sourabh Bhardwaj
> wrote:
>
>> Hi all,
>>
>> I am getting an error while creating a new user through web api(using
>> 2.25 Build revision: edc697d)
>>
>> Following is the error:
>>
>> *attempted to assign id from null one-to-one property
>> [org.hisp.dhis.user.UserCredentials.userInfo]"*
>>
>>
>> Following is the payload i am referring to:
>>
>> {
>> "firstName": "John",
>> "surname": "Doe",
>> "email": "john...@mail.com",
>> "userCredentials": {
>> "username": "johndoe",
>> "password": "your-password-123",
>> "userRoles": [ {
>> "id": "Euq3XfEIEbx"
>> } ]
>> },
>> "organisationUnits": [ {
>> "id": "ImspTQPwCqd"
>> } ],
>> "userGroups": [ {
>> "id": "vAvEltyXGbD"
>> } ]
>> }
>>
>> Complete Logcat:
>>
>> *org.hibernate.id
>> .IdentifierGenerationException: attempted to
>> assign id from null one-to-one property
>> [org.hisp.dhis.user.UserCredentials.userInfo]*
>> *at org.hibernate.id
>> .ForeignGenerator.generate(ForeignGenerator.java:83)*
>> *at
>> org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:105)*
>> *at
>> org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:192)*
>> *at
>> org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:38)*
>> *at
>> org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:177)*
>> *at
>> org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:32)*
>> *at
>> org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:73)*
>> *at
>> org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:682)*
>> *at org.hibernate.internal.SessionImpl.save(SessionImpl.java:674)*
>> *at org.hibernate.internal.SessionImpl.save(SessionImpl.java:669)*
>> *at
>> org.hisp.dhis.dxf2.metadata.objectbundle.hooks.UserObjectBundleHook.postCreate(UserObjectBundleHook.java:76)*
>> *at
>> org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.lambda$handleCreates$4(DefaultObjectBundleService.java:217)*
>> *at java.util.ArrayList.forEach(ArrayList.java:1249)*
>> *at
>> org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.handleCreates(DefaultObjectBundleService.java:217)*
>> *at
>> org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.commit(DefaultObjectBundleService.java:149)*
>> *at sun.reflect.GeneratedMethodAccessor1007.invoke(Unknown
>> Source)*
>> *at
>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)*
>> *at java.lang.reflect.Method.invoke(Method.java:497)*
>> *at
>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)*
>> *at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)*
>> *at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)*
>> *at
>> org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)*
>> *at
>> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)*
>> *at
>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)*
>> *at
>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)*
>> *at
>> org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)*
>> *at com.sun.proxy.$Proxy186.commit(Unknown Source)*
>> *at org.hisp.dhis.dxf2.metadata.De
>>
Re: [Dhis2-devs] Error while creating a new user.
Hm that means something is wrong with your payload. Could you give the full
payload again?
--
Morten Olav Hansen
Senior Engineer, DHIS 2
University of Oslo
http://www.dhis2.org
On Thu, Dec 29, 2016 at 1:04 PM, Sourabh Bhardwaj
wrote:
> Hi Morten,
>
> Thanks for the reply. I have tried as per your suggestion and now getting
> following error:
>
> Internal server error: 500
> Can not deserialize instance of java.lang.String out of START_ARRAY token↵
> at [Source: org.apache.catalina.connector.CoyoteInputStream@3b6c6ca3;
> line: 1, column: 22] (through reference chain:
> org.hisp.dhis.user.User["id"])
>
> On Thu, Dec 29, 2016 at 4:59 PM, Morten Olav Hansen
> wrote:
>
>> Hi
>>
>> Our user model is a bit weird at times (will try to fix for 226). As a
>> workaround you should be able to get this working if you use /api/system/id
>> to get a new uid, then add that to the main user model "id": "your-uid",
>> then inside the userCredentials you would put "userInfo": {"id": "your-id"
>> }
>>
>> --
>> Morten Olav Hansen
>> Senior Engineer, DHIS 2
>> University of Oslo
>> http://www.dhis2.org
>>
>> On Thu, Dec 29, 2016 at 9:16 AM, Sourabh Bhardwaj
>> wrote:
>>
>>> Hi all,
>>>
>>> I am getting an error while creating a new user through web api(using
>>> 2.25 Build revision: edc697d)
>>>
>>> Following is the error:
>>>
>>> *attempted to assign id from null one-to-one property
>>> [org.hisp.dhis.user.UserCredentials.userInfo]"*
>>>
>>>
>>> Following is the payload i am referring to:
>>>
>>> {
>>> "firstName": "John",
>>> "surname": "Doe",
>>> "email": "john...@mail.com",
>>> "userCredentials": {
>>> "username": "johndoe",
>>> "password": "your-password-123",
>>> "userRoles": [ {
>>> "id": "Euq3XfEIEbx"
>>> } ]
>>> },
>>> "organisationUnits": [ {
>>> "id": "ImspTQPwCqd"
>>> } ],
>>> "userGroups": [ {
>>> "id": "vAvEltyXGbD"
>>> } ]
>>> }
>>>
>>> Complete Logcat:
>>>
>>> *org.hibernate.id
>>> .IdentifierGenerationException: attempted to
>>> assign id from null one-to-one property
>>> [org.hisp.dhis.user.UserCredentials.userInfo]*
>>> *at org.hibernate.id
>>> .ForeignGenerator.generate(ForeignGenerator.java:83)*
>>> *at
>>> org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:105)*
>>> *at
>>> org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:192)*
>>> *at
>>> org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:38)*
>>> *at
>>> org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:177)*
>>> *at
>>> org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:32)*
>>> *at
>>> org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:73)*
>>> *at
>>> org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:682)*
>>> *at
>>> org.hibernate.internal.SessionImpl.save(SessionImpl.java:674)*
>>> *at
>>> org.hibernate.internal.SessionImpl.save(SessionImpl.java:669)*
>>> *at
>>> org.hisp.dhis.dxf2.metadata.objectbundle.hooks.UserObjectBundleHook.postCreate(UserObjectBundleHook.java:76)*
>>> *at
>>> org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.lambda$handleCreates$4(DefaultObjectBundleService.java:217)*
>>> *at java.util.ArrayList.forEach(ArrayList.java:1249)*
>>> *at
>>> org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.handleCreates(DefaultObjectBundleService.java:217)*
>>> *at
>>> org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.commit(DefaultObjectBundleService.java:149)*
>>> *at sun.reflect.GeneratedMethodAccessor1007.invoke(Unknown
>>> Source)*
>>> *at
>>> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)*
>>> *at java.lang.reflect.Method.invoke(Method.java:497)*
>>> *at
>>> org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)*
>>> *at
>>> org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)*
>>> *at
>>> org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)*
>>> *at
>>> org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)*
>>> *at
>>> org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)*
>>> *at
>>> org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.
Re: [Dhis2-devs] Error while creating a new user.
I have recheck the payload again and now its working fine. Thanks for your
time.
On Thu, Dec 29, 2016 at 6:06 PM, Morten Olav Hansen
wrote:
> Hm that means something is wrong with your payload. Could you give the
> full payload again?
>
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
> On Thu, Dec 29, 2016 at 1:04 PM, Sourabh Bhardwaj
> wrote:
>
>> Hi Morten,
>>
>> Thanks for the reply. I have tried as per your suggestion and now getting
>> following error:
>>
>> Internal server error: 500
>> Can not deserialize instance of java.lang.String out of START_ARRAY
>> token↵ at [Source: org.apache.catalina.connector.
>> CoyoteInputStream@3b6c6ca3; line: 1, column: 22] (through reference
>> chain: org.hisp.dhis.user.User["id"])
>>
>> On Thu, Dec 29, 2016 at 4:59 PM, Morten Olav Hansen
>> wrote:
>>
>>> Hi
>>>
>>> Our user model is a bit weird at times (will try to fix for 226). As a
>>> workaround you should be able to get this working if you use /api/system/id
>>> to get a new uid, then add that to the main user model "id": "your-uid",
>>> then inside the userCredentials you would put "userInfo": {"id": "your-id"
>>> }
>>>
>>> --
>>> Morten Olav Hansen
>>> Senior Engineer, DHIS 2
>>> University of Oslo
>>> http://www.dhis2.org
>>>
>>> On Thu, Dec 29, 2016 at 9:16 AM, Sourabh Bhardwaj >> > wrote:
>>>
Hi all,
I am getting an error while creating a new user through web api(using
2.25 Build revision: edc697d)
Following is the error:
*attempted to assign id from null one-to-one property
[org.hisp.dhis.user.UserCredentials.userInfo]"*
Following is the payload i am referring to:
{
"firstName": "John",
"surname": "Doe",
"email": "john...@mail.com",
"userCredentials": {
"username": "johndoe",
"password": "your-password-123",
"userRoles": [ {
"id": "Euq3XfEIEbx"
} ]
},
"organisationUnits": [ {
"id": "ImspTQPwCqd"
} ],
"userGroups": [ {
"id": "vAvEltyXGbD"
} ]
}
Complete Logcat:
*org.hibernate.id
.IdentifierGenerationException: attempted to
assign id from null one-to-one property
[org.hisp.dhis.user.UserCredentials.userInfo]*
*at org.hibernate.id
.ForeignGenerator.generate(ForeignGenerator.java:83)*
*at
org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:105)*
*at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.saveWithGeneratedOrRequestedId(DefaultSaveOrUpdateEventListener.java:192)*
*at
org.hibernate.event.internal.DefaultSaveEventListener.saveWithGeneratedOrRequestedId(DefaultSaveEventListener.java:38)*
*at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.entityIsTransient(DefaultSaveOrUpdateEventListener.java:177)*
*at
org.hibernate.event.internal.DefaultSaveEventListener.performSaveOrUpdate(DefaultSaveEventListener.java:32)*
*at
org.hibernate.event.internal.DefaultSaveOrUpdateEventListener.onSaveOrUpdate(DefaultSaveOrUpdateEventListener.java:73)*
*at
org.hibernate.internal.SessionImpl.fireSave(SessionImpl.java:682)*
*at
org.hibernate.internal.SessionImpl.save(SessionImpl.java:674)*
*at
org.hibernate.internal.SessionImpl.save(SessionImpl.java:669)*
*at
org.hisp.dhis.dxf2.metadata.objectbundle.hooks.UserObjectBundleHook.postCreate(UserObjectBundleHook.java:76)*
*at
org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.lambda$handleCreates$4(DefaultObjectBundleService.java:217)*
*at java.util.ArrayList.forEach(ArrayList.java:1249)*
*at
org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.handleCreates(DefaultObjectBundleService.java:217)*
*at
org.hisp.dhis.dxf2.metadata.objectbundle.DefaultObjectBundleService.commit(DefaultObjectBundleService.java:149)*
*at sun.reflect.GeneratedMethodAccessor1007.invoke(Unknown
Source)*
*at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)*
*at java.lang.reflect.Method.invoke(Method.java:497)*
*at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)*
*at
org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)*
*at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)*
*at
org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.j
[Dhis2-devs] DHIS2 Live - problems generating resource tables
Hi team, We are encountering problems generating resource tables and analytics tables using the DHIS2 Live version downloadable at: https://www.dhis2.org/download/live/dhis2-live.zip Here is the errors that we see in the DHIS2 app: 2016-12-29 13:48:52 Process failed: StatementCallback; bad SQL grammar [create table orgunitstructure_temp (organisationunitid integer not null primary key, organisationunituid character(11), level integer, "idlevel1" integer, "uidlevel1" character(11), "idlevel2" integer, "uidlevel2" character(11), "idlevel3" integer, "uidlevel3" character(11), "idlevel4" integer, "uidlevel4" character(11));]; nested exception is org.h2.jdbc.JdbcSQLException: Table "_ORGUNITSTRUCTURE_TEMP" already exists; SQL statement: create table orgunitstructure_temp (organisationunitid integer not null primary key, organisationunituid character(11), level integer, "idlevel1" integer, "uidlevel1" character(11), "idlevel2" integer, "uidlevel2" character(11), "idlevel3" integer, "uidlevel3" character(11), "idlevel4" integer, "uidlevel4" character(11)); [42101-191] 2016-12-29 13:48:52 Generating resource tables To recreate the problem simply download and run the DHIS2 Live application and run resource tables twice. The first time is successful but subsequent attempts fail. There seems to be an issue with clearing up temp tables like *orgunitstructure_temp*. Is it possible that the DHIS2 Live version is out of date? Thanks, -doh ___ 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
