date:20181014

Re: [Dhis2-devs] Problem creating a data export in 2.30

2018-10-14 Thread Morten Olav Hansen

Please remember that on the play servers, the admin user is not actually a
superuser (it does not have ALL). So normal sharing rules applies.

-- 
Morten Olav Hansen
Senior Engineer, DHIS 2
Team Integration Lead
University of Oslo
http://www.dhis2.org


On Fri, Oct 12, 2018 at 12:58 AM Viet Nguyen  wrote:

> Hi Elmarie,
>
> Yes, the export data value function is also controlled by sharing
> settings.
>
>
>
> On Thu, Oct 11, 2018 at 9:12 PM Elmarie Claasen  wrote:
>
>> Hi Viet,
>>
>>
>>
>> I think we may be onto what is causing the issue. Is the exporting of
>> data also controlled by sharing settings? I did an export again today of
>> all datasets in Play demo for Sep 2018 with username admin/district and
>> only get the attached export file though it appears there are many more
>> records in the database than only these 3 for Sep 2018.
>>
>>
>>
>> Regards,
>>
>>
>>
>> *Elmarie Claasen*
>>
>> [image: Hisp logo]
>>
>> Project Manager
>>
>> Health Information Systems Program
>>
>> Tel:  041-367 1027
>>
>> Cell: 082 374 2209
>>
>> E-mail: elma...@hisp.org
>>
>> Skype:  elmarie.claasen52
>>
>>
>>
>> *From:* Viet Nguyen 
>> *Sent:* Thursday, October 11, 2018 12:35 PM
>> *To:* Elmarie Claasen 
>> *Cc:* dhis2-users ; dhis2-devs <
>> dhis2-devs@lists.launchpad.net>; mahla...@hisp.org
>> *Subject:* Re: [Dhis2-devs] Problem creating a data export in 2.30
>>
>>
>>
>> I can't reproduce the issue you described on play/2.30, even for
>> September period.
>>
>>
>>
>> Could you provide more info such as steps to reproduce on play/2.30
>> server and export parameters.
>>
>>
>>
>> On Wed, Oct 10, 2018 at 5:50 PM Elmarie Claasen  wrote:
>>
>> Hi all,
>>
>>
>>
>> We having a problem in creating a data export in 2.30 instance on local
>> instance. The file generated is empty. There is no error in the browser
>> console or in the log file in fact no entry in the log file at the time
>> when the export is generated.
>>
>>
>>
>> The version used
>>
>> Version:
>>
>> 2.30
>>
>> Build revision:
>>
>> ade885d
>>
>> Build date:
>>
>> 2018-10-08 03:06
>>
>>
>>
>> The Play demo does not create the same problem when data is exported for
>> July there are data in the export file but when exported for Sep for all or
>> any datasets the export also comes up empty.
>>
>>
>>
>> Regards,
>>
>>
>>
>> *Elmarie Claasen*
>>
>> [image: Hisp logo]
>>
>> Project Manager
>>
>> Health Information Systems Program
>>
>> Tel:  041-367 1027
>>
>> Cell: 082 374 2209
>>
>> E-mail: elma...@hisp.org
>>
>> Skype:  elmarie.claasen52
>>
>>
>>
>>
>>
>> *This message and any attachments are subject to a disclaimer published
>> at http://www.hisp.org/policies.html#comms_disclaimer
>> .  Please read the
>> disclaimer before opening any attachment or taking any other action in
>> terms of this electronic transmission.  If you cannot access the
>> disclaimer, kindly send an email to disclai...@hisp.org
>>  and a copy will be provided to you. By replying to
>> this e-mail or opening any attachment you agree to be bound by the
>> provisions of the disclaimer.*
>>
>> ___
>> 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
>>
>>
>>
>>
>> --
>>
>>
>>
>> Viet Nguyen
>>
>> Software Developer, DHIS 2
>>
>> University of Oslo
>>
>> http://www.dhis2.org
>>
>>
>>
>>
>>
>> *This message and any attachments are subject to a disclaimer published
>> at http://www.hisp.org/policies.html#comms_disclaimer
>> .  Please read the
>> disclaimer before opening any attachment or taking any other action in
>> terms of this electronic transmission.  If you cannot access the
>> disclaimer, kindly send an email to disclai...@hisp.org
>>  and a copy will be provided to you. By replying to
>> this e-mail or opening any attachment you agree to be bound by the
>> provisions of the disclaimer.*
>>
>
>
> --
>
> Viet Nguyen
> Software Developer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
>
> ___
> 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
>
___
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

Re: [Dhis2-devs] Unable to create new users as secret and twofa columns are null

2018-10-14 Thread Viet Nguyen

Hi, which version are you on ?

On Mon, Oct 15, 2018 at 4:02 AM DHIS2 Support 
wrote:

> Dear all,
>
> I am unable to create new users. My troubleshooting shows that when I
> submit a new user request on the web page, a database
> ConstraintViolationException is generated as secret is null. secret and
> twofa columns are expected to be non-null. Please see an error extract
> below and a table showing two attempts.
>
> What could be causing secret and twofa to be null? I have over 100 users
> successfully created before the issue started. thanks.
>
> Error:
> * ERROR 2018-10-14 21:55:17,350 ERROR: null value in column "secret"
> violates not-null constraint
> [org.hibernate.exception.ConstraintViolationException: could not execute
> statement] (ExceptionMapperStandardImpl.java
> [http-bio-127.0.0.1-8080-exec-90])
> statement; SQL [n/a]; constraint [secret]; nested exception is
> org.hibernate.exception.ConstrintViolationException: could not execute
> statement
>
> ___
> 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
>


-- 

Viet Nguyen
Software Developer, DHIS 2
University of Oslo
http://www.dhis2.org
___
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

Re: [Dhis2-devs] Unable to create new users as secret and twofa columns are null

2018-10-14 Thread DHIS2 Support

Version: 2.29Build revision: 88696a1
thanks Viet
On Mon, Oct 15, 2018 at 6:58 AM Viet Nguyen  wrote:

> Hi, which version are you on ?
>
> On Mon, Oct 15, 2018 at 4:02 AM DHIS2 Support 
> wrote:
>
>> Dear all,
>>
>> I am unable to create new users. My troubleshooting shows that when I
>> submit a new user request on the web page, a database
>> ConstraintViolationException is generated as secret is null. secret and
>> twofa columns are expected to be non-null. Please see an error extract
>> below and a table showing two attempts.
>>
>> What could be causing secret and twofa to be null? I have over 100 users
>> successfully created before the issue started. thanks.
>>
>> Error:
>> * ERROR 2018-10-14 21:55:17,350 ERROR: null value in column "secret"
>> violates not-null constraint
>> [org.hibernate.exception.ConstraintViolationException: could not execute
>> statement] (ExceptionMapperStandardImpl.java
>> [http-bio-127.0.0.1-8080-exec-90])
>> statement; SQL [n/a]; constraint [secret]; nested exception is
>> org.hibernate.exception.ConstrintViolationException: could not execute
>> statement
>>
>> ___
>> 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
>>
>
>
> --
>
> Viet Nguyen
> Software Developer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
>
>
___
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

Re: [Dhis2-devs] Unable to create new users as secret and twofa columns are null

2018-10-14 Thread Viet Nguyen

Those columns were added from 2.30 only. Did you upgrade your DB to 2.30
before  ?

On Mon, Oct 15, 2018 at 1:02 PM DHIS2 Support 
wrote:

> Version: 2.29Build revision: 88696a1
> thanks Viet
> On Mon, Oct 15, 2018 at 6:58 AM Viet Nguyen  wrote:
>
>> Hi, which version are you on ?
>>
>> On Mon, Oct 15, 2018 at 4:02 AM DHIS2 Support 
>> wrote:
>>
>>> Dear all,
>>>
>>> I am unable to create new users. My troubleshooting shows that when I
>>> submit a new user request on the web page, a database
>>> ConstraintViolationException is generated as secret is null. secret and
>>> twofa columns are expected to be non-null. Please see an error extract
>>> below and a table showing two attempts.
>>>
>>> What could be causing secret and twofa to be null? I have over 100 users
>>> successfully created before the issue started. thanks.
>>>
>>> Error:
>>> * ERROR 2018-10-14 21:55:17,350 ERROR: null value in column "secret"
>>> violates not-null constraint
>>> [org.hibernate.exception.ConstraintViolationException: could not execute
>>> statement] (ExceptionMapperStandardImpl.java
>>> [http-bio-127.0.0.1-8080-exec-90])
>>> statement; SQL [n/a]; constraint [secret]; nested exception is
>>> org.hibernate.exception.ConstrintViolationException: could not execute
>>> statement
>>>
>>> ___
>>> 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
>>>
>>
>>
>> --
>>
>> Viet Nguyen
>> Software Developer, DHIS 2
>> University of Oslo
>> http://www.dhis2.org
>>
>>
>>

-- 

Viet Nguyen
Software Developer, DHIS 2
University of Oslo
http://www.dhis2.org
___
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

[Dhis2-devs] Could Not Execute Statement Error For 2.29 & 2.30

2018-10-14 Thread Sourabh Bhardwaj

Hi Everyone,

I am not able to save any changes to the Program module. i.e  Assign new
element to program , change sort order for existing elements etc.

*Error: 'Could not execute statement' *
[image: image.png]


Console Log:
[image: image.png]

Have attached the Payload below with this email.

I have test for both versions 2.29(https://play.dhis2.org/2.29) & 2.30(
https://play.dhis2.org/2.30) using superuser.

Thanks & Regards,
Sourabh Bhardwaj
HISP India


program_payload.json
Description: application/json
___
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

Re: [Dhis2-devs] Problem creating a data export in 2.30

Re: [Dhis2-devs] Unable to create new users as secret and twofa columns are null

Re: [Dhis2-devs] Unable to create new users as secret and twofa columns are null

Re: [Dhis2-devs] Unable to create new users as secret and twofa columns are null

[Dhis2-devs] Could Not Execute Statement Error For 2.29 & 2.30

5 matches

Site Navigation

Mail list logo

Footer information