Re: [Dhis2-users] DHIS2 event capture app

[Ese Egerega]

Hi Simon,

You need to assign the org units to the user account under Data capture and
maintenance org units. See snapshot below.
Apps >> Users

-Ese

[image: Inline image 1]

On Mon, Mar 14, 2016 at 11:09 PM, Simon Muyambo <smmuya...@gmail.com> wrote:

> DHIS2 Event capture downloaded from play store is failing to display
> organisation units. Anyone come across this issue?
>
>
>
> *Regards*
>
> *Simon Muyambo*
>
>
>
>
> __ Information from ESET NOD32 Antivirus, version of virus
> signature database 13177 (20160314) __
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] DHIS2 event capture app

[Simon Muyambo]

DHIS2 Event capture downloaded from play store is failing to display 
organisation units. Anyone come across this issue?

 

Regards

Simon Muyambo

 

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Downloading Long Indicator/Data Element names from Pivot Tables

[Laura E. Lincks]

​​Version: 2.20

Build revision: 20001



When downloading results from a pivot table to a Table Layout format, we
noticed that short names of the data elements and Indicators are displayed,
despite the long names appearing on the Pivot Table display prior to
Download. (Note: user settings are set to display NAME as the Property to
display in analysis modules). Furthermore, it appears that some characters
are omitted from the short name when downloading Pivot table results to an
Excel Table Layout (HTML layout is a bit better.)



*Example*:

*Indicator (long) name: *

QualityCheck_MOH711_Female 0-14 yrs NOT Testing among Counselled InPatient



*Indicator Short name: *

% NotTested among Counselled F 0-14yrs Inpatient



*Excel Table Layout result:*

 nottested among counselled f 0-14yrs inpatient



*HTML Table Layout result:*

% NotTested among Counselled F 0-14yrs Inpatient





Is this forced display of short names by design? Our users are asking that
long names be displayed in the Pivot Table downloads. We have a work around
but it is not perfect.



Thank you…

*Laura E. Lincks*
Database Manager/Developer
ICAP - Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1
New York, NY 10032
Tel: 212 304 7132
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Analytics errror

[Marko David Garcia]

Hi Lars.
Thanks for your answer.
The analytics tables are empty.

Before this issue, the analytics process show the error "The
analytics_event_temp_2015_x already exist".

I created this function to delete the repeated tables :


DECLARE
row record;
BEGIN
FOR row IN
SELECT
table_schema,
table_name
FROM
information_schema.tables
WHERE
table_type = 'BASE TABLE'
AND table_name like 'analytics_event_temp_2015%'
LOOP
EXECUTE 'DROP TABLE ' || quote_ident(row.table_schema) || '.' ||
quote_ident(row.table_name);
RAISE INFO 'Dropped table: %', quote_ident(row.table_schema) || '.'
|| quote_ident(row.table_name);
END LOOP;
END;

Can this cause the error?
How can I fix this issue?
Thank you very much.


Cordialmente,

*Marko David Garcia M.*
*Skype: marko_david*

2016-03-14 7:08 GMT-05:00 Lars Helge Øverland :

> Hi Marco,
>
> do verify if this is an output problem, can you look in your database for
> tables such as analytics_2015 and see if there is any data records there?
> If yes, you need to follow the above hints for clearing cache.
>
> regards,
>
> Lars
>
>
> On Mon, Mar 14, 2016 at 6:35 AM, Jason Pickering <
> jason.p.picker...@gmail.com> wrote:
>
>> Hi Marko,
>>
>> I suspect, although am not sure, this may be related to the server side
>> caching of analytics responses. Try setting you "Cache strategy" to "No
>> Cache". The downside here is that the server will need to generate new
>> analytics responses each time you request them. Give that a try and see if
>> it helps. Otherwise, be sure you do not have any caching reverse proxy
>> enabled (or misconfigured) in front of you DHIS2 server.
>>
>> Regards,
>> Jason
>>
>>
>>
>>
>> [image: Inline image 1]
>>
>> On Mon, Mar 14, 2016 at 1:09 AM, Marko David Garcia <
>> markodavi...@gmail.com> wrote:
>>
>>> Hi Uwe. Thanks for your answer.
>>> Yes I cleaned the cache, but the error  continue.
>>> Thank you.
>>> El 13/03/2016 09:52, "uwe wahser"  escribió:
>>>
 Hi Marco,

 did you clear the cache? (App Browser Cache Cleaner & App Data
 Administration - Cache Statistics)

 Hope that helps,

 Uwe

 ---
 Am 13.03.2016 um 17:06 schrieb Marko David Garcia:

 Hello all.

 The analytics process finish fine, but doesn't load any values.
 Dhis version: 2.21
 Buil revision:21049

 Thank you very much.
 Best regards,

 *Marko David Garcia M.*
 *Skype: marko_david*


 ___
 Mailing list: https://launchpad.net/~dhis2-users
 Post to : dhis2-users@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 More help   : https://help.launchpad.net/ListHelp



>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>>
>> --
>> Jason P. Pickering
>> email: jason.p.picker...@gmail.com
>> tel:+46764147049
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org 
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Aggregation query builder details

[Dipali Sahu]

Hi Lars

If not further work on the Aggregation query builder feature, *please don't
remove it*. We actually find it very useful and is critical to our
workflow. For example, we need to get Total patients seen in a facility.
Now with queries the user can see total figures, plus when needed segregate
them by age, gender, visit type (new,follow up etc.) and many more
categories in Pivot tables which provides a easy interface to suffice all
this.

Although it is possible to get these values through Program indicators,
there is no flexibility to see data by a certain category like with the
features that pivot table allow.

I have read other emails on the group that Aggregation query builder's
behavior is a bit unpredictable, but I haven't been able to produce any
errors yet, given we have heavy database and complicated queries.

Is it not possible to keep the Aggregation query feature as it is.

Thank you
Deepali






On Mon, Mar 14, 2016 at 10:10 PM, Lars Helge Øverland 
wrote:

> Hi there,
>
> in fact, aggregation query builder is already scheduled to be removed in
> version 2.23 and will be replaced by program indicators. Admittedly there
> are a few cases where persisted aggregate event data could be useful,
> however we think that generating the aggregate values "on the fly" will
> provide more flexibility and be less of a load on the server by avoiding
> large, nightly batch jobs.
>
> The current aggregation query builder was not up to scratch and could have
> unpredictable behavior. At some point, we might use the program indicator
> engine as basis for supporting persistence of aggregated event data, but
> that is not top priority currently.
>
> We encourage you to try out the program indicators and provide feedback to
> the dev team.
>
> regards,
>
> Lars
>
>
>
>
>
>
>
>
>
> On Sun, Mar 13, 2016 at 1:28 PM, Uddin Fatema  wrote:
>
>> Dear All,
>>
>> We are facing same problem create an Aggregation query builder details as
>>  sum of data element value I put everything but it comes to Data element
>>  forsum/average/min/max ** **and try to select I can’t find anything and
>> this field is*
>>
>>
>>
>> mandatory and the data aggregation data element and tracker data element both
>> has sum aggregation
>>
>>
>> *Actually we cant to count Total Number of live birth from tracker
>> capture patient type data element.*
>>
>>
>> *How can I do it in program indicator ?*
>>
>>
>> *Thanks*
>>
>>
>> *Regards*
>>
>>
>> *Fatema*
>>
>> On Tue, Jan 5, 2016 at 5:21 PM, Ese Egerega  wrote:
>>
>>> Dear All,
>>>
>>> Am riding on Nami's question on aggregate query builder.
>>>
>>> I would like to know if there is a work around since the dropdown for
>>> "Data element for sum/average/min/max*" is not working in dhis2.21*
>>>
>>> We have a data element in tracker which records the quantity of drugs
>>> dispensed to patients during ANC visits. We would like to aggregate the
>>> total drug dispensed to a dataset so as to calculate things like maximum
>>> stock or quantity of drugs to order.
>>>
>>> Right now, am able to aggregate only the number of visits but not the
>>> actual drugs dispensed.
>>>
>>> I will appreciated any suggestions.
>>>
>>> Thanks,
>>> Ese
>>>
>>> On Fri, Nov 27, 2015 at 8:22 AM, Olav Poppe  wrote:
>>>
 Hi,
 just wanted to add my voice in support for improving (e.g. making it
 faster and more reliable, supporting cohort analysis etc), rather than
 removing the aggregation query builder. While I think the program
 indicators are great, I think there are many cases where you would rather
 want to store the aggregate data.

 One case I think is highly relevant (in the sense that countries are
 doing it now) is where you have some facilities reporting via tracker and
 other on paper/aggregate, and you would want the data to end up in the same
 data elements/data sets.

 Olav




 26. nov. 2015 kl. 23.01 skrev Knut Staring :

 Thanks for the clarifications, Elmarie and Dipali

 I think these are good inputs to our dev team, and hope some of them
 will also chip into this conversation.

 Cheers,
 Knut

 On Fri, Nov 27, 2015 at 4:11 AM, Elmarie Claasen 
 wrote:

> Hi Knut,
>
>
>
> Although I can see that program indicators can be helpful it has
> limited use in the context of interoperability between DHIS2 instances. In
> South Africa we feel that Survey type instances should be kept separate
> from Routine Health data collection and as such collect event or tracker
> data for surveys and would want to set up aggregated data elements in the
> system which populates with a stored aggregated data value which we
> export/synchronise with the routine HMIS system e.g.
>
> Patient satisfaction survey rate = No of surveys conducted/No of

[Dhis2-users] publicaccess column changing when modifying details of data elements

[Laura E. Lincks]

Version:2.20Build revision:20001
A user of ours (with all but the administrator role assigned to him) has
been modifying the names (and possibly the short names) of some data
elements in an effort to provide more clarity to them. He has been making
these changes by editing the data element in question via the front end,
making changes to the name/s and saving the changes. It appears that in
doing so the data element records get modified so that the publicaccess
column's values change from "rw--" to "" . (I am able to
confirm this by querying the data on the backend.) Since he was the creator
of the data elements and has his userid assigned to each data element, no
one else has access to the data elements anywhere in DHIS after he
makes the name changes. I am able to change the publicaccess columns to
remedy the immediate problem but I am wondering why this is happening. (The
same problem has occurred on at least 2 different days this past week.) Note
that when I (with all user roles, including administrator) make a change to
the name of a data element in the front end, the publicaccess value remains
as-is. What should I be looking for to determine why it is happening when
this specific user is changing details pertaining to the data elements?
Thanks in advance.

*Laura E. Lincks*
Database Manager/Developer
ICAP - Columbia University
Mailman School of Public Health
60 Haven Ave, Floor B1
New York, NY 10032
Tel: 212 304 7132
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Aggregation query builder details

[Lars Helge Øverland]

Hi there,

in fact, aggregation query builder is already scheduled to be removed in
version 2.23 and will be replaced by program indicators. Admittedly there
are a few cases where persisted aggregate event data could be useful,
however we think that generating the aggregate values "on the fly" will
provide more flexibility and be less of a load on the server by avoiding
large, nightly batch jobs.

The current aggregation query builder was not up to scratch and could have
unpredictable behavior. At some point, we might use the program indicator
engine as basis for supporting persistence of aggregated event data, but
that is not top priority currently.

We encourage you to try out the program indicators and provide feedback to
the dev team.

regards,

Lars









On Sun, Mar 13, 2016 at 1:28 PM, Uddin Fatema  wrote:

> Dear All,
>
> We are facing same problem create an Aggregation query builder details as
> sum of data element value I put everything but it comes to Data element
>  forsum/average/min/max ** **and try to select I can’t find anything and
> this field is*
>
>
>
> mandatory and the data aggregation data element and tracker data element both
> has sum aggregation
>
>
> *Actually we cant to count Total Number of live birth from tracker capture
> patient type data element.*
>
>
> *How can I do it in program indicator ?*
>
>
> *Thanks*
>
>
> *Regards*
>
>
> *Fatema*
>
> On Tue, Jan 5, 2016 at 5:21 PM, Ese Egerega  wrote:
>
>> Dear All,
>>
>> Am riding on Nami's question on aggregate query builder.
>>
>> I would like to know if there is a work around since the dropdown for
>> "Data element for sum/average/min/max*" is not working in dhis2.21*
>>
>> We have a data element in tracker which records the quantity of drugs
>> dispensed to patients during ANC visits. We would like to aggregate the
>> total drug dispensed to a dataset so as to calculate things like maximum
>> stock or quantity of drugs to order.
>>
>> Right now, am able to aggregate only the number of visits but not the
>> actual drugs dispensed.
>>
>> I will appreciated any suggestions.
>>
>> Thanks,
>> Ese
>>
>> On Fri, Nov 27, 2015 at 8:22 AM, Olav Poppe  wrote:
>>
>>> Hi,
>>> just wanted to add my voice in support for improving (e.g. making it
>>> faster and more reliable, supporting cohort analysis etc), rather than
>>> removing the aggregation query builder. While I think the program
>>> indicators are great, I think there are many cases where you would rather
>>> want to store the aggregate data.
>>>
>>> One case I think is highly relevant (in the sense that countries are
>>> doing it now) is where you have some facilities reporting via tracker and
>>> other on paper/aggregate, and you would want the data to end up in the same
>>> data elements/data sets.
>>>
>>> Olav
>>>
>>>
>>>
>>>
>>> 26. nov. 2015 kl. 23.01 skrev Knut Staring :
>>>
>>> Thanks for the clarifications, Elmarie and Dipali
>>>
>>> I think these are good inputs to our dev team, and hope some of them
>>> will also chip into this conversation.
>>>
>>> Cheers,
>>> Knut
>>>
>>> On Fri, Nov 27, 2015 at 4:11 AM, Elmarie Claasen 
>>> wrote:
>>>
 Hi Knut,



 Although I can see that program indicators can be helpful it has
 limited use in the context of interoperability between DHIS2 instances. In
 South Africa we feel that Survey type instances should be kept separate
 from Routine Health data collection and as such collect event or tracker
 data for surveys and would want to set up aggregated data elements in the
 system which populates with a stored aggregated data value which we
 export/synchronise with the routine HMIS system e.g.

 Patient satisfaction survey rate = No of surveys conducted/No of
 facilities

 Patient satisfaction rate = No of satisfied responses/All responses



 It is true that these aggregated elements can be populated with a
 function called via a sql view or cron job but not the most ideal.

 Up to now I have not figured out how to set up an indicator which
 counts if there was any surveys done in a specific period by adding a
 program indicator due to the limited amount of mathematical calculation
 formulae allowed in the Program Indicator engine.



 This said I must say that we don’t have much confidence in the accuracy
 of the Aggregation Query Builder as it is at the moment because there seems
 to be a ceiling limit on how many values can actually be inserted by
 running a scheduled or manual aggregation process and the simultaneous
 initiation of scheduled Aggregation Query builder and Analytics are
 problematic. For this reason we are checking the output of the Aggregation
 Query builder at this stage and when not entirely confident that it
 produces reliable results we are using functions instead.

Re: [Dhis2-users] [Dhis2-devs] outgoing SMS over local modem - anyone using it?

[Alex Tumwesigye]

Dear Guy,

You need to set a SMS command for the system to route the SMS to the right
place.

see
http://dhis2.github.io/dhis2-docs/master/en/user/html/dhis2_user_manual_en_full.html#mobile_sms_command

Alex

On Mon, Mar 14, 2016 at 5:30 PM, Guy Ekani  wrote:

> Hi Zubair,
>
> Here is the log when this problem appear the first time :
>
> * INFO  2016-02-02 19:59:59,649 Detected apps: [] (DefaultAppManager.java
> [http-apr-8080-exec-3])
> * INFO  2016-02-02 20:03:06,682 Detected apps: [] (DefaultAppManager.java
> [http-apr-8080-exec-7])
> * INFO  2016-02-02 20:03:48,867 Detected apps: [] (DefaultAppManager.java
> [http-apr-8080-exec-8])
> * INFO  2016-02-02 20:05:06,589 Received SMS: SMS testing.
> (SmsPublisher.java [Thread-12])
> * INFO  2016-02-02 20:05:06,610 Sending message OutboundSMS
> [recipients=+467, message=DHIS: No command found]
> (DefaultOutboundSmsTransportService.java [Thread-12])
> * INFO  2016-02-02 20:05:06,617 RequestURL:
> http://opertorgateway.org/sendsms.php?UserName=MyUser=**=MyUser=%2B467=DHIS%3A+No+command+found
> PasserelleGSM (SimplisticHttpGetGateWay.java [Thread-12])
> * INFO  2016-02-02 20:05:07,729 Received SMS: SMS testing.
> (SmsPublisher.java [Thread-12])
> * INFO  2016-02-02 20:05:07,741 Sending message OutboundSMS
> [recipients=+467, message=DHIS: No command found]
> (DefaultOutboundSmsTransportService.java [Thread-12])
> * INFO  2016-02-02 20:05:07,742 RequestURL:
> http://opertorgateway.org/sendsms.php?UserName=MyUser=**=MyUser=%2B467=DHIS%3A+No+command+found
> PasserelleGSM (SimplisticHttpGetGateWay.java [Thread-12])
> * WARN  2016-02-02 20:05:47,635 Authentication event
> AuthenticationSuccessEvent: GsmDhisUser; details:
> org.springframework.security.web.authentication.WebAuthenticationDetails@1de6:
> RemoteIpAddress: 24.152.208.38; SessionId: null (LoggerListener.java
> [http-apr-8080-exec-1])
> * WARN  2016-02-02 20:06:31,215 Authentication event
> AuthenticationSuccessEvent: GsmDhisUser; details:
> org.springframework.security.web.authentication.WebAuthenticationDetails@1de6:
> RemoteIpAddress: 24.152.208.38; SessionId: null (LoggerListener.java
> [http-apr-8080-exec-7])
> * WARN  2016-02-02 20:06:41,672 Authentication event
> AuthenticationSuccessEvent: GsmDhisUser; details:
> org.springframework.security.web.authentication.WebAuthenticationDetails@1de6:
> RemoteIpAddress: 24.152.208.38; SessionId: null (LoggerListener.java
> [http-apr-8080-exec-5])
> * WARN  2016-02-02 20:07:00,393 Authentication event
> AuthenticationSuccessEvent: bao-admin; details:
> org.springframework.security.web.authentication.WebAuthenticationDetails@1de6:
> RemoteIpAddress: 24.152.208.38; SessionId: null (LoggerListener.java
> [http-apr-8080-exec-6])
> * INFO  2016-02-02 20:07:08,074 Received SMS: SMS testing.
> (SmsPublisher.java [Thread-12])
> * INFO  2016-02-02 20:07:08,081 Sending message OutboundSMS
> [recipients=+467, message=DHIS: No command found]
> (DefaultOutboundSmsTransportService.java [Thread-12])
> * INFO  2016-02-02 20:07:08,082 RequestURL:
> http://opertorgateway.org/sendsms.php?UserName=MyUser=**=MyUser=%2B467=DHIS%3A+No+command+found
> PasserelleGSM (SimplisticHttpGetGateWay.java [Thread-12])
> * ERROR 2016-02-02 20:07:08,676 Batch update returned unexpected row count
> from update [0]; actual row count: 0; expected: 1; nested exception is
> org.hibernate.StaleStateException: Batch update returned unexpected row
> count from update [0]; actual row count: 0; expected: 1 (SmsPublisher.java
> [Thread-12])
> * INFO  2016-02-02 20:07:14,718 Received SMS: SMS testing.
> (SmsPublisher.java [Thread-26])
> * INFO  2016-02-02 20:07:14,726 Sending message OutboundSMS
> [recipients=+467, message=DHIS: No command found]
> (DefaultOutboundSmsTransportService.java [Thread-26])
> * INFO  2016-02-02 20:07:14,726 RequestURL:
> http://opertorgateway.org/sendsms.php?UserName=MyUser=**=MyUser=%2B467=DHIS%3A+No+command+found
> PasserelleGSM (SimplisticHttpGetGateWay.java [Thread-26])
> * ERROR 2016-02-02 20:07:15,209 Batch update returned unexpected row count
> from update [0]; actual row count: 0; expected: 1; nested exception is
> org.hibernate.StaleStateException: Batch update returned unexpected row
> count from update [0]; actual row count: 0; expected: 1 (SmsPublisher.java
> [Thread-26])
> * INFO  2016-02-02 20:07:25,209 Received SMS: SMS testing.
> (SmsPublisher.java [Thread-26])
> * INFO  2016-02-02 20:07:25,216 Sending message OutboundSMS
> [recipients=+467, message=DHIS: No command found]
> (DefaultOutboundSmsTransportService.java [Thread-26])
> * INFO  2016-02-02 20:07:25,217 RequestURL:
> http://opertorgateway.org/sendsms.php?UserName=MyUser=**=MyUser=%2B467=DHIS%3A+No+command+found
> PasserelleGSM (SimplisticHttpGetGateWay.java [Thread-26])
> * ERROR 2016-02-02 20:07:25,680 Batch update returned unexpected row count
> from update [0]; 

Re: [Dhis2-users] [Dhis2-devs] outgoing SMS over local modem - anyone using it?

[Guy Ekani]

Hi Zubair,
Here is the log when this problem appear the first time :
* INFO  2016-02-02 19:59:59,649 Detected apps: [] (DefaultAppManager.java 
[http-apr-8080-exec-3])* INFO  2016-02-02 20:03:06,682 Detected apps: [] 
(DefaultAppManager.java [http-apr-8080-exec-7])* INFO  2016-02-02 20:03:48,867 
Detected apps: [] (DefaultAppManager.java [http-apr-8080-exec-8])* INFO  
2016-02-02 20:05:06,589 Received SMS: SMS testing. (SmsPublisher.java 
[Thread-12])* INFO  2016-02-02 20:05:06,610 Sending message OutboundSMS 
[recipients=+467, message=DHIS: No command found] 
(DefaultOutboundSmsTransportService.java [Thread-12])* INFO  2016-02-02 
20:05:06,617 RequestURL: 
http://opertorgateway.org/sendsms.php?UserName=MyUser=**=MyUser=%2B467=DHIS%3A+No+command+found
 PasserelleGSM (SimplisticHttpGetGateWay.java [Thread-12])* INFO  2016-02-02 
20:05:07,729 Received SMS: SMS testing. (SmsPublisher.java [Thread-12])* INFO  
2016-02-02 20:05:07,741 Sending message OutboundSMS [recipients=+467, 
message=DHIS: No command found] (DefaultOutboundSmsTransportService.java 
[Thread-12])* INFO  2016-02-02 20:05:07,742 RequestURL: 
http://opertorgateway.org/sendsms.php?UserName=MyUser=**=MyUser=%2B467=DHIS%3A+No+command+found
 PasserelleGSM (SimplisticHttpGetGateWay.java [Thread-12])* WARN  2016-02-02 
20:05:47,635 Authentication event AuthenticationSuccessEvent: GsmDhisUser; 
details: 
org.springframework.security.web.authentication.WebAuthenticationDetails@1de6: 
RemoteIpAddress: 24.152.208.38; SessionId: null (LoggerListener.java 
[http-apr-8080-exec-1])* WARN  2016-02-02 20:06:31,215 Authentication event 
AuthenticationSuccessEvent: GsmDhisUser; details: 
org.springframework.security.web.authentication.WebAuthenticationDetails@1de6: 
RemoteIpAddress: 24.152.208.38; SessionId: null (LoggerListener.java 
[http-apr-8080-exec-7])* WARN  2016-02-02 20:06:41,672 Authentication event 
AuthenticationSuccessEvent: GsmDhisUser; details: 
org.springframework.security.web.authentication.WebAuthenticationDetails@1de6: 
RemoteIpAddress: 24.152.208.38; SessionId: null (LoggerListener.java 
[http-apr-8080-exec-5])* WARN  2016-02-02 20:07:00,393 Authentication event 
AuthenticationSuccessEvent: bao-admin; details: 
org.springframework.security.web.authentication.WebAuthenticationDetails@1de6: 
RemoteIpAddress: 24.152.208.38; SessionId: null (LoggerListener.java 
[http-apr-8080-exec-6])* INFO  2016-02-02 20:07:08,074 Received SMS: SMS 
testing. (SmsPublisher.java [Thread-12])* INFO  2016-02-02 20:07:08,081 Sending 
message OutboundSMS [recipients=+467, message=DHIS: No command found] 
(DefaultOutboundSmsTransportService.java [Thread-12])* INFO  2016-02-02 
20:07:08,082 RequestURL: 
http://opertorgateway.org/sendsms.php?UserName=MyUser=**=MyUser=%2B467=DHIS%3A+No+command+found
 PasserelleGSM (SimplisticHttpGetGateWay.java [Thread-12])* ERROR 2016-02-02 
20:07:08,676 Batch update returned unexpected row count from update [0]; actual 
row count: 0; expected: 1; nested exception is 
org.hibernate.StaleStateException: Batch update returned unexpected row count 
from update [0]; actual row count: 0; expected: 1 (SmsPublisher.java 
[Thread-12])* INFO  2016-02-02 20:07:14,718 Received SMS: SMS testing. 
(SmsPublisher.java [Thread-26])* INFO  2016-02-02 20:07:14,726 Sending message 
OutboundSMS [recipients=+467, message=DHIS: No command found] 
(DefaultOutboundSmsTransportService.java [Thread-26])* INFO  2016-02-02 
20:07:14,726 RequestURL: 
http://opertorgateway.org/sendsms.php?UserName=MyUser=**=MyUser=%2B467=DHIS%3A+No+command+found
 PasserelleGSM (SimplisticHttpGetGateWay.java [Thread-26])* ERROR 2016-02-02 
20:07:15,209 Batch update returned unexpected row count from update [0]; actual 
row count: 0; expected: 1; nested exception is 
org.hibernate.StaleStateException: Batch update returned unexpected row count 
from update [0]; actual row count: 0; expected: 1 (SmsPublisher.java 
[Thread-26])* INFO  2016-02-02 20:07:25,209 Received SMS: SMS testing. 
(SmsPublisher.java [Thread-26])* INFO  2016-02-02 20:07:25,216 Sending message 
OutboundSMS [recipients=+467, message=DHIS: No command found] 
(DefaultOutboundSmsTransportService.java [Thread-26])* INFO  2016-02-02 
20:07:25,217 RequestURL: 
http://opertorgateway.org/sendsms.php?UserName=MyUser=**=MyUser=%2B467=DHIS%3A+No+command+found
 PasserelleGSM (SimplisticHttpGetGateWay.java [Thread-26])* ERROR 2016-02-02 
20:07:25,680 Batch update returned unexpected row count from update [0]; actual 
row count: 0; expected: 1; nested exception is 
org.hibernate.StaleStateException: Batch update returned unexpected row count 
from update [0]; actual row count: 0; expected: 1 (SmsPublisher.java 
[Thread-26])* INFO  2016-02-02 20:07:35,680 Received SMS: SMS testing. 
(SmsPublisher.java [Thread-26])

Sincerely, = EKANI Guy 
 



  

Le Lundi 14 mars 2016 13h31, Zubair 

[Dhis2-users] Web API: event CSV import

[Iuri Fanti]

Hi all,

to import events via webAPI in CSV format I'm following the
indications at this link:

http://dhis2.github.io/dhis2-docs/master/en/developer/html/ch01s15.html#d5e1904

but the server keeps returning the error "The server refused this
request because the request entity is in a format not supported by the
requested resource for the requested method.". It's a simple csv, I
have no idea of what I'm doing wrong. As a target URL I'm using
/api/events.csv

Attached the file I'm sending.

Thank you in advance for any help,

Iuri

-- 
@-`-,--
"event","status","program","programStage","enrollment","orgUnit","eventDate","dueDate","latitude","longitude","dataElement","value","storedBy","providedElsewhere"
,"COMPLETED","g9UTEvaaxDk","PcHDCBjoXU4",,"KqL71SkeKpc","2015-03-13""nqhuoslbDCx","2000-01-01",,
,"COMPLETED","g9UTEvaaxDk","PcHDCBjoXU4",,"KqL71SkeKpc","2015-03-13""RMEnhvTVUOx","M",,
,"COMPLETED","g9UTEvaaxDk","PcHDCBjoXU4",,"KqL71SkeKpc","2015-03-13""hZ0g07DtKlB","IDP",,
,"COMPLETED","g9UTEvaaxDk","PcHDCBjoXU4",,"KqL71SkeKpc","2015-03-13""QyX23E7XKrU","99",,
,"COMPLETED","g9UTEvaaxDk","PcHDCBjoXU4",,"KqL71SkeKpc","2015-03-13""mmrNCWtSeuU","BCG
 + OPV (zero dose) + HBV (1st dose)",,
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] outgoing SMS over local modem - anyone using it?

[Zubair Asghar Raja]

Hi Guy,

I am responsible for SMS related stuff. Can you share the logs ?

Regards
Zubair





On 14 Mar 2016 1:14 PM, at 1:14 PM, "Lars Helge Øverland"  
wrote:
>Thanks Guy. We will have a developer reach out to you.
>
>Since nobody have reported to be using the local SMS gateway modem, we
>will
>remove it for version 2.23.
>
>regards,
>
>Lars
>
>
>On Thu, Mar 10, 2016 at 8:52 AM, Guy Ekani 
>wrote:
>
>> Hello Lars,
>>
>> Thank's for information,
>>
>> We are trying to use SMS funtionnality with  a SMS gateway provided
>by an
>> external operator (Genreric HTTP Gateway) with DHIS 2.21 Build
>revision:
>> 20998
>>
>> But we have two problems :
>> - The received SMS are not imported automatically,
>> - When we manually import a received SMS, it's make a loop that send
>a
>> thousand of SMS to a specific Phone number
>>
>> Please, could you help us to solve this issue that's drained our SMS
>> Credit ?
>>
>> Sincerely
>>
>> =
>> EKANI Guy
>>
>>
>>
>>
>>
>>
>>
>> Le Mardi 8 mars 2016 11h22, Lars Helge Øverland  a
>écrit :
>>
>>
>> Hi all,
>>
>> we are rewriting much of the functionality for sending outgoing SMS
>in
>> DHIS 2. In that regard we were wondering if anyone is using the
>current
>> function for sending SMS using a local SMS modem / gateway?
>>
>> In production setups one should in any case use a network-based SMS
>> gateway provided by an external operator (bulksms, clickatell).
>>
>> The library we use (smslib ) is deprected as
>well. We
>> were thinking to end support for local SMS modems in 2.23.
>>
>> regards,
>>
>> Lars
>>
>>
>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> http://www.dhis2.org 
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to: dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help  : https://help.launchpad.net/ListHelp
>>
>>
>>
>
>
>-- 
>Lars Helge Øverland
>Lead developer, DHIS 2
>University of Oslo
>Skype: larshelgeoverland
>http://www.dhis2.org 
>
>
>
>
>___
>Mailing list: https://launchpad.net/~dhis2-devs
>Post to : dhis2-d...@lists.launchpad.net
>Unsubscribe : https://launchpad.net/~dhis2-devs
>More help   : https://help.launchpad.net/ListHelp
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] outgoing SMS over local modem - anyone using it?

[Lars Helge Øverland]

Thanks Guy. We will have a developer reach out to you.

Since nobody have reported to be using the local SMS gateway modem, we will
remove it for version 2.23.

regards,

Lars


On Thu, Mar 10, 2016 at 8:52 AM, Guy Ekani  wrote:

> Hello Lars,
>
> Thank's for information,
>
> We are trying to use SMS funtionnality with  a SMS gateway provided by an
> external operator (Genreric HTTP Gateway) with DHIS 2.21 Build revision:
> 20998
>
> But we have two problems :
> - The received SMS are not imported automatically,
> - When we manually import a received SMS, it's make a loop that send a
> thousand of SMS to a specific Phone number
>
> Please, could you help us to solve this issue that's drained our SMS
> Credit ?
>
> Sincerely
>
> =
> EKANI Guy
>
>
>
>
>
>
>
> Le Mardi 8 mars 2016 11h22, Lars Helge Øverland  a écrit :
>
>
> Hi all,
>
> we are rewriting much of the functionality for sending outgoing SMS in
> DHIS 2. In that regard we were wondering if anyone is using the current
> function for sending SMS using a local SMS modem / gateway?
>
> In production setups one should in any case use a network-based SMS
> gateway provided by an external operator (bulksms, clickatell).
>
> The library we use (smslib ) is deprected as well. We
> were thinking to end support for local SMS modems in 2.23.
>
> regards,
>
> Lars
>
>
>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> http://www.dhis2.org 
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to: dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help  : https://help.launchpad.net/ListHelp
>
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://www.dhis2.org 
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] Analytics errror

[Lars Helge Øverland]

Hi Marco,

do verify if this is an output problem, can you look in your database for
tables such as analytics_2015 and see if there is any data records there?
If yes, you need to follow the above hints for clearing cache.

regards,

Lars


On Mon, Mar 14, 2016 at 6:35 AM, Jason Pickering <
jason.p.picker...@gmail.com> wrote:

> Hi Marko,
>
> I suspect, although am not sure, this may be related to the server side
> caching of analytics responses. Try setting you "Cache strategy" to "No
> Cache". The downside here is that the server will need to generate new
> analytics responses each time you request them. Give that a try and see if
> it helps. Otherwise, be sure you do not have any caching reverse proxy
> enabled (or misconfigured) in front of you DHIS2 server.
>
> Regards,
> Jason
>
>
>
>
> [image: Inline image 1]
>
> On Mon, Mar 14, 2016 at 1:09 AM, Marko David Garcia <
> markodavi...@gmail.com> wrote:
>
>> Hi Uwe. Thanks for your answer.
>> Yes I cleaned the cache, but the error  continue.
>> Thank you.
>> El 13/03/2016 09:52, "uwe wahser"  escribió:
>>
>>> Hi Marco,
>>>
>>> did you clear the cache? (App Browser Cache Cleaner & App Data
>>> Administration - Cache Statistics)
>>>
>>> Hope that helps,
>>>
>>> Uwe
>>>
>>> ---
>>> Am 13.03.2016 um 17:06 schrieb Marko David Garcia:
>>>
>>> Hello all.
>>>
>>> The analytics process finish fine, but doesn't load any values.
>>> Dhis version: 2.21
>>> Buil revision:21049
>>>
>>> Thank you very much.
>>> Best regards,
>>>
>>> *Marko David Garcia M.*
>>> *Skype: marko_david*
>>>
>>>
>>> ___
>>> Mailing list: https://launchpad.net/~dhis2-users
>>> Post to : dhis2-users@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-users
>> Post to : dhis2-users@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-users
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Jason P. Pickering
> email: jason.p.picker...@gmail.com
> tel:+46764147049
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>
>


-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
http://www.dhis2.org 
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Free SSL with letsencrypt

[Bob Jolliffe]

And this Chinese supplier might well be the way around any issues
arising from US sanctions :-)

On 14 March 2016 at 12:30, Steven Uggowitzer  wrote:
> Thanks David,
>
> For those of you looking for another (probably less secure) free option,
> there is also WoSign  https://www.wosign.com/English/freeSSL.htm
> I've actually been using it a lot with good success.
>
> Best
> S
>
>
> On 14 March 2016 at 09:45, David Huser  wrote:
>>
>> Dear all
>>
>> I recently tried to obtain a free SSL certificate with Let's Encrypt. It
>> is still in public beta (although they have already issued their millionth
>> certificate). I wrote a little guide for a simple single instance of DHIS
>> here (including autorenewal):
>> https://gist.github.com/davidhuser/a34a4ba1db555cc56ac8
>>
>> Best regards
>> David
>>
>>
>>
>> ___
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to : dhis2-d...@lists.launchpad.net
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help   : https://help.launchpad.net/ListHelp
>

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Free SSL with letsencrypt

[Bob Jolliffe]

Thanks David.  That's really useful.  Removing credit card
transactions from the process of getting certs signed is going to be
very valuable.

Note from here 
(https://community.letsencrypt.org/t/certificates-for-us-sanctioned-countries/1223)
that there might still be some issues in some US sanctioned
jurisdictions but this is great progress.

On 14 March 2016 at 09:45, David Huser  wrote:
> Dear all
>
> I recently tried to obtain a free SSL certificate with Let's Encrypt. It is
> still in public beta (although they have already issued their millionth
> certificate). I wrote a little guide for a simple single instance of DHIS
> here (including autorenewal):
> https://gist.github.com/davidhuser/a34a4ba1db555cc56ac8
>
> Best regards
> David
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Free SSL with letsencrypt

[Steven Uggowitzer]

Thanks David,

For those of you looking for another (probably less secure) free option,
there is also WoSign  https://www.wosign.com/English/freeSSL.htm
I've actually been using it a lot with good success.

Best
S


On 14 March 2016 at 09:45, David Huser  wrote:

> Dear all
>
> I recently tried to obtain a free SSL certificate with Let's Encrypt.
>  It is still in public beta (although they have
> already issued their millionth certificate). I wrote a little guide for a
> simple single instance of DHIS here (including autorenewal):
> https://gist.github.com/davidhuser/a34a4ba1db555cc56ac8
>
> Best regards
> David
>
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [Dhis2-devs] Data elements not visible in program validation rules

[Abyot Asalefew Gizaw]

Hi Archana,

Program Validation UI is something we are planning to phase out. You should
be able to define validation expressions using Program Rules.

---
Thank you,
Abyot.

On Mon, Mar 14, 2016 at 11:14 AM, Archana Chillala <
archa...@thoughtworks.com> wrote:

> Hi devs,
>
> I am using DHIS2 version 2.23. I have created a program and assigned a few
> data elements to it. Also, assigned the program to org. units and a user
> role as well. Then, I tried to add a validation rule for the program. But,
> in the expression window (Edit left side & Edit right side) of the
> validation rule, I am not able to see any data elements assigned to the
> program. Am I missing something?
>
> Please find a screenshot of the same attached with the mail.
>
>
> Any help here would be appreciated.
>
>
> [image: Inline image 1]
>
>
>
> *Thanks*
>
> Archana Chillala
> Application Developer
> Email archa...@thoughtworks.com
> Telephone +91 9100960533 <+91+9100960533>
> [image: ThoughtWorks]
> 
>
> ___
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to : dhis2-d...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

[Dhis2-users] Data elements not visible in program validation rules

[Archana Chillala]

Hi devs,

I am using DHIS2 version 2.23. I have created a program and assigned a few
data elements to it. Also, assigned the program to org. units and a user
role as well. Then, I tried to add a validation rule for the program. But,
in the expression window (Edit left side & Edit right side) of the
validation rule, I am not able to see any data elements assigned to the
program. Am I missing something?

Please find a screenshot of the same attached with the mail.


Any help here would be appreciated.


[image: Inline image 1]



*Thanks*

Archana Chillala
Application Developer
Email archa...@thoughtworks.com
Telephone +91 9100960533 <+91+9100960533>
[image: ThoughtWorks]

___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [DHIS] Unable to delete a user

[Archana Chillala]

Thanks, Lars.

Archana Chillala
Application Developer
Email archa...@thoughtworks.com
Telephone +91 9100960533 <+91+9100960533>
[image: ThoughtWorks]


On Sun, Mar 13, 2016 at 7:57 PM, Lars Helge Øverland  wrote:

> Hi Archana,
>
> this has been fixed in trunk now.
>
> This does not affect stable releases.
>
> regards,
>
> Lars
>
>
>
> On Fri, Mar 11, 2016 at 6:44 AM, Archana Chillala <
> archa...@thoughtworks.com> wrote:
>
>> Hi Lars,
>>
>> I tried clear cache. But still the same. Unable to delete a user. Even if
>> the user is newly created and not associated to any other object.
>>
>> Any thoughts on this?
>>
>>
>> *Thanks*
>>
>> Archana Chillala
>> Application Developer
>> Email archa...@thoughtworks.com
>> Telephone +91 9100960533 <+91+9100960533>
>> [image: ThoughtWorks]
>> 
>>
>> On Wed, Mar 9, 2016 at 6:22 PM, Lars Helge Øverland 
>> wrote:
>>
>>> Hi Archana,
>>>
>>> I think this happens due to some leak in our application cache. Try
>>> going to data admin > cache statistics > clear cache and try again.
>>>
>>> regards,
>>>
>>> Lars
>>>
>>>
>>> On Fri, Mar 4, 2016 at 11:52 AM, Archana Chillala <
>>> archa...@thoughtworks.com> wrote:
>>>
 Hi Morten,

 We are using DHIS version 2.23 and created some sample metadata on it.
 When we try to delete a user, the user does not get removed.

 Following are the logs for the exception:

 * INFO  2016-03-04 16:13:13,146 'admin' update
 org.hisp.dhis.user.UserAuthorityGroup, name: Superuser, uid: gETZb5SDObu
 (AuditLogUtil.java [qtp1727373358-105])
 * ERROR 2016-03-04 16:13:13,151 Failed to invoke method deleteUser on
 DeletionHandler 'UserSettingDeletionHandler' (DefaultDeletionManager.java
 [qtp1727373358-105])
 java.lang.reflect.InvocationTargetException
 at sun.reflect.GeneratedMethodAccessor618.invoke(Unknown Source)
 at
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:497)
 at
 org.hisp.dhis.system.deletion.DefaultDeletionManager.execute(DefaultDeletionManager.java:147)
 at
 org.hisp.dhis.system.deletion.DeletionInterceptor.intercept(DeletionInterceptor.java:54)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at
 sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at
 sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:497)
 Caused by: org.hibernate.NonUniqueObjectException: a different object
 with the same identifier value was already associated with the session:
 [org.hisp.dhis.user.UserSetting#org.hisp.dhis.user.UserSetting@528fc6ba
 ]
 at
 org.hibernate.engine.internal.StatefulPersistenceContext.checkUniqueness(StatefulPersistenceContext.java:696)
 at
 org.hibernate.event.internal.DefaultDeleteEventListener.onDelete(DefaultDeleteEventListener.java:119)
 at
 org.hibernate.event.internal.DefaultDeleteEventListener.onDelete(DefaultDeleteEventListener.java:74)
 at org.hibernate.internal.SessionImpl.fireDelete(SessionImpl.java:918)
 at org.hibernate.internal.SessionImpl.delete(SessionImpl.java:855)
 at
 org.hisp.dhis.user.hibernate.HibernateUserSettingStore.deleteUserSetting(HibernateUserSettingStore.java:107)
 at
 org.hisp.dhis.user.DefaultUserSettingService.deleteUserSetting(DefaultUserSettingService.java:160)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 * INFO  2016-03-04 16:13:13,154 'admin' delete org.hisp.dhis.user.User,
 name: user new, uid: bSJzGJPYnWi (AuditLogUtil.java [qtp1727373358-105])
 * INFO  2016-03-04 16:13:13,155 'admin' delete
 org.hisp.dhis.user.UserCredentials, name: admin admin (AuditLogUtil.java
 [qtp1727373358-105])
 * INFO  2016-03-04 16:13:13,158 'admin' delete org.hisp.dhis.user.User,
 name: user new, uid: bSJzGJPYnWi (AuditLogUtil.java [qtp1727373358-105])
 * WARN  2016-03-04 16:13:13,174 SQL Error: 0, SQLState: 23503
 (SqlExceptionHelper.java [qtp1727373358-105])
 * ERROR 2016-03-04 16:13:13,175 ERROR: update or delete on table
 "userinfo" violates foreign key constraint "fk_usersetting_userinfoid" on
 table "usersetting"
   Detail: Key (userinfoid)=(289) is still referenced from table
 "usersetting". (SqlExceptionHelper.java [qtp1727373358-105])
 * ERROR 2016-03-04 16:13:13,175 Error while executing action
 (ExceptionInterceptor.java [qtp1727373358-105])
 org.springframework.dao.DataIntegrityViolationException: could not
 execute statement; SQL [n/a]; constraint 

[Dhis2-users] Free SSL with letsencrypt

[David Huser]

Dear all

I recently tried to obtain a free SSL certificate with Let's Encrypt. 
 It is still in public beta (although they have 
already issued their millionth certificate). I wrote a little guide for 
a simple single instance of DHIS here (including autorenewal):

https://gist.github.com/davidhuser/a34a4ba1db555cc56ac8

Best regards
David


___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp

Re: [Dhis2-users] [DHIS] Program gets unassigned to a user role during metadata export-import

[Archana Chillala]

Currently using DHIS version 2.23 on both instances.

Archana Chillala
Application Developer
Email archa...@thoughtworks.com
Telephone +91 9100960533 <+91+9100960533>
[image: ThoughtWorks]


On Mon, Mar 14, 2016 at 1:26 PM, Archana Chillala  wrote:

> Hi Morten,
>
> We have two instances of DHIS one of which has been setup with sample
> metadata which is imported into the other instance through export-import.
>
> On the first instance, we have created a program and assigned it to a user
> role. Then, metadata is exported from that instance and imported into the
> other. The program gets imported into the second instance, but comes
> unassigned to any user role (even if that has been configured on the first
> instance). Is this a known issue?
>
> Any help here would be appreciated.
>
>
>
> *Thanks*
>
> Archana Chillala
> Application Developer
> Email archa...@thoughtworks.com
> Telephone +91 9100960533 <+91+9100960533>
> [image: ThoughtWorks]
> 
>
___
Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help   : https://help.launchpad.net/ListHelp