Re: [Dhis2-users] Database being cleared after Tomcat shutdown

2017-08-31 Thread Edward Robinson 
Hi, I am working with 2.16 and am in the process of upgrading but will not be 
doing that on the live servers – I need to get this working offline on 2.16 
before performing the upgrade.
Regards
Ed

From: Em Le Hong [mailto:em.hispviet...@gmail.com]
Sent: Thursday, 31 August 2017 3:42 PM
To: Edward Robinson 
Cc: DHIS 2 Users list 
Subject: Re: [Dhis2-users] Database being cleared after Tomcat shutdown

Hi again,

If you upgrade from 2.16 to 2.22 or above 2.22, you have to change the 
configuration file from hibernate.properties to dhis.conf. Otherwise, it can't 
connect to the correct database.

Read here to check how to create dhis.conf file.

https://docs.dhis2.org/2.22/en/implementer/html/ch08s03.html#d5e500

On Thu, Aug 31, 2017 at 8:29 PM, Em Le Hong 
> wrote:
Hi,

Which version are you working on? for the recent new version, DHIS2 no longer 
use hibernate.properties file.

Read the upgrade note here:
https://www.dhis2.org/222-upgrade

On Thu, Aug 31, 2017 at 6:32 PM, Edward Robinson 
> wrote:
I know this is not an uncommon issue and I recall it relates to a configuration 
problem if I’m not mistaken, but for the life of me I cannot fathom why two 
machines I am working with seem to exhibit this behaviour consistently.  I have 
a couple of Windows test servers set up to facilitate an offline upgrade from 
2.16 but I’m unable to resolve this on these two machines.  I’ve seen this on 
Linux as well so assume it’s not OS related.

In a nutshell, the system appears to start up fine, I am able to login and 
access the system, create data elements, create users, etc. but when Tomcat is 
shut down, the database is cleared except for the aggregate tables (all other 
tables are dropped):
[cid:image001.jpg@01D32298.C3F1E660]

When Tomcat is started again, obviously the data is no longer there.  As long 
as it’s running, all appears well in the tables:
[cid:image003.jpg@01D32298.C3F1E660]

I have attached a copy of the logs as well as my hibernate.properties file 
(dummy password) and my system variables.  I’ve also attached a screenshot of 
the ‘about DHIS2’ page for reference.

As far as I can see, the only issues / errors on startup include:
A bunch of ERROR for database constraint drop scripts on startup – because the 
database does not yet exist – I assume these are benign.
Some WARN messages:
   “[127.0.0.1]:5701 [dev] [3.2.1] No join method is enabled! 
Starting standalone. (HazelcastInstanceImpl.java [localhost-startStop-1])”
   “RP discovery / realm validation disabled;  (RealmVerifier.java 
[localhost-startStop-1])”
   “Did not find any ViewResolvers to delegate to; please configure 
them using the 'viewResolvers' property on the ContentNegotiatingViewResolver 
(ContentNegotiatingViewResolver.java [localhost-startStop-1])”

Any idea what could be causing this?

___
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



--
Em Le Hong
DHIS2 Implementation| HISP Vietnam
em.hispviet...@gmail.com | Skype: 
em.hispviet...@gmail.com

[https://drive.google.com/uc?id=0B-tlJrv190f5dmR1Y0t2NERvcVU=download]






--
Em Le Hong
DHIS2 Implementation| HISP Vietnam
em.hispviet...@gmail.com | Skype: 
em.hispviet...@gmail.com

[https://drive.google.com/uc?id=0B-tlJrv190f5dmR1Y0t2NERvcVU=download]



___
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] Change to EPI weeks affect existing pivot data reporting rate

2017-08-31 Thread Peter D Lubambi 
Hi all,
I have a data set that is reported on weekly basis, after learning about
EPI week I changed period data set to start on Saturday(this how is
supposed to be). It seems this has affected my data on graphs and reporting
rate, I see the data on the data entry but not on analytics, Is there more
configuration need to see the data on analytics and reporting rate?

Regards,

Peter Dotto Lubambi,
Skype: plubambi
Mobile: +255 786 087 087
___
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] Database being cleared after Tomcat shutdown

2017-08-31 Thread Em Le Hong 
Hi again,

If you upgrade from 2.16 to 2.22 or above 2.22, you have to change the
configuration file from hibernate.properties to dhis.conf. Otherwise, it
can't connect to the correct database.

Read here to check how to create dhis.conf file.

https://docs.dhis2.org/2.22/en/implementer/html/ch08s03.html#d5e500

On Thu, Aug 31, 2017 at 8:29 PM, Em Le Hong 
wrote:

> Hi,
>
> Which version are you working on? for the recent new version, DHIS2 no
> longer use hibernate.properties file.
>
> Read the upgrade note here:
> https://www.dhis2.org/222-upgrade
>
> On Thu, Aug 31, 2017 at 6:32 PM, Edward Robinson <
> erobin...@projectbalance.com> wrote:
>
>> I know this is not an uncommon issue and I recall it relates to a
>> configuration problem if I’m not mistaken, but for the life of me I cannot
>> fathom why two machines I am working with seem to exhibit this behaviour
>> consistently.  I have a couple of Windows test servers set up to facilitate
>> an offline upgrade from 2.16 but I’m unable to resolve this on these two
>> machines.  I’ve seen this on Linux as well so assume it’s not OS related.
>>
>>
>>
>> In a nutshell, the system appears to start up fine, I am able to login
>> and access the system, create data elements, create users, etc. but when
>> Tomcat is shut down, the database is cleared except for the aggregate
>> tables (all other tables are dropped):
>>
>>
>>
>> When Tomcat is started again, obviously the data is no longer there.  As
>> long as it’s running, all appears well in the tables:
>>
>>
>>
>> I have attached a copy of the logs as well as my hibernate.properties
>> file (dummy password) and my system variables.  I’ve also attached a
>> screenshot of the ‘about DHIS2’ page for reference.
>>
>>
>>
>> As far as I can see, the only issues / errors on startup include:
>>
>> A bunch of ERROR for database constraint drop scripts on startup –
>> because the database does not yet exist – I assume these are benign.
>>
>> Some WARN messages:
>>
>>“[127.0.0.1]:5701 [dev] [3.2.1] No join method is enabled!
>> Starting standalone. (HazelcastInstanceImpl.java [localhost-startStop-1])”
>>
>>“RP discovery / realm validation disabled;
>> (RealmVerifier.java [localhost-startStop-1])”
>>
>>“Did not find any ViewResolvers to delegate to; please
>> configure them using the 'viewResolvers' property on the
>> ContentNegotiatingViewResolver (ContentNegotiatingViewResolver.java
>> [localhost-startStop-1])”
>>
>>
>>
>> Any idea what could be causing this?
>>
>> ___
>> 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
>>
>>
>
>
> --
> *Em Le Hong*
> DHIS2 Implementation| *HISP Vietnam *
> em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.com
>
>
>
>
>
>


-- 
*Em Le Hong*
DHIS2 Implementation| *HISP Vietnam *
em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.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

Re: [Dhis2-users] Database being cleared after Tomcat shutdown

2017-08-31 Thread Em Le Hong 
Hi,

Which version are you working on? for the recent new version, DHIS2 no
longer use hibernate.properties file.

Read the upgrade note here:
https://www.dhis2.org/222-upgrade

On Thu, Aug 31, 2017 at 6:32 PM, Edward Robinson <
erobin...@projectbalance.com> wrote:

> I know this is not an uncommon issue and I recall it relates to a
> configuration problem if I’m not mistaken, but for the life of me I cannot
> fathom why two machines I am working with seem to exhibit this behaviour
> consistently.  I have a couple of Windows test servers set up to facilitate
> an offline upgrade from 2.16 but I’m unable to resolve this on these two
> machines.  I’ve seen this on Linux as well so assume it’s not OS related.
>
>
>
> In a nutshell, the system appears to start up fine, I am able to login and
> access the system, create data elements, create users, etc. but when Tomcat
> is shut down, the database is cleared except for the aggregate tables (all
> other tables are dropped):
>
>
>
> When Tomcat is started again, obviously the data is no longer there.  As
> long as it’s running, all appears well in the tables:
>
>
>
> I have attached a copy of the logs as well as my hibernate.properties file
> (dummy password) and my system variables.  I’ve also attached a screenshot
> of the ‘about DHIS2’ page for reference.
>
>
>
> As far as I can see, the only issues / errors on startup include:
>
> A bunch of ERROR for database constraint drop scripts on startup – because
> the database does not yet exist – I assume these are benign.
>
> Some WARN messages:
>
>“[127.0.0.1]:5701 [dev] [3.2.1] No join method is enabled!
> Starting standalone. (HazelcastInstanceImpl.java [localhost-startStop-1])”
>
>“RP discovery / realm validation disabled;
> (RealmVerifier.java [localhost-startStop-1])”
>
>“Did not find any ViewResolvers to delegate to; please
> configure them using the 'viewResolvers' property on the
> ContentNegotiatingViewResolver (ContentNegotiatingViewResolver.java
> [localhost-startStop-1])”
>
>
>
> Any idea what could be causing this?
>
> ___
> 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
>
>


-- 
*Em Le Hong*
DHIS2 Implementation| *HISP Vietnam *
em.hispviet...@gmail.com | *Skype:* em.hispviet...@gmail.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

Re: [Dhis2-users] Online Academies

2017-08-31 Thread Edward Robinson 
Excellent, thanks for this Knut, I’ll take a look,
Cheers
Ed

From: Knut Staring [mailto:knu...@gmail.com]
Sent: Wednesday, 30 August 2017 9:55 PM
To: Edward Robinson 
Cc: DHIS 2 Users list 
Subject: Re: [Dhis2-users] Online Academies

Hi Ed,

Are you familiar with this?
https://academy.dhis2.org/courses/HISP/DHIS2_Level1/2015_Q1/about

Regards,
Knut

On Wed, Aug 30, 2017 at 5:20 PM, Edward Robinson 
> wrote:
Are there any DHIS2 MOOCs available or in planning?  One of the issues I know a 
lot of partners are having is finding the budget to send staff to attend 
academies in person.  Not as much the cost of the academy itself but the travel 
and the frequency – it’s very hard to plan a project around that sort of 
schedule and staff turnover / training new staff can be a real challenge.
A distance learning system would be fantastic, particularly if official 
certification can be issued on completion.  Even if staff can be sent to a 
regional centre to write an exam after self study (such as Unisa do in South 
Africa), it would be a major cost saving and allow projects to have more staff 
certified – something I believe would benefit the community immensely.

Ed


Edward Robinson
Technical Director
Project Balance
www.projectbalance.com
tel. +27 74 587 6667

[PB Logo]


___
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



--
Knut Staring
Dept. of Informatics, University of Oslo
Norway: +4791880522
Skype: knutstar
http://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] Online Academies

2017-08-31 Thread gerald thomas 
Dear Knut,

Thanks for the reminder because i had completed this course long ago
and it is only now i noticed that i had never requested for my
certificate.

Edward,
I think you staff can try this program and it is very interactive.
Wishing them all the best anyway.

Thanks Knut for the reminder


On 8/30/17, Knut Staring  wrote:
> Hi Ed,
>
> Are you familiar with this?
> https://academy.dhis2.org/courses/HISP/DHIS2_Level1/2015_Q1/about
>
> Regards,
> Knut
>
> On Wed, Aug 30, 2017 at 5:20 PM, Edward Robinson <
> erobin...@projectbalance.com> wrote:
>
>> Are there any DHIS2 MOOCs available or in planning?  One of the issues I
>> know a lot of partners are having is finding the budget to send staff to
>> attend academies in person.  Not as much the cost of the academy itself
>> but
>> the travel and the frequency – it’s very hard to plan a project around
>> that
>> sort of schedule and staff turnover / training new staff can be a real
>> challenge.
>>
>> A distance learning system would be fantastic, particularly if official
>> certification can be issued on completion.  Even if staff can be sent to
>> a
>> regional centre to write an exam after self study (such as Unisa do in
>> South Africa), it would be a major cost saving and allow projects to have
>> more staff certified – something I believe would benefit the community
>> immensely.
>>
>>
>>
>> Ed
>>
>>
>>
>> 
>>
>> Edward Robinson
>>
>> Technical Director
>>
>> Project Balance
>>
>> www.projectbalance.com
>>
>> tel. +27 74 587 6667 <+27%2074%20587%206667>
>>
>>
>>
>> [image: PB Logo] 
>>
>>
>>
>> ___
>> 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
>>
>>
>
>
> --
> Knut Staring
> Dept. of Informatics, University of Oslo
> Norway: +4791880522
> Skype: knutstar
> http://dhis2.org
>


-- 
Regards,

Gerald

___
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