Re: [Dhis2-devs] [Dhis2-users] Looking for Human Resource System to integrate with DHIS

[Juma Lungo]

Hi Arthur,
I would recommend iHRIS.
It has many features, integrates nicely with DHIS2, implemented in many 
countries and it is being supported by an active community working closely with 
DHIS2 developers.
Lungo


  From: Calle Hedberg 
 To: Arthur Heywood  
Cc: dhis2-users ; dhis2-devs 
; gerald thomas ; 
Seleman Ally 
 Sent: Tuesday, October 4, 2016 10:20 PM
 Subject: Re: [Dhis2-devs] [Dhis2-users] Looking for Human Resource System to 
integrate with DHIS
   
Arthur,
I'm not directly involved with the HRIS work using DHIS, my current focus is on 
a fully integrated disease surveillance system. Will find out and get back to 
you.
Regards
Calle
On 4 October 2016 at 15:15, Arthur Heywood  wrote:

Calle In Zambia we are also looking to set up what you call a "core" Human 
Resource HMIS ... mainly to do some "Bottleneck analysis" for our MDGi 
districts ...
Are we able to use a beta version and see what we are able to adapt it to our 
needs (same people being called different professional jobs  etc)  and then 
feed back into the development process interesting to know how far you have 
progressed?
Cheersa
**Without deviation from the norm, there can be no progress* *(Frank Zappa)
*Skype* arthur_heywood_zaTanzania* +255-773669393 OR +255 673150252








On 26 August 2016 at 23:08, Calle Hedberg  wrote:

Laura,
The two main HRIS component designs "within" DHIS2 are the HRHIS in Tanzania 
and another in Vietnam (John Lewis or Morten will be able to tell you more 
about that one). 
South Africa is currently using a customised Tracker app for managing Community 
Service and Internships (around 10,000 graduates are applying for internship or 
Community Service posts per annum). 
We are also working on a "core" workforce registry tightly integrated with 
DHIS2. By "core" I mean it will only deal with actual HR resources including 
position, what they are licensed/authorised to do, and contact details. Things 
like continuous education, bursaries, payroll, etc are processed/managed by 
other systems. A major advantage of tight integration will be the ability to 
use DHIS2 communication and messages + user registration to communicate 
directly with health workers - in particular since health workers increasingly 
will be interacting directly with DHIS2 on a daily basis through (daily) 
capturing of routine data, disease notifications, various Tracker apps (browser 
or Android), etc.
Your basic requirements seem very similar: your primary need is to track the 
workforce as an INPUT RESOURCE to health service delivery, and not to track 
salaries and CVs and health insurance and employment history and a bunch of 
other "personal" things. So you need to know WHO they are, where they actually 
work and with what (in what position), what they are able to do (mostly this 
relates to formal/legal practice licensing etc, but it could be expanded to 
include specialist knowledge about certain diseases etc), and how to contact 
them.
RegardsCalle
On 26 August 2016 at 21:56, gerald thomas  wrote:

I had use ihris and it is good. If you want help with it I am willing to help.
On Aug 26, 2016 6:46 PM, "Laura E. Lincks"  
wrote:

We are looking for a simple Human Resources tool to integrate with a DHIS 
aggregate database. Little is known of the needs of the HRIS, but for now it 
needs to track personnel details and groups of personnel will need to be 
associated with various programs in a separate DHIS aggregate database. An Open 
Source HRIS is preferable.
In searching for tools I have come across the following:HRHIS in Tanzania 
developed by the HISP-TZ/University of Dar es SalaamiHRIS developed by global 
Capacity Project.​
I was wondering if anyone had any knowledge of or experience with these 
packages or if there were other applications that could be of use to us?
Thanks in advance to anyone with leads or information.
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-u sers
Post to     : dhis2-us...@lists.launchpad.ne t
Unsubscribe : https://launchpad.net/~dhis2-u sers
More help   : https://help.launchpad.net/Lis tHelp



__ _
Mailing list: https://launchpad.net/~dhis2-d evs
Post to     : dhis2-devs@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-d evs
More help   : https://help.launchpad.net/Lis tHelp





-- 
** *Calle Hedberg46D Alma Road, 7700 
Rosebank, SOUTH AFRICA Tel/fax (home): +27-21-685-6472Cell: 
+27-82-853-5352Iridium SatPhone: 

Re: [Dhis2-devs] Default form swap between row and column

[Nayeem Al Mifthah]

Dear All
If the above mention functionality will take long time to develop, is it
possible to add "Design data entry form" option under section of dataset.

Actually, we have large category combo (with long list of category option
combo) for one section of a dataset, which make the default data entry form
large in horizontal side for that section. The same dataset have another
section with some elements with no category combo which looks good in
default form.

It will be great, if I can design one section and leave another as default.
I can design the full dataset in custom form, but how much design i have
inserted it takes long time to load in low resource settings. And you all
know, Bangladesh is implementing a large database of DHIS2 with limited
bandwidth in central and end user level.

*Nayeem Al Mifthah*
*Consultant for HSS, Health MIS, M*
Email: n.mift...@gmail.com
Cell:+8801914030574
Skype: nayeem.a.m

On Tue, Oct 4, 2016 at 6:19 PM, Nayeem Al Mifthah 
wrote:

> Dear Lars
> Thanks for your clarification.
>
> Could it go under near future development plan.
>
> *Nayeem Al Mifthah*
> *Consultant for HSS, Health MIS, M*
> Email: n.mift...@gmail.com
> Cell:+8801914030574
> Skype: nayeem.a.m
>
> On Tue, Oct 4, 2016 at 5:22 PM, Lars Helge Øverland 
> wrote:
>
>> Hi Nayeem,
>>
>> I agree that would be useful. There are no immediate plans for this
>> unfortunately. For now you will have to resort to a custom form.
>>
>> best regards,
>>
>> Lars
>>
>>
>> On Tue, Oct 4, 2016 at 10:57 AM, Nayeem Al Mifthah 
>> wrote:
>>
>>> Dear All
>>> Is there any plan to give an option in Dataset edit to swap (transpose)
>>> row and column in default form.
>>>
>>> In some of our forms, there are a number of category option which will
>>> be better to see as row, and it will better if we can see data elements in
>>> column. It may improve the view and print facility from dataset report and
>>> data entry screen.
>>>
>>> It will be great if the option can be added in section management. So
>>> that each section can view differently.
>>>
>>>
>>> *Nayeem Al Mifthah*
>>> *Consultant for HSS, Health MIS, M*
>>> Email: n.mift...@gmail.com
>>> Cell:+8801914030574
>>> Skype: nayeem.a.m
>>>
>>
>>
>>
>> --
>> Lars Helge Øverland
>> Lead developer, DHIS 2
>> University of Oslo
>> Skype: larshelgeoverland
>> l...@dhis2.org
>> 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] [Dhis2-users] Looking for Human Resource System to integrate with DHIS

[Calle Hedberg]

Arthur,

I'm not directly involved with the HRIS work using DHIS, my current focus
is on a fully integrated disease surveillance system. Will find out and get
back to you.

Regards
Calle

On 4 October 2016 at 15:15, Arthur Heywood  wrote:

> Calle
> In Zambia we are also looking to set up what you call a "core" Human
> Resource HMIS ... mainly to do some "Bottleneck analysis" for our MDGi
> districts ...
>
> Are we able to use a beta version and see what we are able to adapt it to
> our needs (same people being called different professional jobs  etc)  and
> then feed back into the development process interesting to know how far
> you have progressed?
>
> Cheers
> a
>
> *Without deviation from the norm, there can be no progress*** *(Frank
> Zappa)*
> *Skype* arthur_heywood_za
> Tanzania* +255-773669393 OR +255 673150252
>
>
>
>
>
>
>
>
>
> On 26 August 2016 at 23:08, Calle Hedberg  wrote:
>
>> Laura,
>>
>> The two main HRIS component designs "within" DHIS2 are the HRHIS in
>> Tanzania and another in Vietnam (John Lewis or Morten will be able to tell
>> you more about that one).
>>
>> South Africa is currently using a customised Tracker app for managing
>> Community Service and Internships (around 10,000 graduates are applying for
>> internship or Community Service posts per annum).
>>
>> We are also working on a "core" workforce registry tightly integrated
>> with DHIS2. By "core" I mean it will only deal with actual HR resources
>> including position, what they are licensed/authorised to do, and contact
>> details. Things like continuous education, bursaries, payroll, etc are
>> processed/managed by other systems. A major advantage of tight integration
>> will be the ability to use DHIS2 communication and messages + user
>> registration to communicate directly with health workers - in particular
>> since health workers increasingly will be interacting directly with DHIS2
>> on a daily basis through (daily) capturing of routine data, disease
>> notifications, various Tracker apps (browser or Android), etc.
>>
>> Your basic requirements seem very similar: your primary need is to track
>> the workforce as an INPUT RESOURCE to health service delivery, and not to
>> track salaries and CVs and health insurance and employment history and a
>> bunch of other "personal" things. So you need to know WHO they are, where
>> they actually work and with what (in what position), what they are able to
>> do (mostly this relates to formal/legal practice licensing etc, but it
>> could be expanded to include specialist knowledge about certain diseases
>> etc), and how to contact them.
>>
>> Regards
>> Calle
>>
>> On 26 August 2016 at 21:56, gerald thomas  wrote:
>>
>>> I had use ihris and it is good. If you want help with it I am willing to
>>> help.
>>>
>>> On Aug 26, 2016 6:46 PM, "Laura E. Lincks" <
>>> laura.lin...@icap.columbia.edu> wrote:
>>>
 We are looking for a simple Human Resources tool to integrate with a
 DHIS aggregate database. Little is known of the needs of the HRIS, but for
 now it needs to track personnel details and groups of personnel will need
 to be associated with various programs in a separate DHIS aggregate
 database. An Open Source HRIS is preferable.

 In searching for tools I have come across the following:
 HRHIS in Tanzania developed by
 the HISP-TZ/University of Dar es Salaam
 iHRIS  developed by global Capacity Project.​

 I was wondering if anyone had any knowledge of or experience with these
 packages or if there were other applications that could be of use to us?

 Thanks in advance to anyone with leads or information.

 *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-us...@lists.launchpad.net
 Unsubscribe : https://launchpad.net/~dhis2-users
 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
>>>
>>>
>>
>>
>> --
>>
>> ***
>>
>> Calle Hedberg
>>
>> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>>
>> Tel/fax (home): +27-21-685-6472
>>
>> Cell: +27-82-853-5352
>>
>> Iridium SatPhone: +8816-315-19119
>>
>> Email: calle.hedb...@gmail.com
>>
>> Skype: calle_hedberg
>>
>> ***
>>
>>
>> ___
>> Mailing list: 

Re: [Dhis2-devs] [Dhis2-users] Looking for Human Resource System to integrate with DHIS

[Arthur Heywood]

Calle
In Zambia we are also looking to set up what you call a "core" Human
Resource HMIS ... mainly to do some "Bottleneck analysis" for our MDGi
districts ...

Are we able to use a beta version and see what we are able to adapt it to
our needs (same people being called different professional jobs  etc)  and
then feed back into the development process interesting to know how far
you have progressed?

Cheers
a

*Without deviation from the norm, there can be no progress*** *(Frank
Zappa)*
*Skype* arthur_heywood_za
Tanzania* +255-773669393 OR +255 673150252









On 26 August 2016 at 23:08, Calle Hedberg  wrote:

> Laura,
>
> The two main HRIS component designs "within" DHIS2 are the HRHIS in
> Tanzania and another in Vietnam (John Lewis or Morten will be able to tell
> you more about that one).
>
> South Africa is currently using a customised Tracker app for managing
> Community Service and Internships (around 10,000 graduates are applying for
> internship or Community Service posts per annum).
>
> We are also working on a "core" workforce registry tightly integrated with
> DHIS2. By "core" I mean it will only deal with actual HR resources
> including position, what they are licensed/authorised to do, and contact
> details. Things like continuous education, bursaries, payroll, etc are
> processed/managed by other systems. A major advantage of tight integration
> will be the ability to use DHIS2 communication and messages + user
> registration to communicate directly with health workers - in particular
> since health workers increasingly will be interacting directly with DHIS2
> on a daily basis through (daily) capturing of routine data, disease
> notifications, various Tracker apps (browser or Android), etc.
>
> Your basic requirements seem very similar: your primary need is to track
> the workforce as an INPUT RESOURCE to health service delivery, and not to
> track salaries and CVs and health insurance and employment history and a
> bunch of other "personal" things. So you need to know WHO they are, where
> they actually work and with what (in what position), what they are able to
> do (mostly this relates to formal/legal practice licensing etc, but it
> could be expanded to include specialist knowledge about certain diseases
> etc), and how to contact them.
>
> Regards
> Calle
>
> On 26 August 2016 at 21:56, gerald thomas  wrote:
>
>> I had use ihris and it is good. If you want help with it I am willing to
>> help.
>>
>> On Aug 26, 2016 6:46 PM, "Laura E. Lincks" > u> wrote:
>>
>>> We are looking for a simple Human Resources tool to integrate with a
>>> DHIS aggregate database. Little is known of the needs of the HRIS, but for
>>> now it needs to track personnel details and groups of personnel will need
>>> to be associated with various programs in a separate DHIS aggregate
>>> database. An Open Source HRIS is preferable.
>>>
>>> In searching for tools I have come across the following:
>>> HRHIS in Tanzania developed by the
>>> HISP-TZ/University of Dar es Salaam
>>> iHRIS  developed by global Capacity Project.​
>>>
>>> I was wondering if anyone had any knowledge of or experience with these
>>> packages or if there were other applications that could be of use to us?
>>>
>>> Thanks in advance to anyone with leads or information.
>>>
>>> *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-us...@lists.launchpad.net
>>> Unsubscribe : https://launchpad.net/~dhis2-users
>>> 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
>>
>>
>
>
> --
>
> ***
>
> Calle Hedberg
>
> 46D Alma Road, 7700 Rosebank, SOUTH AFRICA
>
> Tel/fax (home): +27-21-685-6472
>
> Cell: +27-82-853-5352
>
> Iridium SatPhone: +8816-315-19119
>
> Email: calle.hedb...@gmail.com
>
> Skype: calle_hedberg
>
> ***
>
>
> ___
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-us...@lists.launchpad.net
> Unsubscribe : https://launchpad.net/~dhis2-users
> 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] Default form swap between row and column

[Nayeem Al Mifthah]

Dear Lars
Thanks for your clarification.

Could it go under near future development plan.

*Nayeem Al Mifthah*
*Consultant for HSS, Health MIS, M*
Email: n.mift...@gmail.com
Cell:+8801914030574
Skype: nayeem.a.m

On Tue, Oct 4, 2016 at 5:22 PM, Lars Helge Øverland  wrote:

> Hi Nayeem,
>
> I agree that would be useful. There are no immediate plans for this
> unfortunately. For now you will have to resort to a custom form.
>
> best regards,
>
> Lars
>
>
> On Tue, Oct 4, 2016 at 10:57 AM, Nayeem Al Mifthah 
> wrote:
>
>> Dear All
>> Is there any plan to give an option in Dataset edit to swap (transpose)
>> row and column in default form.
>>
>> In some of our forms, there are a number of category option which will be
>> better to see as row, and it will better if we can see data elements in
>> column. It may improve the view and print facility from dataset report and
>> data entry screen.
>>
>> It will be great if the option can be added in section management. So
>> that each section can view differently.
>>
>>
>> *Nayeem Al Mifthah*
>> *Consultant for HSS, Health MIS, M*
>> Email: n.mift...@gmail.com
>> Cell:+8801914030574
>> Skype: nayeem.a.m
>>
>
>
>
> --
> Lars Helge Øverland
> Lead developer, DHIS 2
> University of Oslo
> Skype: larshelgeoverland
> l...@dhis2.org
> 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] Default form swap between row and column

[Lars Helge Øverland]

Hi Nayeem,

I agree that would be useful. There are no immediate plans for this
unfortunately. For now you will have to resort to a custom form.

best regards,

Lars


On Tue, Oct 4, 2016 at 10:57 AM, Nayeem Al Mifthah 
wrote:

> Dear All
> Is there any plan to give an option in Dataset edit to swap (transpose)
> row and column in default form.
>
> In some of our forms, there are a number of category option which will be
> better to see as row, and it will better if we can see data elements in
> column. It may improve the view and print facility from dataset report and
> data entry screen.
>
> It will be great if the option can be added in section management. So that
> each section can view differently.
>
>
> *Nayeem Al Mifthah*
> *Consultant for HSS, Health MIS, M*
> Email: n.mift...@gmail.com
> Cell:+8801914030574
> Skype: nayeem.a.m
>



-- 
Lars Helge Øverland
Lead developer, DHIS 2
University of Oslo
Skype: larshelgeoverland
l...@dhis2.org
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] DHIS2 (2.22) not identifying user from SMS phone number

[Jasper Timm]

Hey devs,

We're currently working on an SMS submission method for our mobile app for
our data gathering.

Unfortunately it seems as though DHIS2 (v2.22) doesn't recognise the user's
number upon the initial receipt of SMS. However, when looking at the
'Received SMSs' log and running a 'Re-import' the SMS is then imported
successfully.

I have a feeling it may be related to the international '+' code at the
front of the phone number. Symptoms as follows:

* Our SMS gateway will always send a '+' at the front of the number (I've
tried removing the '+' with a manual submission as well, with no better
results).
* If the user's phone number in DHIS2 has a '+' in front, the 'Received
SMS' page will correctly list the user's username in the sender column but
when attempting a 'Re-import' it fails to find the associated user.
* If the user's phone number in DHIS2 does NOT have a '+' in front, the
'Received SMS' page will list the sender as 'unknown' but the SMS is
imported successfully for that user.
* In both cases, the SMS command initially fails with a 'No user found'
message.

On another note, it looks like the 'Received SMS' link on the main page of
the 'Mobile Configuration' page is broken, but the one in the sidebar seems
to work.

Logs below:

* INFO 2016-10-04 10:12:41,428 Received SMS: idsr
Zye0,4,ZyC5,0,Zyjp,4,ZyCi,1,Epe0,5,EpC5,0,Epjp,0,EpCi,0,iHe0,5,iHC5,5,iHjp,0,iHCi,0,drDA,SMS,BpDA,true,FHe0,4,FHC5,4
(SmsConsumerThread.java [taskScheduler-8])
* WARN 2016-10-04 10:12:41,448 Cannot get users with disjoint roles as user
does not have any user roles (DefaultUserService.java [taskScheduler-8])
* ERROR 2016-10-04 10:12:41,449 org.hisp.dhis.sms.parse.SMSParserException:
No user found for that phone number (SmsConsumerThread.java
[taskScheduler-8])
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at
org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
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
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
org.hisp.dhis.sms.parse.SMSParserException: No user found for that phone
number
at
org.hisp.dhis.sms.listener.DataValueSMSListener.receive(DataValueSMSListener.java:143)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
at
org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:207)
at com.sun.proxy.$Proxy102.receive(Unknown Source)
at
org.hisp.dhis.sms.SmsConsumerThread.spawnSmsConsumer(SmsConsumerThread.java:69)
at org.hisp.dhis.sms.SmsPublisher$1.run(SmsPublisher.java:61)
at
org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
at
java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
___
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] SQL Views Dependency Issue

[Lars Helge Øverland]

Hi Chathura,

currently the approach to achieve this is to rely on the alphabetical
ordering of SQL view names. For the scheduled tasks, the system first drops
the SQL views in *reversed* alphabetical order. Finally, the system
regenerates the SQL views in alphabetical order.

So in your case where A depends on B, you should ensure that that the name
of SQL view B comes before the name of SQL view A alphabetically. This way,
the system will first drop A, then B, and when it is time to regenerate the
views, first generate B, then A, and you should be good.

best regards,

Lars

On Tue, Oct 4, 2016 at 11:10 AM, chathura widanage <
chathurawidan...@gmail.com> wrote:

> Dear Devs,
>
> We have two SQLViews created in DHIS2 v2.24 where one view depends on
> other one(Say, A depends on B). We have also scheduled an automatic
> maintenance event every day at 12.00 a.m. Problem is DHIS2 tries to drop
> view B first during this automated procedure and as a result whole
> procedure fails including analytics table generation.
>
> Is there a way to make DHIS2 scheduled event drop A before B in above case.
>
> Thanks & Regards,
> Chathura Widanage
>
> ___
> 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
l...@dhis2.org
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] SQL Views Dependency Issue

[Sampath Jayasinghe]

Dear Chathura,

Why do u wanna drop the views at the first place?

Sampath

On Tue, Oct 4, 2016 at 2:40 PM, chathura widanage <
chathurawidan...@gmail.com> wrote:

> Dear Devs,
>
> We have two SQLViews created in DHIS2 v2.24 where one view depends on
> other one(Say, A depends on B). We have also scheduled an automatic
> maintenance event every day at 12.00 a.m. Problem is DHIS2 tries to drop
> view B first during this automated procedure and as a result whole
> procedure fails including analytics table generation.
>
> Is there a way to make DHIS2 scheduled event drop A before B in above case.
>
> Thanks & Regards,
> Chathura Widanage
>
> ___
> 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
>
>


-- 
A negative thinker see a difficulty in every opportunity..
A positive thinker see an opportunity in every difficulty..


He is able who thinks he is able.  ~ Buddha
___
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] Upgrading DHIS2 from 2.21 to 2.24 and using new exporter/importer

[Vanya Seth]

Hi Lars

Thanks for the response.

But have we only introduced not null constraints over different version
updates?

But am still not sure how the constraints get applied if the data does not
abide by the rules.

What looks like a reasonable process to me is :
- Update your database data to abide by the new constraints.
- Deploy the new war.

Thought?

Regards
Vanya


On Tue, Oct 4, 2016 at 1:27 PM, Lars Helge Øverland  wrote:

> Hi Vanya,
>
> sure. We definitely try to avoid this. See previous email in thread. The
> operand constraint has been removed. We will include not-null constraints
> in the upgrade notes.
>
> For 2.25  we will set the "created"
> and "lastupdated" columns of tables of "identifiable objects" to not-null.
>
> best regards,
>
> Lars
>
>
> On Tue, Oct 4, 2016 at 9:39 AM, Vanya Seth 
> wrote:
>
>> Hi Morten and Lars
>>
>> There are certain key points highlighted in the above email. Whenever a
>> new DHIS2 version comes out there are new integrity constraints added but
>> thats not part of the release or the upgrade notes.  So, whats the right
>> way to get information about these constraints?
>>
>> When we deploy the new war we assume that the TableAlteror will take care
>> of modifying the schema and also take care of adding the new constraints.
>> But in case the existing data does not abide by these constraints how do we
>> apply them?
>>
>> So, principally after a successful redeploy of the war of a higher
>> version can we say that the DHIS instance has been upgraded in its true
>> sense.
>> As of now it seems the war does get updated but the underlying database
>> does not.
>>
>> Needless to say this breaks the export /import of metadata downstream.
>>
>> Any insights about this would be appreciated.
>>
>> Regards
>> Vanya
>>
>>
>> On Thu, Sep 29, 2016 at 5:01 PM, Aamer Mohammed 
>> wrote:
>>
>>> Hi,
>>>
>>> For continuation of testing, we changed the metadata to ensure that a
>>> Group can be part of only one GroupSet.
>>> 1) We got the below issue.
>>> {"status":"ERROR","stats":{"total":1,"created":0,"updated":0
>>> ,"deleted":0,"ignored":1},"typeReports":[{"klass":"org.hisp.
>>> dhis.indicator.Indicator","stats":{"total":1,"created":0,"
>>> updated":0,"deleted":0,"ignored":1},"objectReports":[{"klass
>>> ":"org.hisp.dhis.indicator.Indicator","index":277,"uid":"
>>> oMbElS3lhOO","errorReports":[{"message":"Missing required property
>>> `numerator`.","mainKlass":"org.hisp.dhis.indicator.Indicator
>>> ","errorKlass":"java.lang.String","errorCode":"E4000"}]}]}]}
>>>
>>> which means that Numerator is required field for an indicator. This was
>>> not the case in 2.21. This restriction was introduced in some version after
>>> 2.21. However, we modified the metadata for the indicator having this issue
>>> and proceeded further.
>>>
>>> 2) Now we got the below issue.
>>> {"httpStatus":"Internal Server Error","httpStatusCode":500,"s
>>> tatus":"ERROR","message":"ERROR: duplicate key value violates unique
>>> constraint \"dataelement_operand_unique_key\"\n  Detail: Key
>>> (dataelementid, categoryoptioncomboid)=(4497, 3576) already exists."}
>>>
>>> This means that you cannot have duplicate combination of (dataelementid,
>>> categoryoptioncomboid) in dataelementoperand table. This constraint was not
>>> present in 2.21 version.
>>> When we see dataelementoperand table, there are lot of such duplicates.
>>> We would like to understand more around this constraint and why it was
>>> introduced.
>>> *Is there any note which has the details about the constraints being
>>> introduced in a DHIS version?*
>>>
>>> 3) Also this constraint (dataelement_operand_unique_key) is not present
>>> in the instance which was upgraded from 2.21 to 2.24. But it is present in
>>> the instance which is directly on 2.24. Any thoughts on this. Did the
>>> constraint not get created in upgraded instance because the data was not
>>> abiding to the constraint rules? What happens in a dhis upgrade if there is
>>> any constraint being introduced and existing data does not confirm to the
>>> constraint? Please suggest.
>>>
>>>
>>> Thanks
>>> Aamer.
>>>
>>>
>>> On Sat, Sep 24, 2016 at 5:54 PM, Lars Helge Øverland 
>>> wrote:
>>>
 Hi Aamer,

 the problem here happens because the hibernate mapping between GroupSet
 and Group is one-to-many, ie. a Group can only be part of one GroupSet.

 There is a reason for this, but it is not very good ;) When we store
 favorites with group sets, we need to know which dimension (GroupSet) a
 dimension item (Group) is part of. If the Group is part of many GroupSets,
 we need another link object in between to represent which dimension it is
 part of. This can clearly be done and this is something we plan to fix, but
 it is a bit of work and it requires an upgrade routine to upgrade existing
 databases.

 So I am 

[Dhis2-devs] SQL Views Dependency Issue

[chathura widanage]

Dear Devs,

We have two SQLViews created in DHIS2 v2.24 where one view depends on other
one(Say, A depends on B). We have also scheduled an automatic maintenance
event every day at 12.00 a.m. Problem is DHIS2 tries to drop view B first
during this automated procedure and as a result whole procedure fails
including analytics table generation.

Is there a way to make DHIS2 scheduled event drop A before B in above case.

Thanks & Regards,
Chathura Widanage
___
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] Default form swap between row and column

[Nayeem Al Mifthah]

Dear All
Is there any plan to give an option in Dataset edit to swap (transpose) row
and column in default form.

In some of our forms, there are a number of category option which will be
better to see as row, and it will better if we can see data elements in
column. It may improve the view and print facility from dataset report and
data entry screen.

It will be great if the option can be added in section management. So that
each section can view differently.


*Nayeem Al Mifthah*
*Consultant for HSS, Health MIS, M*
Email: n.mift...@gmail.com
Cell:+8801914030574
Skype: nayeem.a.m
___
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] Empty page when access the "Maintenance apps"

[gérard Bisama]

Thank  you!

2016-10-04 7:41 GMT+00:00 Mark Polak :

> Hey Gérard,
>
> We have moved the source code over from launchpad to github. So the most
> recent development will be done on github.
>
> As you can probably see on launchpad the last commit is already a few
> weeks old as we don't use it anymore.
>
> PS: added back the mailing list as it dropped off when i replied to you
> directly ;)
>
> On Mon, Oct 3, 2016 at 6:11 PM, gérard Bisama 
> wrote:
>
>> Hi Mark,
>>
>> I was able to run DHIS code from github and the maintenance page is
>> displayed now. My question is just about the preferrable repository to get
>> source code, it seems as if there is a lot of recent commits on launchpad
>> comparing to github. What can you advise to me, should I continue my
>> development with this version?
>>
>> Thank you
>>
>> 2016-10-03 15:00 GMT+00:00 gérard Bisama :
>>
>>> Hi Mark,
>>>
>>> I have used the last version from Lanchpad (bzr branch lp:dhis2). If I
>>> understand well you advice me to use the one on github?
>>>
>>> Thank you in advance,
>>>
>>> 2016-10-03 14:49 GMT+00:00 Mark Polak :
>>>
 Hey Gérard,

 When building from source you should probably build the latest versions
 from github[1].

 If you're still having the issue there then could you provide us with a
 screenshot of your chrome developer console?

 [1] https://github.com/dhis2/dhis2-core

 On Thu, Sep 29, 2016 at 2:20 PM, gérard Bisama 
 wrote:

> Chrome version: Version 53.0.2785.92 (64-bit)
>
> 2016-09-29 12:12 GMT+00:00 Knut Staring :
>
>> Version of Chrome?
>>
>> On 29 Sep 2016 1:45 p.m., "gérard Bisama" 
>> wrote:
>>
>>> Hi All,
>>>
>>> I  can not access to the Maintenance page after building DHIS2 form
>>> the launchpad source code. I have seen a bug reporting concerning this
>>> issue. Has it been solved if so how to fix it.
>>>
>>> Thank you
>>>
>>> --
>>> Gérard Bisama
>>> Tel:+243810890810
>>>
>>> ___
>>> 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
>>>
>>>
>
>
> --
> Gérard Bisama
> Tel:+243810890810
>
> ___
> 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
>
>


 --
 Regards,


 Mark Polak
 Software developer, DHIS 2
 University of Oslo
 http://www.dhis2.org 
 m...@dhis2.org

>>>
>>>
>>>
>>> --
>>> Gérard Bisama
>>> Tel:+243810890810
>>>
>>
>>
>>
>> --
>> Gérard Bisama
>> Tel:+243810890810
>>
>
>
>
> --
> Regards,
>
>
> Mark Polak
> Software developer, DHIS 2
> University of Oslo
> http://www.dhis2.org 
> m...@dhis2.org
>



-- 
Gérard Bisama
Tel:+243810890810
___
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] Upgrading DHIS2 from 2.21 to 2.24 and using new exporter/importer

[Lars Helge Øverland]

Hi Vanya,

sure. We definitely try to avoid this. See previous email in thread. The
operand constraint has been removed. We will include not-null constraints
in the upgrade notes.

For 2.25  we will set the "created" and
"lastupdated" columns of tables of "identifiable objects" to not-null.

best regards,

Lars


On Tue, Oct 4, 2016 at 9:39 AM, Vanya Seth  wrote:

> Hi Morten and Lars
>
> There are certain key points highlighted in the above email. Whenever a
> new DHIS2 version comes out there are new integrity constraints added but
> thats not part of the release or the upgrade notes.  So, whats the right
> way to get information about these constraints?
>
> When we deploy the new war we assume that the TableAlteror will take care
> of modifying the schema and also take care of adding the new constraints.
> But in case the existing data does not abide by these constraints how do we
> apply them?
>
> So, principally after a successful redeploy of the war of a higher version
> can we say that the DHIS instance has been upgraded in its true sense.
> As of now it seems the war does get updated but the underlying database
> does not.
>
> Needless to say this breaks the export /import of metadata downstream.
>
> Any insights about this would be appreciated.
>
> Regards
> Vanya
>
>
> On Thu, Sep 29, 2016 at 5:01 PM, Aamer Mohammed 
> wrote:
>
>> Hi,
>>
>> For continuation of testing, we changed the metadata to ensure that a
>> Group can be part of only one GroupSet.
>> 1) We got the below issue.
>> {"status":"ERROR","stats":{"total":1,"created":0,"updated":
>> 0,"deleted":0,"ignored":1},"typeReports":[{"klass":"org.hisp
>> .dhis.indicator.Indicator","stats":{"total":1,"created":0,
>> "updated":0,"deleted":0,"ignored":1},"objectReports":[{"
>> klass":"org.hisp.dhis.indicator.Indicator","index":277,"uid"
>> :"oMbElS3lhOO","errorReports":[{"message":"Missing required property
>> `numerator`.","mainKlass":"org.hisp.dhis.indicator.Indicator
>> ","errorKlass":"java.lang.String","errorCode":"E4000"}]}]}]}
>>
>> which means that Numerator is required field for an indicator. This was
>> not the case in 2.21. This restriction was introduced in some version after
>> 2.21. However, we modified the metadata for the indicator having this issue
>> and proceeded further.
>>
>> 2) Now we got the below issue.
>> {"httpStatus":"Internal Server Error","httpStatusCode":500,"s
>> tatus":"ERROR","message":"ERROR: duplicate key value violates unique
>> constraint \"dataelement_operand_unique_key\"\n  Detail: Key
>> (dataelementid, categoryoptioncomboid)=(4497, 3576) already exists."}
>>
>> This means that you cannot have duplicate combination of (dataelementid,
>> categoryoptioncomboid) in dataelementoperand table. This constraint was not
>> present in 2.21 version.
>> When we see dataelementoperand table, there are lot of such duplicates.
>> We would like to understand more around this constraint and why it was
>> introduced.
>> *Is there any note which has the details about the constraints being
>> introduced in a DHIS version?*
>>
>> 3) Also this constraint (dataelement_operand_unique_key) is not present
>> in the instance which was upgraded from 2.21 to 2.24. But it is present in
>> the instance which is directly on 2.24. Any thoughts on this. Did the
>> constraint not get created in upgraded instance because the data was not
>> abiding to the constraint rules? What happens in a dhis upgrade if there is
>> any constraint being introduced and existing data does not confirm to the
>> constraint? Please suggest.
>>
>>
>> Thanks
>> Aamer.
>>
>>
>> On Sat, Sep 24, 2016 at 5:54 PM, Lars Helge Øverland 
>> wrote:
>>
>>> Hi Aamer,
>>>
>>> the problem here happens because the hibernate mapping between GroupSet
>>> and Group is one-to-many, ie. a Group can only be part of one GroupSet.
>>>
>>> There is a reason for this, but it is not very good ;) When we store
>>> favorites with group sets, we need to know which dimension (GroupSet) a
>>> dimension item (Group) is part of. If the Group is part of many GroupSets,
>>> we need another link object in between to represent which dimension it is
>>> part of. This can clearly be done and this is something we plan to fix, but
>>> it is a bit of work and it requires an upgrade routine to upgrade existing
>>> databases.
>>>
>>> So I am pretty sure that is why you see these duplicates: You have
>>> groups which are part of multiple group sets. In these cases, Hibernate
>>> will create duplicate GroupSets as a result of the database integrity issue.
>>>
>>> So short term solution is to change the metadata, long term we will fix
>>> this properly and allow for many-to-many between Group and GroupSet.
>>>
>>> regards,
>>>
>>> Lars
>>>
>>>
>>>
>>>
>>>
>>> On Thu, Sep 15, 2016 at 7:28 AM, Morten Olav Hansen 
>>> wrote:
>>>
 Hi Aamer

 Lars knows what is wrong, he will provide 

Re: [Dhis2-devs] Upgrading DHIS2 from 2.21 to 2.24 and using new exporter/importer

[Lars Helge Øverland]

Hi Aamer,


On Thu, Sep 29, 2016 at 1:31 PM, Aamer Mohammed 
wrote:

> Hi,
>
> For continuation of testing, we changed the metadata to ensure that a
> Group can be part of only one GroupSet.
> 1) We got the below issue.
> {"status":"ERROR","stats":{"total":1,"created":0,"updated"
> :0,"deleted":0,"ignored":1},"typeReports":[{"klass":"org.
> hisp.dhis.indicator.Indicator","stats":{"total":1,"created":
> 0,"updated":0,"deleted":0,"ignored":1},"objectReports":[{
> "klass":"org.hisp.dhis.indicator.Indicator","index":
> 277,"uid":"oMbElS3lhOO","errorReports":[{"message":"Missing required
> property `numerator`.","mainKlass":"org.hisp.dhis.indicator.
> Indicator","errorKlass":"java.lang.String","errorCode":"E4000"}]}]}]}
>
> which means that Numerator is required field for an indicator. This was
> not the case in 2.21. This restriction was introduced in some version after
> 2.21. However, we modified the metadata for the indicator having this issue
> and proceeded further.
>
>
Right, we did make indicator numerator and denominator not-null in the
schema. You can say that this is something we should have done from the
very start. In 2.24 we tightened up the schema, which is very helpful to
avoid problems in the source code, but could require some modifications in
existing solutions.




> 2) Now we got the below issue.
> {"httpStatus":"Internal Server Error","httpStatusCode":500,"
> status":"ERROR","message":"ERROR: duplicate key value violates unique
> constraint \"dataelement_operand_unique_key\"\n  Detail: Key
> (dataelementid, categoryoptioncomboid)=(4497, 3576) already exists."}
>
> This means that you cannot have duplicate combination of (dataelementid,
> categoryoptioncomboid) in dataelementoperand table. This constraint was not
> present in 2.21 version.
> When we see dataelementoperand table, there are lot of such duplicates. We
> would like to understand more around this constraint and why it was
> introduced.
> *Is there any note which has the details about the constraints being
> introduced in a DHIS version?*
>

This is interesting because i) it has been like this for many years and ii)
I agree this constraint should not be there. Not sure why this surfaced now
- likely because you have started a new db. I have removed this constraint
in master and 2.24 now.


best regards,

Lars


> 3) Also this constraint (dataelement_operand_unique_key) is not present
> in the instance which was upgraded from 2.21 to 2.24. But it is present in
> the instance which is directly on 2.24. Any thoughts on this. Did the
> constraint not get created in upgraded instance because the data was not
> abiding to the constraint rules? What happens in a dhis upgrade if there is
> any constraint being introduced and existing data does not confirm to the
> constraint? Please suggest.
>
>
> Thanks
> Aamer.
>
>
> On Sat, Sep 24, 2016 at 5:54 PM, Lars Helge Øverland 
> wrote:
>
>> Hi Aamer,
>>
>> the problem here happens because the hibernate mapping between GroupSet
>> and Group is one-to-many, ie. a Group can only be part of one GroupSet.
>>
>> There is a reason for this, but it is not very good ;) When we store
>> favorites with group sets, we need to know which dimension (GroupSet) a
>> dimension item (Group) is part of. If the Group is part of many GroupSets,
>> we need another link object in between to represent which dimension it is
>> part of. This can clearly be done and this is something we plan to fix, but
>> it is a bit of work and it requires an upgrade routine to upgrade existing
>> databases.
>>
>> So I am pretty sure that is why you see these duplicates: You have groups
>> which are part of multiple group sets. In these cases, Hibernate will
>> create duplicate GroupSets as a result of the database integrity issue.
>>
>> So short term solution is to change the metadata, long term we will fix
>> this properly and allow for many-to-many between Group and GroupSet.
>>
>> regards,
>>
>> Lars
>>
>>
>>
>>
>>
>> On Thu, Sep 15, 2016 at 7:28 AM, Morten Olav Hansen 
>> wrote:
>>
>>> Hi Aamer
>>>
>>> Lars knows what is wrong, he will provide a fix shortly :)
>>>
>>> --
>>> Morten Olav Hansen
>>> Senior Engineer, DHIS 2
>>> University of Oslo
>>> http://www.dhis2.org
>>>
>>> On Thu, Sep 15, 2016 at 12:26 PM, Aamer Mohammed <
>>> aam...@thoughtworks.com> wrote:
>>>
 Thanks Morten. Let us know if any other details are required from our
 end in this regard.

 Thanks
 Aamer.

 On Mon, Sep 12, 2016 at 6:01 PM, Morten Olav Hansen 
 wrote:

> That's interesting.
>
> @Lars any suggestions why this happens? I guess there is something
> wrong with our mapping. Will have a look tomorrow.
>
> --
> Morten Olav Hansen
> Senior Engineer, DHIS 2
> University of Oslo
> http://www.dhis2.org
>
> On Mon, Sep 12, 2016 at 5:42 PM, Victor Garcia 
> wrote:
>

Re: [Dhis2-devs] Empty page when access the "Maintenance apps"

[Mark Polak]

Hey Gérard,

We have moved the source code over from launchpad to github. So the most
recent development will be done on github.

As you can probably see on launchpad the last commit is already a few weeks
old as we don't use it anymore.

PS: added back the mailing list as it dropped off when i replied to you
directly ;)

On Mon, Oct 3, 2016 at 6:11 PM, gérard Bisama  wrote:

> Hi Mark,
>
> I was able to run DHIS code from github and the maintenance page is
> displayed now. My question is just about the preferrable repository to get
> source code, it seems as if there is a lot of recent commits on launchpad
> comparing to github. What can you advise to me, should I continue my
> development with this version?
>
> Thank you
>
> 2016-10-03 15:00 GMT+00:00 gérard Bisama :
>
>> Hi Mark,
>>
>> I have used the last version from Lanchpad (bzr branch lp:dhis2). If I
>> understand well you advice me to use the one on github?
>>
>> Thank you in advance,
>>
>> 2016-10-03 14:49 GMT+00:00 Mark Polak :
>>
>>> Hey Gérard,
>>>
>>> When building from source you should probably build the latest versions
>>> from github[1].
>>>
>>> If you're still having the issue there then could you provide us with a
>>> screenshot of your chrome developer console?
>>>
>>> [1] https://github.com/dhis2/dhis2-core
>>>
>>> On Thu, Sep 29, 2016 at 2:20 PM, gérard Bisama 
>>> wrote:
>>>
 Chrome version: Version 53.0.2785.92 (64-bit)

 2016-09-29 12:12 GMT+00:00 Knut Staring :

> Version of Chrome?
>
> On 29 Sep 2016 1:45 p.m., "gérard Bisama" 
> wrote:
>
>> Hi All,
>>
>> I  can not access to the Maintenance page after building DHIS2 form
>> the launchpad source code. I have seen a bug reporting concerning this
>> issue. Has it been solved if so how to fix it.
>>
>> Thank you
>>
>> --
>> Gérard Bisama
>> Tel:+243810890810
>>
>> ___
>> 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
>>
>>


 --
 Gérard Bisama
 Tel:+243810890810

 ___
 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


>>>
>>>
>>> --
>>> Regards,
>>>
>>>
>>> Mark Polak
>>> Software developer, DHIS 2
>>> University of Oslo
>>> http://www.dhis2.org 
>>> m...@dhis2.org
>>>
>>
>>
>>
>> --
>> Gérard Bisama
>> Tel:+243810890810
>>
>
>
>
> --
> Gérard Bisama
> Tel:+243810890810
>



-- 
Regards,


Mark Polak
Software developer, DHIS 2
University of Oslo
http://www.dhis2.org 
m...@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] Upgrading DHIS2 from 2.21 to 2.24 and using new exporter/importer

[Vanya Seth]

Hi Morten and Lars

There are certain key points highlighted in the above email. Whenever a new
DHIS2 version comes out there are new integrity constraints added but thats
not part of the release or the upgrade notes.  So, whats the right way to
get information about these constraints?

When we deploy the new war we assume that the TableAlteror will take care
of modifying the schema and also take care of adding the new constraints.
But in case the existing data does not abide by these constraints how do we
apply them?

So, principally after a successful redeploy of the war of a higher version
can we say that the DHIS instance has been upgraded in its true sense.
As of now it seems the war does get updated but the underlying database
does not.

Needless to say this breaks the export /import of metadata downstream.

Any insights about this would be appreciated.

Regards
Vanya


On Thu, Sep 29, 2016 at 5:01 PM, Aamer Mohammed 
wrote:

> Hi,
>
> For continuation of testing, we changed the metadata to ensure that a
> Group can be part of only one GroupSet.
> 1) We got the below issue.
> {"status":"ERROR","stats":{"total":1,"created":0,"updated"
> :0,"deleted":0,"ignored":1},"typeReports":[{"klass":"org.
> hisp.dhis.indicator.Indicator","stats":{"total":1,"created":
> 0,"updated":0,"deleted":0,"ignored":1},"objectReports":[{
> "klass":"org.hisp.dhis.indicator.Indicator","index":
> 277,"uid":"oMbElS3lhOO","errorReports":[{"message":"Missing required
> property `numerator`.","mainKlass":"org.hisp.dhis.indicator.
> Indicator","errorKlass":"java.lang.String","errorCode":"E4000"}]}]}]}
>
> which means that Numerator is required field for an indicator. This was
> not the case in 2.21. This restriction was introduced in some version after
> 2.21. However, we modified the metadata for the indicator having this issue
> and proceeded further.
>
> 2) Now we got the below issue.
> {"httpStatus":"Internal Server Error","httpStatusCode":500,"
> status":"ERROR","message":"ERROR: duplicate key value violates unique
> constraint \"dataelement_operand_unique_key\"\n  Detail: Key
> (dataelementid, categoryoptioncomboid)=(4497, 3576) already exists."}
>
> This means that you cannot have duplicate combination of (dataelementid,
> categoryoptioncomboid) in dataelementoperand table. This constraint was not
> present in 2.21 version.
> When we see dataelementoperand table, there are lot of such duplicates. We
> would like to understand more around this constraint and why it was
> introduced.
> *Is there any note which has the details about the constraints being
> introduced in a DHIS version?*
>
> 3) Also this constraint (dataelement_operand_unique_key) is not present
> in the instance which was upgraded from 2.21 to 2.24. But it is present in
> the instance which is directly on 2.24. Any thoughts on this. Did the
> constraint not get created in upgraded instance because the data was not
> abiding to the constraint rules? What happens in a dhis upgrade if there is
> any constraint being introduced and existing data does not confirm to the
> constraint? Please suggest.
>
>
> Thanks
> Aamer.
>
>
> On Sat, Sep 24, 2016 at 5:54 PM, Lars Helge Øverland 
> wrote:
>
>> Hi Aamer,
>>
>> the problem here happens because the hibernate mapping between GroupSet
>> and Group is one-to-many, ie. a Group can only be part of one GroupSet.
>>
>> There is a reason for this, but it is not very good ;) When we store
>> favorites with group sets, we need to know which dimension (GroupSet) a
>> dimension item (Group) is part of. If the Group is part of many GroupSets,
>> we need another link object in between to represent which dimension it is
>> part of. This can clearly be done and this is something we plan to fix, but
>> it is a bit of work and it requires an upgrade routine to upgrade existing
>> databases.
>>
>> So I am pretty sure that is why you see these duplicates: You have groups
>> which are part of multiple group sets. In these cases, Hibernate will
>> create duplicate GroupSets as a result of the database integrity issue.
>>
>> So short term solution is to change the metadata, long term we will fix
>> this properly and allow for many-to-many between Group and GroupSet.
>>
>> regards,
>>
>> Lars
>>
>>
>>
>>
>>
>> On Thu, Sep 15, 2016 at 7:28 AM, Morten Olav Hansen 
>> wrote:
>>
>>> Hi Aamer
>>>
>>> Lars knows what is wrong, he will provide a fix shortly :)
>>>
>>> --
>>> Morten Olav Hansen
>>> Senior Engineer, DHIS 2
>>> University of Oslo
>>> http://www.dhis2.org
>>>
>>> On Thu, Sep 15, 2016 at 12:26 PM, Aamer Mohammed <
>>> aam...@thoughtworks.com> wrote:
>>>
 Thanks Morten. Let us know if any other details are required from our
 end in this regard.

 Thanks
 Aamer.

 On Mon, Sep 12, 2016 at 6:01 PM, Morten Olav Hansen 
 wrote:

> That's interesting.
>
> @Lars any suggestions why this happens? I guess there is something